Oracle Database migration to a remote Data Protector cell--Best practices
15
At this point, we have a mounted database.
To move forward first we need to decide, from the available backups, which backup to use for our restore.
In case the number of backups is large, we can just list the backups between two specified dates.
Below we can see the different backup sets available between today and yesterday. It can seen that
all tags are the same (they belong to the same backup)
RMAN> list backup of database completed between 'SYSDATE -1' and 'SYSDATE' ;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
38975 Incr 0 191.50M SBT_TAPE 00:00:29 2008-05-06
BP Key: 38979 Status: AVAILABLE Compressed: NO Tag: TAG20080506T145513
Handle: DB10g_online_FL<DB10g_159:654015314:1>.dbf Media:
List of Datafiles in backup set 38975
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ---------- ----
2 0 Incr 7375108 2008-05-06 /opt/oracle/oradata/DB10g/undotbs01.dbf
5 0 Incr 7375108 2008-05-06 /opt/oracle/oradata/DB10g/example01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
38976 Incr 0 335.50M SBT_TAPE 00:00:36 2008-05-06
BP Key: 38980 Status: AVAILABLE Compressed: NO Tag: TAG20080506T145513
Handle: DB10g_online_FL<DB10g_158:654015314:1>.dbf Media:
List of Datafiles in backup set 38976
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ---------- ----
3 0 Incr 7375107 2008-05-06 /opt/oracle/oradata/DB10g/sysaux01.dbf
4 0 Incr 7375107 2008-05-06 /opt/oracle/oradata/DB10g/users01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
38977 Incr 0 369.50M SBT_TAPE 00:00:38 2008-05-06
BP Key: 38981 Status: AVAILABLE Compressed: NO Tag: TAG20080506T145513
Handle: DB10g_online_FL<DB10g_157:654015313:1>.dbf Media:
List of Datafiles in backup set 38977
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ---------- ----
1 0 Incr 7375106 2008-05-06 /opt/oracle/oradata/DB10g/system01.dbf
Next, we look for the archive logs available after the backup. It can be easily done with
the following command:
RMAN> list backup of archivelog from scn=7375106 ;
List of Backup Sets
===================
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
39019 1.53G SBT_TAPE 00:02:40 2008-05-06
BP Key: 39025 Status: AVAILABLE Compressed: NO Tag: TAG20080506T145657
Handle: DB10g_online_FL<DB10g_164:654015418:1>.dbf Media:
10394b75:482055a3:5c7d:0057[ita022_file_lib_MediaPool_29]
List of Archived Logs in backup set 39019
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ---------- ---------- ---------
1 96 7347881 2008-05-06 7375215 2008-05-06
1 97 7375215 2008-05-06 7375238 2008-05-06
Finally, we can create our restore and recovery RMAN script, specifying the point in time to recover.
Note that, as sequence, we specify the last archived log available in the backup, plus one. (If we
want to recover up to sequence 97, inclusive, we need to specify the value 98 in the until sequence
statement; the restore and recovery will be executed until the value 98, not included.)
The full session report can be found in the Appendix A.