53
Session 6: Restore allocating channels manually on RAC1 and RAC2
• Manually created RMAN script
• Channels allocated on RAC1 and RAC2 using the connection string sys/xxx@<ORACLE_SID>
• Tablespace POOL offline
• Restore
• Recovery
oracle@ita018[RAC1]:/opt/oracle$ rman target sys/sys@MSL5000 catalog rman/rman@rcvcat cmdfile
restore_RAC_POOL_2ch.rcv
Recovery Manager: Release 10.2.0.3.0 - Production on Tue Oct 9 13:35:51 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: RAC (DBID=2216826430)
connected to recovery catalog database
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=2209 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=2222 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-10-09
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_057.dbf
restoring datafile 00024 to +DG_DB/rac/datafile/tbs_pool_060.dbf
restoring datafile 00026 to +DG_DB/rac/datafile/tbs_pool_058.dbf
restoring datafile 00028 to +DG_DB/rac/datafile/tbs_pool_051.dbf
restoring datafile 00030 to +DG_DB/rac/datafile/tbs_pool_054.dbf
restoring datafile 00032 to +DG_DB/rac/datafile/tbs_pool_052.dbf
restoring datafile 00034 to +DG_DB/rac/datafile/tbs_pool_053.dbf
restoring datafile 00036 to +DG_DB/rac/datafile/tbs_pool_050.dbf
restoring datafile 00038 to +DG_DB/rac/datafile/tbs_pool_056.dbf
restoring datafile 00040 to +DG_DB/rac/datafile/tbs_pool_049.dbf
To Next Page
Loading...
Need help?
General
