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;
}
WAIT Clause for DMLs in 26.2
-
Oracle 26ai 26.2 now introduces the WAIT (and NOWAIT) Clause for INSERT /
UPDATE / DELETE / MERGE DMLs. We have had a WAIT Clause for SELECT FOR
UPDATE...
Acum 2 zile
Niciun comentariu:
Trimiteți un comentariu