56
Session 7: Restore and Recovery using an incremental backup
RMAN> run {
2> allocate channel 'dev_0' type 'sbt_tape'
3> parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=RAC,OB2BARLIST=RAC_POOL_man_ch_1_2
)' connect *;
4> allocate channel 'dev_1' type 'sbt_tape'
5> parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=RAC,OB2BARLIST=RAC_POOL_man_ch_1_2
)' connect *;
6> SQL " alter tablespace POOL offline immediate";
7> restore tablespace 'POOL';
8> recover tablespace 'POOL';
9> SQL " alter tablespace POOL online";
10> release channel 'dev_0';
11> release channel 'dev_1';
12> }
13>
14>
allocated channel: dev_0
channel dev_0: sid=2221 instance=RAC1 devtype=SBT_TAPE
channel dev_0: Data Protector A.06.00/PHSS_35908/PHSS_35909/DPSOL_00261/DPLNX_
allocated channel: dev_1
channel dev_1: sid=2207 instance=RAC2 devtype=SBT_TAPE
channel dev_1: Data Protector A.06.00/PHSS_35908/PHSS_35909/DPSOL_00261/DPLNX_
sql statement: alter tablespace POOL offline immediate
Starting restore at 2007-11-07
channel dev_0: starting datafile backupset restore
channel dev_0: specifying datafile(s) to restore from backup set
restoring datafile 00010 to +DG_DB/rac/datafile/tbs_pool_064.dbf
restoring datafile 00012 to +DG_DB/rac/datafile/tbs_pool_066.dbf
restoring datafile 00014 to +DG_DB/rac/datafile/tbs_pool_063.dbf
restoring datafile 00016 to +DG_DB/rac/datafile/tbs_pool_062.dbf
restoring datafile 00018 to +DG_DB/rac/datafile/tbs_pool_061.dbf
restoring datafile 00020 to +DG_DB/rac/datafile/tbs_pool_059.dbf
restoring datafile 00022 to +DG_DB/rac/datafile/tbs_pool_060.dbf
restoring datafile 00024 to +DG_DB/rac/datafile/tbs_pool_057.dbf
restoring datafile 00026 to +DG_DB/rac/datafile/tbs_pool_058.dbf
restoring datafile 00028 to +DG_DB/rac/datafile/tbs_pool_056.dbf
restoring datafile 00030 to +DG_DB/rac/datafile/tbs_pool_054.dbf
restoring datafile 00032 to +DG_DB/rac/datafile/tbs_pool_051.dbf
restoring datafile 00034 to +DG_DB/rac/datafile/tbs_pool_050.dbf
restoring datafile 00036 to +DG_DB/rac/datafile/tbs_pool_049.dbf
restoring datafile 00038 to +DG_DB/rac/datafile/tbs_pool_053.dbf
restoring datafile 00040 to +DG_DB/rac/datafile/tbs_pool_055.dbf
restoring datafile 00042 to +DG_DB/rac/datafile/tbs_pool_052.dbf
restoring datafile 00044 to +DG_DB/rac/datafile/tbs_pool_040.dbf
restoring datafile 00046 to +DG_DB/rac/datafile/tbs_pool_038.dbf
restoring datafile 00048 to +DG_DB/rac/datafile/tbs_pool_043.dbf
restoring datafile 00050 to +DG_DB/rac/datafile/tbs_pool_042.dbf
restoring datafile 00052 to +DG_DB/rac/datafile/tbs_pool_037.dbf
restoring datafile 00054 to +DG_DB/rac/datafile/tbs_pool_035.dbf
restoring datafile 00056 to +DG_DB/rac/datafile/tbs_pool_045.dbf
restoring datafile 00058 to +DG_DB/rac/datafile/tbs_pool_034.dbf
restoring datafile 00060 to +DG_DB/rac/datafile/tbs_pool_048.dbf
restoring datafile 00062 to +DG_DB/rac/datafile/tbs_pool_036.dbf
restoring datafile 00064 to +DG_DB/rac/datafile/tbs_pool_044.dbf
restoring datafile 00066 to +DG_DB/rac/datafile/tbs_pool_047.dbf
restoring datafile 00068 to +DG_DB/rac/datafile/tbs_pool_046.dbf
restoring datafile 00070 to +DG_DB/rac/datafile/tbs_pool_039.dbf