Oracle Database migration to a remote Data Protector cell--Best practices

13
I. Restore with Control File autobackup ON and using Recovery
Catalog
In this case, when the backup was taken, Control File autobackup was enabled, and the Recovery
Catalog was used.
First, we start RMAN and connect to the RCAT recovery catalog on cell 2. Note that we do not
connect to target yet.
Next, we set the database DBID (which is known in the recovery catalog) and then we can connect to
the target.
oracle@hpu015[DB10g]:/opt/oracle$ rman catalog rman/xxx@rcat
Recovery Manager: Release 10.2.0.3.0 - Production on Wed May 7 08:27:15 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to recovery catalog database
RMAN> set dbid=38758237 ;
executing command: SET DBID
database name is "DB10G" and DBID is 38758237
RMAN> connect target /
connected to target database (not started)
As no SPFILE is available yet, Oracle will be started with a default SPFILE.
Once the instance is in NOMOUNT status, we can start the restore of the SPFILE from autobackup.
Notice that if nothing is specified, RMAN looks for the autobackup starting in the current day.
RMAN> startup nomount;
startup failed: ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/opt/oracle/product/10.2.0/db_1/dbs/initDB10g.ora'
starting Oracle instance without parameter file for retrieval of spfile
Oracle instance started
Total System Global Area 159383552 bytes
Fixed Size 2056752 bytes
Variable Size 67112400 bytes
Database Buffers 88080384 bytes
Redo Buffers 2134016 bytes
RMAN>
RMAN> run {
restore spfile from autobackup;
}
Starting restore at 2008-05-07
allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: sid=36 devtype=SBT_TAPE
channel ORA_SBT_TAPE_1: Data Protector A.06.00/PHSS_37147/PHSS_37148/DPSOL_00306/DPLNX_
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=35 devtype=DISK
channel ORA_SBT_TAPE_1: looking for autobackup on day: 20080507
channel ORA_SBT_TAPE_1: looking for autobackup on day: 20080506
channel ORA_DISK_1: looking for autobackup on day: 20080507
channel ORA_DISK_1: looking for autobackup on day: 20080506
channel ORA_DISK_1: skipped, autobackup already found
channel ORA_SBT_TAPE_1: autobackup found: c-38758237-20080506-01
[Normal] From: [e-mail] "" Time: 05/07/08 09:42:59
Starting OB2BAR Restore: ita022:c-38758237-20080506-01 "Oracle8"