22
Oracle RMAN Restore and Recovery
Oracle Restore Enhancements
Starting with Oracle 10g Release 2, Data Protector includes a series of enhancements to improve
restore performance. Additional attributes (SBTBFINFO flags) are now set for each backup file:
•
Data Protector Tape device concurrency: This allows more than one RMAN channel to read from
the same device
•
Backup file sequence: Files should be read in the same sequence they are physically on the media
•
Media ID stored in the recovery catalog: This enables oracle processes to optimize restores by
avoiding the restore of files in the same tape at the same time.
As it can be seen in the following RMAN list command, now the Media ID is stored in the recovery
catalog and can be queried:
RMAN> list backupset 9266;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
9266 Incr 0 114.01G SBT_TAPE 00:45:30 2007-10-05
BP Key: 9270 Status: AVAILABLE Compressed: NO Tag: TAG20071005T172549
Handle: RAC_POOL_man_ch_1_2<RAC_460:635189150:1>.dbf Media:
10394b75:47060053:1093:0001[[HFP419] HFP419]
List of Datafiles in backup set 9266
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ---------- ----
9 0 Incr 32918890 2007-10-05 +DG_DB/rac/datafile/tbs_pool_001.dbf
11 0 Incr 32918890 2007-10-05 +DG_DB/rac/datafile/tbs_pool_065.dbf
13 0 Incr 32918890 2007-10-05 +DG_DB/rac/datafile/tbs_pool_002.dbf
15 0 Incr 32918890 2007-10-05 +DG_DB/rac/datafile/tbs_pool_003.dbf
17 0 Incr 32918890 2007-10-05 +DG_DB/rac/datafile/tbs_pool_004.dbf
19 0 Incr 32918890 2007-10-05 +DG_DB/rac/datafile/tbs_pool_006.dbf
21 0 Incr 32918890 2007-10-05 +DG_DB/rac/datafile/tbs_pool_008.dbf
23 0 Incr 32918890 2007-10-05 +DG_DB/rac/datafile/tbs_pool_005.dbf
25 0 Incr 32918890 2007-10-05 +DG_DB/rac/datafile/tbs_pool_007.dbf
27 0 Incr 32918890 2007-10-05 +DG_DB/rac/datafile/tbs_pool_014.dbf
29 0 Incr 32918890 2007-10-05 +DG_DB/rac/datafile/tbs_pool_011.dbf
31 0 Incr 32918890 2007-10-05 +DG_DB/rac/datafile/tbs_pool_013.dbf
33 0 Incr 32918890 2007-10-05 +DG_DB/rac/datafile/tbs_pool_012.dbf
35 0 Incr 32918890 2007-10-05 +DG_DB/rac/datafile/tbs_pool_015.dbf
37 0 Incr 32918890 2007-10-05 +DG_DB/rac/datafile/tbs_pool_009.dbf
39 0 Incr 32918890 2007-10-05 +DG_DB/rac/datafile/tbs_pool_016.dbf
41 0 Incr 32918890 2007-10-05 +DG_DB/rac/datafile/tbs_pool_010.dbf
43 0 Incr 32918890 2007-10-05 +DG_DB/rac/datafile/tbs_pool_031.dbf
45 0 Incr 32918890 2007-10-05 +DG_DB/rac/datafile/tbs_pool_020.dbf
47 0 Incr 32918890 2007-10-05 +DG_DB/rac/datafile/tbs_pool_018.dbf
49 0 Incr 32918890 2007-10-05 +DG_DB/rac/datafile/tbs_pool_023.dbf
51 0 Incr 32918890 2007-10-05 +DG_DB/rac/datafile/tbs_pool_024.dbf
53 0 Incr 32918890 2007-10-05 +DG_DB/rac/datafile/tbs_pool_030.dbf
55 0 Incr 32918890 2007-10-05 +DG_DB/rac/datafile/tbs_pool_029.dbf
