Hi,
I try to start the backup job with oracle sid: testdb from hostname:w2003-oracle server, and the autobackup controlfile is on. The backup and restore from w2003-oracle is work fine. I want to restore the testdb to hostname: w2003-oracle-uat , and no.restrictions is set up on /db/altename folder already.
I start to restore the control file from w2003-oracle-uat with following steps,
sqlplus> shutdown immediate;
sqlplus> shartup nomount;
rman target testdb
set dbid 2480568534;
run {
allocate channel c1 type 'SBT_TAPE';
send 'NB_ORA_POLICY=Test-Oracle,NB_ORA_SERV=w2003-nbu';
restore controlfile from autobackup maxdays=1 ;
}
But the result show on rman,
channel c1: looking for AUTOBACKUP on day: 20090914
channel c1: no AUTOBACKUP in 1 days found
released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 09/14/2009 07:21:19
RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece
I cannot find any doc and procedure related how to restore oracle db to other server without recovery catalog. Please advice any procedure to restore the oracle db to other netbackup client. Thanks a lots.
