RMAN control file backup
Hi experts! We are using Oracle 12c R2 (12.2.0.1). We just change the database to run in ARCHIVELOG mode. We have the RMAN backup script running in previous 12c release (12.1.0.2) and tried to run it in 12.2.0.1.
run {
ALLOCATE CHANNEL C1 TYPE DISK;
sql create pfile='X:\orabackup\ORCLCDB\initORCLCDB.ora' from spfile;
BACKUP AS COMPRESSED BACKUPSET DATABASE FORMAT 'X:\orabackup\ORCLCDB\%d_databasefiles_%u_%s_%T';
sql 'ALTER SYSTEM ARCHIVE LOG CURRENT';
BACKUP ARCHIVELOG ALL FORMAT 'X:\orabackup\ORCLCDB\%d_archived_logs_%u_%s_%T' NOT BACKED UP 2 TIMES;
DELETE NOPROMPT ARCHIVELOG UNTIL TIME 'SYSDATE-2' BACKED UP 2 TIMES TO DEVICE TYPE DISK;