Backing up control file [message #299912] |
Wed, 13 February 2008 11:31 |
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 #299926 is a reply to message #299923] |
Wed, 13 February 2008 12:59 |
|
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
|
|
|