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

Figure 3. Media labels and medium ID

b. Data Protector CLI:

i. Select the backup session and execute the following command:

omnidb –session SESSION_ID -media

oracle@ita022[DB10g]:/opt/oracle $ omnidb -session 2008/05/26-5 -media

Medium Label Medium ID Free Blocks

==========================================================================

ita022_file_lib_MediaPool_37 10394b75:483aad2a:5c7d:0073 52428800

ita022_file_lib_MediaPool_38 10394b75:483aad2a:5c7d:0074 52428800

ita022_file_lib_MediaPool_39 10394b75:483aad2a:5c7d:0075 52428800

ita022_file_lib_MediaPool_40 10394b75:483aad89:5c7d:0078 52428800

c. Oracle RMAN

i. Connected to the target database and recovery catalog

ii. List the full backups of the database in a specific time window

iii. List the backupsets containing your backup to the get the medium ID.

RMAN> list backup of database completed after 'SYSDATE -1 ';

List of Backup Sets

===================

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

43875 Incr 0 239.25M SBT_TAPE 00:00:30 2008-05-26

BP Key: 43879 Status: AVAILABLE Compressed: NO Tag: TAG20080526T142913

Handle: DB10g_online_FL<DB10g_196:655741754:1>.dbf Media:

List of Datafiles in backup set 43875

File LV Type Ckp SCN Ckp Time Name

---- -- ---- ---------- ---------- ----

2 0 Incr 8387511 2008-05-26 /opt/oracle/oradata/DB10g/undotbs01.dbf

5 0 Incr 8387511 2008-05-26 /opt/oracle/oradata/DB10g/example01.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

43876 Incr 0 339.75M SBT_TAPE 00:00:38 2008-05-26

BP Key: 43880 Status: AVAILABLE Compressed: NO Tag: TAG20080526T142913

Handle: DB10g_online_FL<DB10g_195:655741753:1>.dbf Media:

List of Datafiles in backup set 43876

File LV Type Ckp SCN Ckp Time Name

---- -- ---- ---------- ---------- ----

3 0 Incr 8387510 2008-05-26 /opt/oracle/oradata/DB10g/sysaux01.dbf

4 0 Incr 8387510 2008-05-26 /opt/oracle/oradata/DB10g/users01.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

43877 Incr 0 369.50M SBT_TAPE 00:00:39 2008-05-26

BP Key: 43881 Status: AVAILABLE Compressed: NO Tag: TAG20080526T142913