Oracle Database Discussions

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!

Backing up of controlfile

819156Aug 22 2012 — edited Aug 22 2012

Sirs,
One of my DBA friends told me that every time I add a datafile to a tablespace or resize a datafile or add a log file, I need to take a backup of control file using alter database backup controlfile to trace. He was not able to explain me the reason behind this.

Can any experts explain if it's required to backup controlfile after these activities? If yes, why?

Thanks
Neel

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 19 2012

Added on Aug 22 2012

#general-database-discussions

8 comments

357 views