| 123456789101112131415161718 |
- connect target /
- run {
- sql 'ALTER SYSTEM ARCHIVE LOG CURRENT';
- sql 'ALTER SYSTEM SET CONTROL_FILE_RECORD_KEEP_TIME=60 SCOPE=BOTH';
- CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;
- CONFIGURE CONTROLFILE AUTOBACKUP ON;
- CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK CLEAR;
- CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_UAT3.f';
- CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 4;
- CROSSCHECK backup of database;
- CROSSCHECK backup of controlfile;
- CROSSCHECK backup of spfile;
- CROSSCHECK backup of archivelog all;
- backup archivelog all not backed up 1 times;
- backup current controlfile;
- delete noprompt archivelog all backed up 1 times to disk completed before 'sysdate-2';
- }
- exit
|
