rman backups

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

rman backups

satish
Dear erman,

what is the advantage of  "include current control file clause" while making full backup like below

BACKUP AS COMPRESSED BACKUPSET INCREMENTAL LEVEL=0 spfile format '${BACKUPDIR}/spfile_%d_%s_%T.bak' DATABASE INCLUDE CURRENT CONTROLFILE PLUS ARCHIVELOG;

I am aware that rman while taking system datafile backup,it will automatically perform the backup of spfile and controlfile

But there should be some difference right?
Reply | Threaded
Open this post in threaded view
|

Re: rman backups

ErmanArslansOracleBlog
Administrator
It is just an option to include to current control file in the backupset.
It works both when autobackup is on and off.
There is just a little change in the behaviour, between the cases; where we use "include current controlfile" clause with the "autobackup on" and with the "autobackup of"

Read this->

WHY THE BACKUP OF CONTROLFILE IS IN DIFFERENT BACKUPSET IF AUTOBACKUP OF CONTROLFILE IS OFF? (Doc ID 2095899.1)
Reply | Threaded
Open this post in threaded view
|

Re: rman backups

Satish
Thanks erman it really helps