allocate channel for restore & recovery
DBA2011Nov 23 2009 — edited Nov 25 2009Want to clear my concepts about allocating channels for restore and recovery of db.
My understanding is that this will do the work......
RMAN> RUN
{
ALLOCATE CHANNEL T1 TYPE 'sbt_tape' PARMS 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
ALLOCATE CHANNEL T2 TYPE 'sbt_tape' PARMS 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
ALLOCATE CHANNEL T3 TYPE 'sbt_tape' PARMS 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
ALLOCATE CHANNEL T4 TYPE 'sbt_tape' PARMS 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
restore database;
recover database;
}
What if i just go to rman client after connecting to target/catalog and give command , how many channels will be allocated ( my understaning is that the # of channels in show all (auto config), & will return error, because they are all set to default to disk;
RMAN> RUN
{
restore database;
recover database;
}
This is the backup log.
RMAN> RUN
2> {
3> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 60 DAYS;
4> CONFIGURE BACKUP OPTIMIZATION OFF;
5>
6> ALLOCATE CHANNEL T1 TYPE 'sbt_tape' PARMS 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
7> ALLOCATE CHANNEL T2 TYPE 'sbt_tape' PARMS 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
8> ALLOCATE CHANNEL T3 TYPE 'sbt_tape' PARMS 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
9> ALLOCATE CHANNEL T4 TYPE 'sbt_tape' PARMS 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
10> CONFIGURE DEVICE TYPE 'sbt_tape' PARALLELISM 4;
11> SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
12> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE FILESPERSET=10 FORMAT='%d_%s_%p_%T_DATA' TAG=TAG_wcmp_cumu_091123_113001 (DATAB
ASE);
13> SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
14> BACKUP FILESPERSET=15 FORMAT='%d_%s_%p_%T_ARCH' TAG=TAG_wcmp_cumu_091123_113001 (ARCHIVELOG ALL NOT BACKED UP 1 TIMES
);
15> DELETE NOPROMPT ARCHIVELOG ALL BACKED UP 1 TIMES TO DEVICE TYPE SBT ;
16> BACKUP CURRENT CONTROLFILE FILESPERSET=5 FORMAT='%d_%s_%p_%T_CTRL' TAG=TAG_wcmp_cumu_091123_113001;
17> }