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;
}
Everything Changes
-
I saw a recent tweet (on Bluesky) from SQLDaily highlighting a blog note
that Lukas Eder wrote in 2016 with the title: “Avoid using COUNT() in SQL
when you...
Acum o săptămână
Niciun comentariu:
Trimiteți un comentariu