Database Backup and Recovery (MOSC)

MOSC Banner

rman full backup with catalog

edited Aug 16, 2012 11:22AM in Database Backup and Recovery (MOSC) 2 commentsAnswered
RUN {
DELETE NOPROMPT OBSOLETE;
CROSSCHECK BACKUP;
CROSSCHECK ARCHIVELOG ALL;
DELETE NOPROMPT EXPIRED BACKUP;
DELETE NOPROMPT EXPIRED ARCHIVELOG ALL;


BACKUP
   FULL
   TAG Daily_Full_Backup
   FORMAT '%d_%t_%s_%p.dbf'
   DATABASE
   ;
BACKUP
   FORMAT '%d_%t_%s_%p.cf'
   CURRENT CONTROLFILE
   ;
SQL 'alter system archive log current';
BACKUP
   ARCHIVELOG ALL FORMAT '%d_%t_%s_%p.arch';

BACKUP VALIDATE DATABASE;
BACKUP VALIDATE DATABASE ARCHIVELOG ALL;

}

LIST BACKUP SUMMARY;

I have the above rman full database backup scripts. Currently I am testing it for backup with controlfile. If I want to start using catalog to backup now, do I need to change anything in the script? Please advice. Thank you very much.

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