Sunday, 24 November 2013

RMAN backup (Control File, Data File) to specific location

Goal:

Following script will use to take RMAN backup in a specific location

run{
backup current controlfile format 'D:\RMAN\full_%s_%t_%p.ctl';
sql 'alter system switch logfile';
backup incremental level 0 format 'D:\RMAN\full_%s_%t_%p.dbf' database;
backup format 'D:\RMAN\full_%s_%t_%p.arch'  archivelog all delete input;
}

No comments:

Post a Comment