Autobackup not found by RMAN 2005-11-02 - By Marquez, Chris
Mark,
>>you just have to set the autobackup
>>format before restoring the spfile.
|| >> channel t1: no autobackup in 2 days found
Not that I disagree with Jerome, but I notice that this time you left off
"maxdays=2;".
Did that have anything to do with it too?...was your AUTOBACKUP > 2 days old?
Just curious,
Chris Marquez
Oracle DBA
PS What is the autobackup default? " '.../ora_cf%F'; " I think?
I have run into trouble with this before, using non-default...but it was on
backup (failure) if I remember?
-- --Original Message-- --
From: oracle-l-bounce@(protected) on behalf of Mark Moynahan
Sent: Wed 11/2/2005 8:41 AM
To: oracle-l@(protected); Vitalis Jerome
Subject: RE: Autobackup not found by RMAN
Hi Jerome,
Thanks for the information. About an hour after posting the original
message I figured out what the problem was. It was exactly what you
described. The solution in 10g is very simple you just have to set the
autobackup format before restoring the spfile.
Run
{set controlfile autobackup format for device type sbt to 'cf_%F';
allocate channel ch01 device type tape;
restore spfile to pfile from autobackup;
}
Thanks,
Mark
-- --Original Message-- --
From: Vitalis Jerome [mailto:vitalisman@(protected)]
Sent: Wednesday, November 02, 2005 1:30 AM
To: Mark Moynahan
Cc: oracle-l@(protected)
Subject: Re: Autobackup not found by RMAN
Hi Mark,
That's because you had overiden the default autobackup format in the
persistent configuration ('cf_%F').
And now RMAN is asking the media manager to restore the spfile from
pieces with the default format '%F' and none can be found.
AFAIK you can't specify an alternate autobackup format upon restore
(the instance is not mounted, you can not create a persistent
configuration, at least with 9i). So in your case you may have to
'manually' specify the autobackup to restore by using "FROM
'media_handle'".
If you find a better solution please let us know.
Regards,
Jerome
--
http://www.freelists.org/webpage/oracle-l
-- --Original Message-- --
From: oracle-l-bounce@(protected) on behalf of Mark Moynahan
Sent: Tue 11/1/2005 11:51 AM
To: oracle-l@(protected)
Subject: Autobackup not found by RMAN
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=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7233.28">
<TITLE>RE: Autobackup not found by RMAN</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/plain format -->
<BR>
<P><FONT SIZE=2>Mark,<BR>
<BR>
>>you just have to set the autobackup<BR>
>>format before restoring the spfile.<BR>
<BR>
|| >> channel t1: no autobackup in 2 days found<BR>
<BR>
Not that I disagree with Jerome, but I notice that this time you left off "
;maxdays=2;".<BR>
Did that have anything to do with it too?...was your AUTOBACKUP > 2 days old
?<BR>
<BR>
Just curious,<BR>
<BR>
Chris Marquez<BR>
Oracle DBA<BR>
<BR>
<BR>
PS What is the autobackup default? " '.../ora_cf%F'; " I think?
<BR>
I have run into trouble with this before, using non-default...but it was on
backup (failure) if I remember?<BR>
<BR>
<BR>
-- --Original Message-- --<BR>
From: oracle-l-bounce@(protected) on behalf of Mark Moynahan<BR>
Sent: Wed 11/2/2005 8:41 AM<BR>
To: oracle-l@(protected); Vitalis Jerome<BR>
Subject: RE: Autobackup not found by RMAN<BR>
<BR>
Hi Jerome,<BR>
<BR>
Thanks for the information. About an hour after posting the original<BR>
message I figured out what the problem was. It was exactly what you<BR>
described. The solution in 10g is very simple you just have to set the<BR>
autobackup format before restoring the spfile.<BR>
<BR>
Run<BR>
{set controlfile autobackup format for device type sbt to 'cf_%F';<BR>
allocate channel ch01 device type tape;<BR>
restore spfile to pfile from autobackup;<BR>
}<BR>
<BR>
Thanks,<BR>
<BR>
Mark<BR>
<BR>
<BR>
<BR>
<BR>
<BR>
<BR>
<BR>
-- --Original Message-- --<BR>
From: Vitalis Jerome [<A HREF="mailto:vitalisman@(protected)">mailto:vitalisman
@(protected)</A>]<BR>
Sent: Wednesday, November 02, 2005 1:30 AM<BR>
To: Mark Moynahan<BR>
Cc: oracle-l@(protected)<BR>
Subject: Re: Autobackup not found by RMAN<BR>
<BR>
Hi Mark,<BR>
<BR>
That's because you had overiden the default autobackup format in the<BR>
persistent configuration ('cf_%F').<BR>
<BR>
And now RMAN is asking the media manager to restore the spfile from<BR>
pieces with the default format '%F' and none can be found.<BR>
AFAIK you can't specify an alternate autobackup format upon restore<BR>
(the instance is not mounted, you can not create a persistent<BR>
configuration, at least with 9i). So in your case you may have to<BR>
'manually' specify the autobackup to restore by using "FROM<BR>
'media_handle'".<BR>
If you find a better solution please let us know.<BR>
<BR>
Regards,<BR>
Jerome<BR>
--<BR>
<A HREF="http://www.freelists.org/webpage/oracle-l">http://www.freelists.org
/webpage/oracle-l</A><BR>
<BR>
<BR>
<BR>
<BR>
<BR>
<BR>
<BR>
-- --Original Message-- --<BR>
From: oracle-l-bounce@(protected) on behalf of Mark Moynahan<BR>
Sent: Tue 11/1/2005 11:51 AM<BR>
To: oracle-l@(protected)<BR>
Subject: Autobackup not found by RMAN<BR>
<BR>
OS: RH 3.5<BR>
DB: 10.1.0.3<BR>
Media software: Veritas Netbackup 5.1<BR>
<BR>
I'm in the process of documenting our DR procedure. Our testing includes<BR>
recovering from disk and tape. So far recovering from disk has been<BR>
relatively painless. In contrast, recovering from tape has proven to be<BR>
less successful. Right now I can't get past the steps to restore the<BR>
spfile to pfile from autobackup. Has anyone run across this same problem<BR>
when restoring the spfile to pfile from autobackup from tape? Listed<BR>
below is the backup and restore commands.<BR>
<BR>
Backup:<BR>
<BR>
CONFIGURE DEVICE TYPE sbt BACKUP TYPE TO BACKUPSET;<BR>
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE sbt_tape TO<BR>
'cf_%F';<BR>
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 14 DAYS;<BR>
run {<BR>
allocate channel t1 type 'SBT_TAPE'
parms<BR>
'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so,ENV=(NB_ORA_SCHED=ORACLE<BR>
_DB,NB_ORA_CLIENT=jivrac1,NB_ORA_CLASS=OLS3_WIU_ORACLE)';<BR>
allocate channel t2 type 'SBT_TAPE'
parms<BR>
'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so,ENV=(NB_ORA_SCHED=ORACLE<BR>
_DB,NB_ORA_CLIENT=jivrac1,NB_ORA_CLASS=OLS3_WIU_ORACLE)';<BR>
allocate channel t3 type 'SBT_TAPE'
parms<BR>
'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so,ENV=(NB_ORA_SCHED=ORACLE<BR>
_DB,NB_ORA_CLIENT=jivrac1,NB_ORA_CLASS=OLS3_WIU_ORACLE)';<BR>
allocate channel t4 type 'SBT_TAPE'
parms<BR>
'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so,ENV=(NB_ORA_SCHED=ORACLE<BR>
_DB,NB_ORA_CLIENT=jivrac1,NB_ORA_CLASS=OLS3_WIU_ORACLE)';<BR>
backup database PLUS ARCHIVELOG;<BR>
release channel t1;<BR>
release channel t2;<BR>
release channel t3;<BR>
release channel t4;<BR>
}<BR>
<BR>
Restore:<BR>
<BR>
[oracle@(protected) dbs]$ export ORACLE_SID=WIUQD3<BR>
[oracle@(protected) dbs]$ rman nocatalog target /<BR>
<BR>
Recovery Manager: Release 10.1.0.3.0 - Production<BR>
<BR>
Copyright (c) 1995, 2004, Oracle. All rights reserved.<BR>
<BR>
connected to target database (not started)<BR>
<BR>
RMAN> set dbid 123456789<BR>
<BR>
executing command: SET DBID<BR>
<BR>
RMAN> startup nomount;<BR>
startup failed: ORA-01078 (See ORA-01078.ora-code.com): failure in processing system<BR>
parameters<BR>
LRM-00109: could not open parameter file<BR>
'/u01/app/oracle/product/10.1.0/db_1/dbs/initWIUQD3.ora'<BR>
<BR>
trying to start the Oracle instance without parameter<BR>
files ...<BR>
Oracle instance started<BR>
<BR>
Total System Global Area 79691776 bytes<BR>
<BR>
Fixed Size
777792 bytes
<BR>
Variable Size
70001088 bytes<BR>
Database Buffers
8388608 bytes<BR>
Redo Buffers
524288 bytes<BR>
<BR>
RMAN>run<BR>
{allocate channel t1 type 'SBT_TAPE' parms<BR>
'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so,ENV=(NB_ORA_SCHED=ORACLE<BR>
_DB,NB_ORA_CLIENT=jivrac1,NB_ORA_CLASS=QAOLS_ORACLE)';<BR>
restore spfile to pfile<BR>
'/u01/app/oracle/product/10.1.0/db_1/dbs/initWIUQD3.ora' from autobackup<BR>
maxdays=2;<BR>
}<BR>
allocated channel: t1<BR>
channel t1: sid=26 devtype=SBT_TAPE<BR>
channel t1: VERITAS NetBackup for Oracle - Release 5.1<BR>
(2004043014)<BR>
<BR>
Starting restore at 01-NOV-05<BR>
<BR>
channel t1: looking for autobackup on day: 20051101<BR>
channel t1: looking for autobackup on day: 20051031<BR>
channel t1: no autobackup in 2 days found<BR>
<BR>
Thanks,<BR>
<BR>
Mark Moynahan<BR>
<BR>
<BR>
</FONT>
</P>
</BODY>
</HTML>
|
|
