Autobackup not found by RMAN

Links

Frequent Oracle Errors

•	TNS:could not resolve the connect identifier specified
•	Backtrace message unwound by exceptions
•	invalid identifier
•	PL/SQL compilation error
•	internal error
•	missing expression
•	table or view does not exist
•	end-of-file on communication channel
•	TNS:listener unknown in connect descriptor
•	insufficient privileges
•	PL/SQL: numeric or value error string
•	TNS:protocol adapter error
•	ORACLE not available
•	target host or object does not exist
•	invalid number
•	unable to allocate string bytes of shared memory
•	resource busy and acquire with NOWAIT specified
•	error occurred at recursive SQL level string
•	ORACLE initialization or shutdown in progress
•	archiver error. Connect internal only, until freed
•	snapshot too old
•	unable to extend temp segment by string in tablespace
•	Credential retrieval failed
•	missing or invalid option
•	invalid username/password; logon denied
•	unable to create INITIAL extent for segment
•	out of process memory when trying to allocate string bytes
•	shared memory realm does not exist
•	cannot insert NULL
•	TNS:unable to connect to destination
•	remote database not found'>ora-02019
•	exception encountered: core dump
•	inconsistent datatypes
•	no data found
•	TNS:operation timed out
•	PL/SQL: could not find program
•	existing state of packages has been discarded
•	maximum number of processes exceeded
•	error signaled in parallel query server
•	ORACLE instance terminated. Disconnection forced
•	TNS:packet writer failure
•	see ORA-12699
•	missing right parenthesis
•	name is already used by an existing object
•	cannot identify/lock data file
•	invalid file operation
•	quoted string not properly terminated

Autobackup not found by RMAN

Autobackup not found by RMAN

2005-11-01 - By Mark Moynahan

Reply: 1 2 3 4 5

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@(protected) dbs]$ export ORACLE_SID=WIUQD3
[oracle@(protected) dbs]$ rman nocatalog target /

Recovery Manager: Release 10.1.0.3.0 - Production

Copyright (c) 1995, 2004, Oracle. All rights reserved.

connected to target database (not started)

RMAN> set dbid 123456789

executing command: SET DBID

RMAN> startup nomount;
startup failed: ORA-01078 (See ORA-01078.ora-code.com): 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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7226.0">
<TITLE>Autobackup not found by RMAN</TITLE>
</HEAD>
<BODY>


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@(protected) dbs]$ export ORACLE_SID
=WIUQD3

 [oracle@(protected) dbs]$ rman nocatalog
target /


Recovery Manager: Release 10.1.0.3.0 -
Production


Copyright (c) 1995, 2004, Oracle.  All
rights reserved.


connected to target database (not started)


RMAN> set dbid 123456789


executing command: SET DBID


RMAN> startup nomount;
<UL><UL>
startup failed: ORA-01078 (See ORA-01078.ora-code.com): 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   &nbsp
;  79691776 bytes


Fixed Size      
             
   777792 bytes

 Variable Size     
            70001088
bytes

 Database Buffers     
          8388608 bytes

 Redo Buffers     
             
  524288 bytes

</UL></UL>
RMAN>run
<UL><UL>
{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

</UL></UL>
Thanks,


Mark Moynahan


</BODY>
</HTML>