The log from the first backup is a little baffling because Oracle is claiming that it cannot find the archive log but Data Protection for Oracle is not complaining. Compare it to the second log where DP for Oracle is actually giving an error that the archive log requested by Oracle cannot be found on the TSM Server. The information that you have given me thus far does not tell me much.
However, in this RAC environment are you backing up your data all from the same node in the cluster? If not are you duplicating the DP for Oracle nodename to all DP for Oracle nodes so that all the backups are cataloged to the TSM Server under the same node? The most common problem seen in RAC environments are the fact that backups are done from different nodes from within the environment but each node is using slightly different TSM/TDP options so that during the restore to a particular node not all of the backup information can be retrieved. These are just some thoughts that I have. If none of this helps I highly suggest that you use our support channels to resolve this problem; they are knowledgable in this area. ------------------------------ Date: Wed, 24 Sep 2003 18:55:06 +0200 From: Nalevajko Tomas <[EMAIL PROTECTED]> Subject: Oracle Recovery failed 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 ------------------------------ Regards, Neil Rasmussen Software Development TDP for Oracle [EMAIL PROTECTED]