jueves, 18 de diciembre de 2008

BKP FULL RMAN CON ARCHIVE LOG

$RMAN target / rcvcat $RCVCAT_CONNECT_STR@$RCVCAT_TNS msglog $RMAN_LOG_FILE append <<>

RUN
{
allocate channel ch1 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
backup database include current controlfile plus archivelog delete all input;
DELETE COPY OF ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-3';
release channel ch1;
}
crosscheck backup of database;
delete noprompt expired backup of database;
crosscheck backup of archivelog all;
delete noprompt expired backup of archivelog all;
crosscheck Archivelog all;
crosscheck backup of controlfile;
delete noprompt obsolete;
delete noprompt expired backup;
delete noprompt expired archivelog all;
"


Este script borra los archivelogs de LOG_ARCHIVE_DEST_1 dejando los últimos 3 días on-line.

No hay comentarios: