Backup controlfiles and recovery? [message #54968] |
Fri, 20 December 2002 12:32 |
Jeff
Messages: 63 Registered: July 1999
|
Member |
|
|
I'm trying to figure out what the best way to backup a controlfile is to ensure it will be suitable to use for recovery. I can't just make a copy of a controlfile with the OS commands while the database is up, right? If I use "backup controlfile to <PATH>" will that give me a binary copy of the controlfile that IS valid for recovery?
|
|
|
|
Re: Backup controlfiles and recovery? [message #54991 is a reply to message #54968] |
Mon, 23 December 2002 13:00 |
ctg
Messages: 146 Registered: July 2002
|
Senior Member |
|
|
yes you can use a backup controlfile taken with the ALTER DATABASE BACKUP CONTROLFILE TO 'filename' to recover your database.
you would just have to make sure when you do the recovery, you specify USING BACKUP CONTROLFILE.
|
|
|
|