Login  Register

rman backups

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

rman backups

satish
1160 posts
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
| More
Print post
Permalink

Re: rman backups

ErmanArslansOracleBlog
Administrator
5732 posts
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
| More
Print post
Permalink

Re: rman backups

Satish
49 posts
Thanks erman it really helps