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