| Creating a DB from CTL- and dbf files [message #368348] |
Mon, 27 November 2000 03:19  |
Guenter
Messages: 1
Registered: November 2000
|
Junior Member |
|
|
My server crashed and all what was left are the datafiles (dbf), redologs and ctl files. Is it possible to get my database back from this?
Please help if you know a way!
|
|
|
|
| Re: Creating a DB from CTL- and dbf files [message #368349 is a reply to message #368348] |
Mon, 27 November 2000 15:32  |
Bala
Messages: 205
Registered: November 1999
|
Senior Member |
|
|
Hi,
I hope you have init.ora file(initialization parameters file)
You can try a manual recovery..
By mounting and recovering the database.
start svrmgrl and issue the following commands.
SVRMGRL> set instance (your_instance_name)
SVRMGRL>startup mount
SVRMGRL>recover database until cancel;
SVRMGRL>alter database open resetlogs;
Bala.
|
|
|
|
| Re: Creating a DB from CTL- and dbf files [message #368350 is a reply to message #368348] |
Mon, 27 November 2000 15:32 |
Bala
Messages: 205
Registered: November 1999
|
Senior Member |
|
|
Hi,
I hope you have init.ora file(initialization parameters file)
You can try a manual recovery..
By mounting and recovering the database.
start svrmgrl and issue the following commands.
SVRMGRL> set instance (your_instance_name)
SVRMGRL>startup mount
SVRMGRL>recover database until cancel;
SVRMGRL>alter database open resetlogs;
Bala.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
