Database Backup and Recovery (MOSC)

MOSC Banner

archive logs as part of an RMAN backup

edited Jan 30, 2014 4:20AM in Database Backup and Recovery (MOSC) 2 commentsAnswered ✓
Hi
we take RMAN backups using the following

RUN {
ALLOCATE CHANNEL ch1 TYPE
DISK FORMAT '/RMAN/BACKUPS/FULL/%d_DB_%T_%u_%s_%p';
CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET;
BACKUP DATABASE PLUS ARCHIVELOG;
CROSSCHECK BACKUP;
DELETE NOPROMPT EXPIRED BACKUP;
CROSSCHECK ARCHIVELOG ALL;
DELETE NOPROMPT ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-3';
RELEASE CHANNEL ch1;
}
EXIT;
EOF

we use the following to do the restore

rman target / <<EOF
startup nomount
restore spfile to pfile '/RMAN/BACKUPS/FULL/init$sid.ora' from '/RMAN/BACKUPS/FULL/$RMAN_CONTROLFILE';
shutdown immediate
startup nomount pfile='/RMAN/BACKUPS/FULL/init$sid.ora';

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