Database Backup and Recovery (MOSC)

MOSC Banner

RMAN backups 19c

Dear Experts,

We have a toll which takes backup with below script. We need your suggestions to modify or add any commands here. Every Sunday we have full backup and every day, we have incremental backup.

run {
allocate channel 'dev_0' type 'sbt_tape'
 parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=prdcdb2,OB2BARLIST=PRD_19C)';
allocate channel 'dev_1' type 'sbt_tape'
 parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=prdcdb2,OB2BARLIST=PRD_19C)';
allocate channel 'dev_2' type 'sbt_tape'
 parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=prdcdb2,OB2BARLIST=PRD_19C)';
allocate channel 'dev_3' type 'sbt_tape'
 parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=prdcdb2,OB2BARLIST=PRD_19C)';
allocate channel 'dev_4' type 'sbt_tape'
 parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=prdcdb2,OB2BARLIST=PRD_19C)';
allocate channel 'dev_5' type 'sbt_tape'
 parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=prdcdb2,OB2BARLIST=PRD_19C)';
allocate channel 'dev_6' type 'sbt_tape'
 parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=prdcdb2,OB2BARLIST=PRD_19C)';
allocate channel 'dev_7' type 'sbt_tape'
 parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=prdcdb2,OB2BARLIST=PRD_19C)';
allocate channel 'dev_8' type 'sbt_tape'
 parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=prdcdb2,OB2BARLIST=PRD_19C)';
allocate channel 'dev_9' type 'sbt_tape'
 parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=prdcdb2,OB2BARLIST=PRD_19C)';
allocate channel 'dev_10' type 'sbt_tape'
 parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=prdcdb2,OB2BARLIST=PRD_19C)';
allocate channel 'dev_11' type 'sbt_tape'
 parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=prdcdb2,OB2BARLIST=PRD_19C)';
allocate channel 'dev_12' type 'sbt_tape'
 parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=prdcdb2,OB2BARLIST=PRD_19C)';
allocate channel 'dev_13' type 'sbt_tape'
 parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=prdcdb2,OB2BARLIST=PRD_19C)';
allocate channel 'dev_14' type 'sbt_tape'
 parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=prdcdb2,OB2BARLIST=PRD_19C)';


sql 'alter system archive log current';
backup incremental level <incr_level>
 format 'PRD_19C<prdcdb2_%s:%t:%p>.dbf'
 database;
backup
 format 'PRD_19C<prdcdb2_%s:%t:%p>.dbf'
 archivelog all;
backup
 format 'PRD_19C<prdcdb2_%s:%t:%p>.dbf'
 recovery area;
backup
 format 'PRD_19C<prdcdb2_%s:%t:%p>.dbf'
 current controlfile;
}


Thanks,
SG

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center