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: [EMAIL PROTECTED] homepage: www.dcs.fmph.uniba.sk/~nalevajk
