Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » oracle-l »

RE: RMAN: restoring autobackup spfile and controlfile

Allen, Brandon

2007-08-01

Replies:

Yes - that feature works as advertised. I just tested it again to make
sure - see below:


/opt/oracle/ ->rman target / nocatalog

Recovery Manager: Release 10.2.0.2.0 - Production on Wed Aug 1 11:55:21
2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.

connected to target database: TESTDB (DBID=1456724639)
using target database control file instead of recovery catalog

RMAN> restore spfile to '/opt/oracle/spfile_test_restore' from
autobackup maxseq=02;

Starting restore at 01-AUG-07
allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: sid=746 devtype=SBT_TAPE
channel ORA_SBT_TAPE_1: VERITAS NetBackup for Oracle - Release 5.1
(2004122521)
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=752 devtype=DISK

channel ORA_SBT_TAPE_1: looking for autobackup on day: 20070801
channel ORA_SBT_TAPE_1: looking for autobackup on day: 20070731
channel ORA_DISK_1: skipped, autobackup already found
channel ORA_SBT_TAPE_1: autobackup found: c-1456724639-20070731-02
channel ORA_SBT_TAPE_1: SPFILE restore from autobackup complete
Finished restore at 01-AUG-07 12:06

RMAN> exit


Recovery Manager complete.

/opt/oracle ->ll spfile*
-rw-r-----  1 oracle  oinstall     3584 Aug 01 12:06
spfile_test_restore


-----Original Message-----
From: gorbyx@(protected)
Gorbachev

What's my concern is that without using RMAN catalog, it would be able
to scan available pieces from Netbackup (or whatever is the storage
manager) and find the required piece.

Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.

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


©2008 dba.5341.com - Jax Systems, LLC, U.S.A.