Home » RDBMS Server » Backup & Recovery » backup of controlfile not taking place in 9i ? (merged)
backup of controlfile not taking place in 9i ? (merged) [message #401111] Fri, 01 May 2009 12:32 Go to next message
tridentadm
Messages: 142
Registered: March 2006
Senior Member
The RMAN behavior when the BACKUP command includes datafile 1 depends on the CONFIGURE CONTROLFILE AUTOBACKUP setting. If control file autobackups are ON and the backup includes datafile 1, RMAN writes the control file and SPFILE to a separate autobackup backup set. If control file autobackups are OFF and the backup includes datafile 1, then RMAN includes the current control file and SPFILE in the same backup set as the datafiles.


Reference :
Oracle® Database Backup and Recovery Advanced User's Guide
10g Release 2 (10.2)
Part Number B14191-02


Is this case different for 9i database where RMAN is used ?

Re: backup of controlfile not taking place in 9i ? (merged) [message #401632 is a reply to message #401111] Tue, 05 May 2009 20:15 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Should be the same for 9i (Control File and Server Parameter File Autobackups).

What does LIST BACKUP OF CONTROLFILE show ?
Previous Topic: ORA-16038: log 6 sequence# 5238 cannot be archived
Next Topic: rman waits long time while exiting
Goto Forum:
  


Current Time: Sat Dec 14 17:36:29 CST 2024