RE: RMAN: restoring autobackup spfile and controlfile

From: Allen, Brandon <Brandon.Allen_at_OneNeck.com>
Date: Wed, 1 Aug 2007 12:08:53 -0700
Message-ID: <04DDF147ED3A0D42B48A48A18D574C45071FE17F@NT15.oneneck.corp>

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

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_at_gmail.com [mailto:gorbyx_at_gmail.com] On Behalf Of Alex 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

Received on Wed Aug 01 2007 - 14:08:53 CDT