| recovery using a backuped control file! [message #57005] |
Tue, 13 May 2003 23:54  |
Muhammad Waqas Shabir
Messages: 26
Registered: April 2003
|
Junior Member |
|
|
Hi!
I have backed up a binary control file using command: alter database backup controlfile to 'path';
how can i use this file if my original control file becomes unavailable/deleted?
my second question to you is that if i have used the command:
alter database backup controlfile to trace;
how will i read that create control file script, how will i use this command after issuing it...
Waiting for your response!
S. M. Waqas Shabir
|
|
|
|
| Re: recovery using a backuped control file! [message #57023 is a reply to message #57005] |
Thu, 15 May 2003 03:33  |
Deepa
Messages: 269
Registered: November 2000
|
Senior Member |
|
|
hi,
With binary controlfile , u copy the control file to the location specified in the init.ora file.
Oracle will automatically take from the location.
With trace of the controlfile,
U can find the script in USER_DUMP_DESt.Edit according to your requirements.
copy the script
Then in svrmgrl,
startupmount
Then paste the script....
but make sure u open the database after this operation with resetlogs option and them make a complete backup of the database again as all ur old backups will be invalidated.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
