Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Control file and spfile backup

Rosh_dbaJun 18 2014 — edited Jun 18 2014


Hello All,

This is regarding a 11gR2 database .There is a script running to take full database backup.

crosscheck archivelog all;

crosscheck backup;

backup database;

backup archivelog all delete input;

delete noprompt obsolete;

I checked the controlfile autobackup  using  ------show controlfile autobackup;    and it is turned OFF

But when I run ----- list backup of controlfile ; and  list backup of spfile;

I find that contolfile is getting backed up and also spfile  through the above script

Can someone please explain me how this is happening without controlfile autobackup

Thanks in advance

This post has been answered by Levi Pereira on Jun 18 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 16 2014
Added on Jun 18 2014
5 comments
3,883 views