Home » RDBMS Server » Backup & Recovery » DB recovery from crash (Oracle 11g)
DB recovery from crash [message #313932] Tue, 15 April 2008 04:20 Go to next message
Messages: 6
Registered: June 2005
Junior Member
i had a db in 11g go crashed somehow. The service is not shown in the services list. I have all the datafiles and control files. Anyway to recover the DB.
Re: DB recovery from crash [message #313939 is a reply to message #313932] Tue, 15 April 2008 04:37 Go to previous messageGo to next message
Messages: 8
Registered: September 2005
Location: Karachi
Junior Member

in which form you have alls data file and control files is it cold backup by os or you have online backup?

whats crash is it datafile error or controlf file error,what does it throw error when you startup database,please give extra detail.

Re: DB recovery from crash [message #313950 is a reply to message #313932] Tue, 15 April 2008 05:31 Go to previous message
Messages: 754
Registered: October 2007
Senior Member
Just create the service.

ORADIM -NEW -SID yourSIDname -pfile "location of pfile"

start the service.
login to the database

Post the errors you get?

Is your database in archive log mode?
Previous Topic: Rman and delete obsolete files..
Next Topic: Dual backup strategy, backup to FRA and tape
Goto Forum:

Current Time: Thu Aug 24 05:48:48 CDT 2017

Total time taken to generate the page: 0.01589 seconds