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

20
Once we have the imported session, we can get a list of the objects it contains using the
following command:
omnidb –session “Session_ID”
hpu015:[/.root]# omnidb -session "2008/05/08-3"
Object Name Object Type Object Status CopyID
===============================================================================
ita022:DB10g_online_FL<DB10g_184:654165548:1>.dbf Oracle8 Completed
ita022:DB10g_online_FL<DB10g_181:654165548:1>.dbf Oracle8 Completed
ita022:DB10g_online_FL<DB10g_182:654165548:1>.dbf Oracle8 Completed
ita022:DB10g_online_FL<DB10g_183:654165548:1>.dbf Oracle8 Completed
ita022:DB10g_online_FL<DB10g_185:654165575:1>.dbf Oracle8 Completed
ita022:DB10g_online_FL<DB10g_187:654165598:1>.dbf Oracle8 Completed
ita022:DB10g_online_FL<DB10g_186:654165598:1>.dbf Oracle8 Completed
ita022:DB10g_online_FL<DB10g_188:654165598:1>.dbf Oracle8 Completed
ita022:DB10g_online_FL<DB10g_189:654165598:1>.dbf Oracle8 Completed
ita022:DB10g_online_FL<DB10g_190:654165764:1>.dbf Oracle8 Completed
ita022:DB10g_online_FL<DB10g_191:654165773:1>.dbf Oracle8 Completed
ita022:DB10g DP Managed Control File Oracle8 Completed 508 (O)
ita022:Oracle Recovery Backup Catalog Oracle8 Completed 506 (O)
As we can see in the preceding figure, there are 11 Oracle RMAN objects and two Data Protector
objects in this session.
Next, we startup nomount the instance to be able to start the restore:
$ rman
RMAN> set dbid=38758237 ;
RMAN> connect target /
RMAN> startup nomount force;
Unfortunately, there is no process to find out in which of the objects the SPFILE and Control File are
stored. We need to create a small RMAN script and feed the restore clause with the different Object
Names until the restore finds the SPFILE.
For a large number of objects in the backup set, it may be more convenient to write a small shell
script to perform it automatically. See the Appendix for a sample script to run the restore.
Below, we see a successful restore session with the object that contains the SPFILE:
RMAN> run { allocate channel dev_0 type sbt_tape;
restore spfile from 'ita022:DB10g_online_FL<DB10g_185:654165575:1>.dbf' ;
}
allocated channel: dev_0
channel dev_0: sid=36 devtype=SBT_TAPE
channel dev_0: Data Protector A.06.00/PHSS_37147/PHSS_37148/DPSOL_00306/DPLNX_
Starting restore at 2008-05-08
channel dev_0: autobackup found: ita022:DB10g_online_FL<DB10g_185:654165575:1>.dbf
[Normal] From: [e-mail] "" Time: 05/08/08 11:16:21
Starting OB2BAR Restore: ita022:DB10g_online_FL<DB10g_185:654165575:1>.dbf "Oracle8"
[Normal] From: [e-mail] "" Time: 05/08/08 11:16:25
Completed OB2BAR Restore: ita022:DB10g_online_FL<DB10g_185:654165575:1>.dbf
"Oracle8"
channel dev_0: SPFILE restore from autobackup complete
Finished restore at 2008-05-08
released channel: dev_0