Home » RDBMS Server » Server Utilities » Creating a DB from CTL- and dbf files
Creating a DB from CTL- and dbf files [message #368348] Mon, 27 November 2000 03:19 Go to next message
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 Go to previous messageGo to next message
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 Go to previous message
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.
Previous Topic: Internal password
Next Topic: importing data from foxpro to oracle
Goto Forum:
  


Current Time: Thu Mar 28 23:34:53 CDT 2024