Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

allocate channel for restore & recovery

DBA2011Nov 23 2009 — edited Nov 25 2009
Want 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> }
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 23 2009
Added on Nov 23 2009
9 comments
2,348 views