Autobackup not found by RMAN

From: Mark Moynahan <mark.moynahan_at_apollogrp.edu>
Date: Tue, 1 Nov 2005 09:51:12 -0700
Message-ID: <981737DE2227B94A97F3529DD17933CBD72F0C@AMSGEV01.apollogrp.edu>

OS: RH 3.5
DB: 10.1.0.3
Media software: Veritas Netbackup 5.1

I'm in the process of documenting our DR procedure. Our testing includes recovering from disk and tape. So far recovering from disk has been relatively painless. In contrast, recovering from tape has proven to be less successful. Right now I can't get past the steps to restore the spfile to pfile from autobackup. Has anyone run across this same problem when restoring the spfile to pfile from autobackup from tape? Listed below is the backup and restore commands.

Backup:

CONFIGURE DEVICE TYPE sbt BACKUP TYPE TO BACKUPSET; CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE sbt_tape TO
'cf_%F';

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 14 DAYS; run {

allocate channel t1 type 'SBT_TAPE' parms
'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so,ENV=(NB_ORA_SCHED=ORACLE
_DB,NB_ORA_CLIENT=jivrac1,NB_ORA_CLASS=OLS3_WIU_ORACLE)';

allocate channel t2 type 'SBT_TAPE' parms
'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so,ENV=(NB_ORA_SCHED=ORACLE
_DB,NB_ORA_CLIENT=jivrac1,NB_ORA_CLASS=OLS3_WIU_ORACLE)';

allocate channel t3 type 'SBT_TAPE' parms
'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so,ENV=(NB_ORA_SCHED=ORACLE
_DB,NB_ORA_CLIENT=jivrac1,NB_ORA_CLASS=OLS3_WIU_ORACLE)';

allocate channel t4 type 'SBT_TAPE' parms
'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so,ENV=(NB_ORA_SCHED=ORACLE
_DB,NB_ORA_CLIENT=jivrac1,NB_ORA_CLASS=OLS3_WIU_ORACLE)';

        backup database PLUS ARCHIVELOG;
        release channel t1;
        release channel t2;
        release channel t3;
        release channel t4;
      }

Restore:

[oracle_at_wiuqjivrac01 dbs]$ export ORACLE_SID=WIUQD3 [oracle_at_wiuqjivrac01 dbs]$ rman nocatalog target /

Recovery Manager: Release 10.1.0.3.0 - Production

connected to target database (not started)

RMAN> set dbid 123456789

executing command: SET DBID

RMAN> startup nomount;

startup failed: ORA-01078: failure in processing system parameters

LRM-00109: could not open parameter file
'/u01/app/oracle/product/10.1.0/db_1/dbs/initWIUQD3.ora'

trying to start the Oracle instance without parameter files ...

Oracle instance started

Total System Global Area 79691776 bytes

		Fixed Size                      777792 bytes
		Variable Size                 70001088 bytes
		Database Buffers               8388608 bytes
		Redo Buffers                    524288 bytes

RMAN>run
		{allocate channel t1 type 'SBT_TAPE' parms

'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so,ENV=(NB_ORA_SCHED=ORACLE
_DB,NB_ORA_CLIENT=jivrac1,NB_ORA_CLASS=QAOLS_ORACLE)';

restore spfile to pfile
'/u01/app/oracle/product/10.1.0/db_1/dbs/initWIUQD3.ora' from autobackup
maxdays=2;

		}
		allocated channel: t1
		channel t1: sid=26 devtype=SBT_TAPE
		channel t1: VERITAS NetBackup for Oracle - Release 5.1

(2004043014)

Starting restore at 01-NOV-05

		channel t1: looking for autobackup on day: 20051101
		channel t1: looking for autobackup on day: 20051031
		channel t1: no autobackup in 2 days found

Thanks,

Mark Moynahan

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Nov 01 2005 - 10:54:39 CST