RMAN took 12hrs to restore
Last week, I had to perform recovery on a unix database using RMAN...
My only concern about this whole recovery is the fact that it took RMAN 12hours to restore the 150gb files from tape. In the previous mock recoveries, the restores has taken about 3 hours maxium. I couldnt figure out why it took to much time.. everything is the same. the data has grown by 15%. The hotbackup takes about 3.5hrs to backup at incremental 0 (full). Can you kindly make some suggestions?
The following is my rman script
Run {
set until logseq 43111 thread 1;
allocate channel 'dev_0' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=trxp,OB2BARLIST=TRXP_RMAN_Online)';
allocate channel 'dev_1' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=trxp,OB2BARLIST=TRXP_RMAN_Online)';
allocate channel 'dev_2' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=trxp,OB2BARLIST=TRXP_RMAN_Online)';
allocate channel 'dev_3' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=trxp,OB2BARLIST=TRXP_RMAN_Online)';
allocate channel 'dev_4' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=trxp,OB2BARLIST=TRXP_RMAN_Online)';
allocate channel 'dev_5' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=trxp,OB2BARLIST=TRXP_RMAN_Online)';
allocate channel 'dev_6' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=trxp,OB2BARLIST=TRXP_RMAN_Online)';
allocate channel 'dev_7' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=trxp,OB2BARLIST=TRXP_RMAN_Online)';
allocate channel 'dev_8' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=trxp,OB2BARLIST=TRXP_RMAN_Online)';
allocate channel 'dev_9' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=trxp,OB2BARLIST=TRXP_RMAN_Online)';
connect target trxp
restore controlfile;
alter database mount;
restore database;
recover database;
}