Home » RDBMS Server » Backup & Recovery » Backing up control file (Oracle 10.2, Windows Server 2003)
Backing up control file [message #299912] Wed, 13 February 2008 11:31 Go to next message
clintonf
Messages: 82
Registered: May 2006
Member
Hi all,

Is it advisable to back-up control files to tape?

My backup strategy involves daily RMAN backups, including auto-backup of the control file. In addition I have one control file written to tape.

Is this advisable? Last night there was a locking issue between the database and the tape archiver (a 1 in a million chance I reckon, but it happened) which brought the database down entirely.

The answer seems obvious to me: don't write the control file to tape. But I (and others I am sure) would appreciate opinions from the more learned Oracle users around.

Thanks!
Re: Backing up control file [message #299915 is a reply to message #299912] Wed, 13 February 2008 11:35 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Don't directly backup the control file to tape, backup it first to disk using alter database backup controlfile and then backup the copy to tape.

Regards
Michel
Re: Backing up control file [message #299917 is a reply to message #299915] Wed, 13 February 2008 12:24 Go to previous messageGo to next message
clintonf
Messages: 82
Registered: May 2006
Member
Is configuring RMAN to autobackup the control file (and spfile) sufficient or should I be explicitly backing up the control file also?

Thanks
Re: Backing up control file [message #299921 is a reply to message #299917] Wed, 13 February 2008 12:40 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
It is theorically sufficient but as controlfile is a key component, it is better to backup it twice in different ways.

Regards
Michel
Re: Backing up control file [message #299923 is a reply to message #299912] Wed, 13 February 2008 12:44 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Is there any difference between manual controlfile backup and automatic controlfile backup?
Re: Backing up control file [message #299926 is a reply to message #299923] Wed, 13 February 2008 12:59 Go to previous message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
The way I suggest it, there is no relation at all.
"My" way does not use RMAN.
You could also use manual RMAN backup of control file, it is a third way.

Regards
Michel
Previous Topic: Datafile Recovery without backup
Next Topic: should i use rman convert?
Goto Forum:
  


Current Time: Thu Dec 05 00:45:08 CST 2024