connect target sys/newr00t@GOLD3 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 7 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_GOLD3.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 2 TIMES TO DISK; backup as compressed backupset TAG='Arch_GOLD3_21052018T164313' archivelog all; DELETE NOPROMPT OBSOLETE; DELETE NOPROMPT EXPIRED BACKUP; } exit