| 1234567891011121314151617 |
- connect target /
- run {
- sql 'ALTER SYSTEM SET CONTROL_FILE_RECORD_KEEP_TIME=60 SCOPE=BOTH';
- CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 5 DAYS;
- CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 1 TIMES TO disk;
- CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_SYSTST4.f';
- CONFIGURE CONTROLFILE AUTOBACKUP ON;
- CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 4;
- CROSSCHECK backup of database;
- CROSSCHECK backup of controlfile;
- CROSSCHECK archivelog all;
- sql 'ALTER SYSTEM ARCHIVE LOG CURRENT';
- backup as compressed backupset TAG='Arch_SYSTST4_10052017T150002' archivelog all delete input;
- DELETE FORCE NOPROMPT OBSOLETE;
- }
- exit
|
