Database Backup and Recovery (MOSC)

MOSC Banner

RMAN control file backup

edited Jun 18, 2019 2:25AM in Database Backup and Recovery (MOSC) 6 commentsAnswered ✓

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;

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center