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;
}
Testing the Silk Platform in 2024: Achieving 20 GiB/s I/O Throughput in a
Single Cloud VM
-
Hands-on technical analysis of a novel data platform for high-performance
block I/O in the cloud, tested by Tanel Poder, a database consultant and a
long-t...
Acum o săptămână
Niciun comentariu:
Trimiteți un comentariu