| 12345678910111213141516171819 |
- connect target sys/newr00t@GOLD4
- connect catalog rcatadm/RCATADM@RCAT
- run {
- sql 'alter session set optimizer_mode=RULE';
- sql 'ALTER SYSTEM SET CONTROL_FILE_RECORD_KEEP_TIME=60 SCOPE=BOTH';
- CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 3 DAYS;
- sql 'ALTER SYSTEM ARCHIVE LOG CURRENT';
- CONFIGURE CONTROLFILE AUTOBACKUP ON;
- CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_GOLD4.f';
- ALLOCATE CHANNEL disk1 DEVICE TYPE DISK FORMAT '+FRA';
- ALLOCATE CHANNEL disk2 DEVICE TYPE DISK FORMAT '+FRA';
- ALLOCATE CHANNEL disk3 DEVICE TYPE DISK FORMAT '+FRA';
- ALLOCATE CHANNEL disk4 DEVICE TYPE DISK FORMAT '+FRA';
- CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 1 TIMES TO DISK COMPLETED BEFORE 'SYSDATE-3';
- backup as compressed backupset TAG='Arch_GOLD4_18052018T154302' archivelog all;
- DELETE NOPROMPT OBSOLETE;
- DELETE NOPROMPT EXPIRED BACKUP;
- }
- exit
|
