Hello
I dumped the image of controlfile using "alter database backup controlfile to trace". It contains create command. Now how can i create the controlfile from it. could you write all the steps.
Printable View
Hello
I dumped the image of controlfile using "alter database backup controlfile to trace". It contains create command. Now how can i create the controlfile from it. could you write all the steps.
Check out technet.oracle.com
There are several notes specify for this issue written for
specific operating systems...
Follow these steps:
1. Remove the header information from the trace file
2. Rename the trace file to say "CONTROL.SQL"
3. Shutdown the database
4. svrmgr> @CONTROL.SQL
5. svrmgr> alter database open;
If you have problem opening the database now, please get back to me.