There is not a lot information on rman log. It is much better to use
sbtio.log like an alternative information source about what is happening.
Which is the sbtio.log message  ?


Por favor, responda a "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
Enviado por:    "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
Destinatarios:        ADSM-L AT VM.MARIST DOT EDU
CC:
Asunto:        Re: Oracle Recovery failed


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 <nalevajk AT DCS.FMPH.UNIBA DOT SK>
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: nalevajk AT dcs.fmph.uniba DOT sk
homepage: www.dcs.fmph.uniba.sk/~nalevajk

------------------------------


Regards,

Neil Rasmussen
Software Development
TDP for Oracle
rasmussn AT us.ibm DOT com