Monday, March 19, 2012

Code to run RMAN Level 0 Backup


RUN {
ALLOCATE CHANNEL ch00 device type disk format '/u06/oratest/db/Backup/bk_u%u_s%s_p%p_t%t';
BACKUP INCREMENTAL LEVEL=0 DATABASE;
RELEASE CHANNEL ch00;

sql 'alter system archive log current';

ALLOCATE CHANNEL ch00 device type disk format '/u06/oratest/db/Backup/arch_u%u_s%s_p%p_t%t';
BACKUP ARCHIVELOG ALL  DELETE INPUT;
RELEASE CHANNEL ch00;

ALLOCATE CHANNEL ch00 device type disk format '/u06/oratest/db/Backup/ctrl_u%u_s%s_p%p_t%t';
BACKUP CURRENT CONTROLFILE;
RELEASE CHANNEL ch00;
}

No comments:

Post a Comment