Spfile restore from RMAN Tape backup to different server
ssspAug 3 2011 — edited Aug 4 2011Hi All,
First of all let me thank you to the forum from which I keep updating my knowledge on oracle.
I am having issues when trying to restore spfile from controlfile autobackup to different server. Problem and other details are below:
Target version : 10.2.0.2
Netbackup : 6.5.6
Taken the tape backup through rman on server ABC and trying to restore the spfile from controlfile autobackup to server XYZ. Tape backup has been taken today morning and trying restore now.
Both servers ABC and XYX have been added (as clients) to netbackup policy.
Below is the syntax I used for restoring spfile and getting error as mentioned.
RMAN> run {
2> set controlfile autobackup format for device type 'SBT_TAPE' to '%F';
3> allocate channel ch00 device type 'sbt_tape'
4> parms='ENV=(NB_ORA_SERV=Mediaserver,NB_ORA_CLIENT=XYZ)';
5> restore spfile to pfile '/oracle/product/10g/dbs/inittest.ora' from
6> autobackup maxseq 5 maxdays 3;
7> }
executing command: SET CONTROLFILE AUTOBACKUP FORMAT
allocated channel: ch00
channel ch00: sid=36 devtype=SBT_TAPE
channel ch00: Veritas NetBackup for Oracle - Release 6.5 (2010042405)
Starting restore at 03-AUG-2011
channel ch00: looking for autobackup on day: 20110803
channel ch00: looking for autobackup on day: 20110802
channel ch00: looking for autobackup on day: 20110801
channel ch00: no autobackup in 3 days found
released channel: ch00
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 08/03/2011 14:03:26
RMAN-06172: no autobackup found or specified handle is not a valid copy or piece
Not sure where I am doing wrong. The same can be restored onto same host (I.E ABC) without any issues .
Request your help and guidance.
Thanks,
SSS