Sunday, 17 May 2020

Oracle FULL Database Compressed backup on Disk using RMAN

connect target /
RUN
{
ALLOCATE CHANNEL c1 DEVICE TYPE disk;
ALLOCATE CHANNEL c2 DEVICE TYPE disk;
ALLOCATE CHANNEL c3 DEVICE TYPE disk;
ALLOCATE CHANNEL c4 DEVICE TYPE disk;
sql 'ALTER SYSTEM ARCHIVE LOG CURRENT';
sql 'ALTER SYSTEM SWITCH LOGFILE';
sql 'ALTER SYSTEM SWITCH LOGFILE';
sql 'ALTER SYSTEM SWITCH LOGFILE';
CROSSCHECK ARCHIVELOG ALL;
backup AS COMPRESSED BACKUPSET full database tag PRD_FULL format '/location/%d_%T_%s_%p_FULL';
backup as compressed backupset archivelog all format 'location/%d_%s_%p_%c_%t.arc.rman';
backup current controlfile format '/location/%d_%T_%s_%p_CONTROL.ctl';
release channel c1;
release channel c2;
release channel c3;
release channel c4;
}

No comments:

Post a comment