hello everybody.
we use oracle 11.2.0.4 and want to use oracle recommended backup stratagy to put backup straight to sbt (dd boost) storage.
in addition want to highlight we have fra
Here is my script
run{
allocate channel dd0 device type 'SBT_TAPE' PARMS 'BLKSIZE=1048576,SBT_LIBRARY=/u01/app/oracle/product/11.2.0/dbhome_1/lib/libddobk.so,ENV=(STORAGE_UNIT=dd160_49_ddboost,BACKUP_HOST=ip,ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1)';
allocate channel dd1 device type 'SBT_TAPE' PARMS 'BLKSIZE=1048576,SBT_LIBRARY=/u01/app/oracle/product/11.2.0/dbhome_1/lib/libddobk.so,ENV=(STORAGE_UNIT=dd160_49_ddboost,BACKUP_HOST=ip,ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1)';
crosscheck backup;
crosscheck backup;
crosscheck copy;
crosscheck archivelog all;
delete noprompt obsolete;
DELETE noprompt EXPIRED ARCHIVELOG ALL;
DELETE noprompt EXPIRED BACKUP;
DELETE noprompt EXPIRED copy device type disk;
RECOVER COPY OF DATABASE WITH TAG 'ASOMP' until time 'SYSDATE-8';
BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG 'ASOMP' DATABASE;
BACKUP VALIDATE CHECK LOGICAL DATABASE ARCHIVELOG ALL;
restore validate database;
report unrecoverable;
release channel dd0;
release channel dd1;
}
So the question is wheather it is an appropriate script for our task