Hello guys,

I encounter problems in oracle recovery and I'd like to ask for some
suggestion what to check or change.

We have implemented TDP for Oracle. There is Oracle RAC. Backup entire
database succeed. Problems are if we try to make recovery. Restore process
goes ok, all dbf files are restored. There are failure in recovery when
restoring/recovering archive log files.

this is portion of log file from first try:

Starting recover at 23-SEP-03

starting media recovery

channel node2: starting archive log restore to default destination
channel node1: starting archive log restore to default destination
channel node2: restoring archive log
archive log thread=2 sequence=344
channel node1: restoring archive log
archive log thread=1 sequence=798
channel node1: restored backup piece 1
piece handle=fjf20obo_1_1 tag=TAG20030922T233624 params=NULL
channel node1: restore complete
unable to find archive log
archive log thread=1 sequence=798
released channel: node1
released channel: node2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 09/23/2003 09:08:20
RMAN-06055: could not find log sequence 798 thread 1

RMAN> **end-of-file**

and something like this in another try:

channel node1: starting archive log restore to default destination
channel node2: starting archive log restore to default destination
channel node1: restoring archive log
archive log thread=1 sequence=800
channel node2: restoring archive log
archive log thread=1 sequence=801
channel node1: restored backup piece 1
piece handle=frf21o42_1_1 tag=TAG20030923T083826 params=NULL
channel node1: restore complete
released channel: node1
released channel: node2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 09/23/2003 12:09:25
ORA-19507: failed to retrieve sequential file, handle="fvf21p7c_1_1", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
   ANS1302E (RC2)    No objects on server match query

RMAN> **end-of-file**

There is also non clustered databse on one node. We did not see any problems
with this database.

Several tries was made. Finally, it recovered successfuly but during another
restore/recovery after database backup it behaves same as before.

Any ideas or suggestions? Thanks.

--
Nalevajko Tomas

e-mail: nalevajk AT dcs.fmph.uniba DOT sk
homepage: www.dcs.fmph.uniba.sk/~nalevajk