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

27
Session 2: Control File autobackup OFF and Recovery Catalog
oracle@hpu015[DB10g]:/home/oracle$ rman catalog rman/xxx@rcat
Recovery Manager: Release 10.2.0.3.0 - Production on Wed May 7 13:18:58 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)
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> restore spfile;
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: starting datafile backupset restore
channel ORA_SBT_TAPE_1: restoring SPFILE
output filename=/opt/oracle/product/10.2.0/db_1/dbs/spfileDB10g.ora
channel ORA_SBT_TAPE_1: reading from backup piece DB10g_online_FL<DB10g_174:654105081:1>.dbf
[Normal] From: [e-mail] "DB10g" Time: 05/07/08 13:20:27
Starting OB2BAR Restore: ita022:DB10g_online_FL<DB10g_174:654105081:1>.dbf "Oracle8"
[Normal] From: [e-mail] "DB10g" Time: 05/07/08 13:20:30
Completed OB2BAR Restore: ita022:DB10g_online_FL<DB10g_174:654105081:1>.dbf
"Oracle8"
channel ORA_SBT_TAPE_1: restored backup piece 1
piece handle=DB10g_online_FL<DB10g_174:654105081:1>.dbf tag=TAG20080507T155104
channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:45
Finished restore at 2008-05-07
RMAN>
RMAN> startup nomount force;
Oracle instance started
Total System Global Area 314572800 bytes
Fixed Size 2057944 bytes
Variable Size 100665640 bytes
Database Buffers 209715200 bytes
Redo Buffers 2134016 bytes
RMAN> restore controlfile;
Starting restore at 2008-05-07
allocated channel: ORA_SBT_TAPE_1