2010-03-22

The perfect rman script backup

The perfect rman script backup:
run
{
allocate channel t1 type disk;
BACKUP AS COMPRESSED BACKUPSET check logical INCREMENTAL LEVEL 0 DATABASE filesperset 1 plus archivelog format '/mnt/u05/backuptest/backup_%d_set%s_piece%p_copy%c_%T_%U' TAG = DB_BACK_FULL_DAILY ;
backup current controlfile format '/mnt/u05/backuptest/backup_controlfile_%d_DBID%I_%T_%U.ctl' TAG=CTL_BACK_FULL_DAILY;
backup spfile format '/mnt/u05/backuptest/backup_parameter_%d_DBID%I_%T_%U.ctl' TAG=PARAM_BACK_FULL_DAILY ;
delete obsolete;
release channel t1;
}


Adaptat:

run
{allocate channel oem_backup_sbt1 type 'SBT_TAPE' format '%d_%U_%I_plusarch' maxpiecesize 60G;
allocate channel oem_backup_sbt2 type 'SBT_TAPE' format '%d_%U_%I_plusarch' maxpiecesize 60G;
backup  check logical INCREMENTAL LEVEL 0 DATABASE filesperset 1 plus archivelog  ;
delete noprompt archivelog until time 'sysdate - 1' backed up 1 times to device type 'SBT_TAPE';
release channel oem_backup_sbt1;
}

Niciun comentariu:

Trimiteți un comentariu