RE: RMAN: restoring autobackup spfile and controlfile
- From: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
- To: "Alex Gorbachev" <ag@xxxxxxxxxxxx>, <jkstill@xxxxxxxxx>, "Oracle-L Freelists" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 1 Aug 2007 12:08:53 -0700
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@xxxxxxxxx [mailto:gorbyx@xxxxxxxxx] 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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
