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
vinu.m@naizak.com
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.

Report message to a moderator

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
Shahzad_Khan
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.

Khurram

Report message to a moderator

Re: DB recovery from crash [message #313950 is a reply to message #313932] Tue, 15 April 2008 05:31 Go to previous message
varu123
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?

Report message to a moderator

Previous Topic: RMAN variables
Next Topic: Rman and delete obsolete files..
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Nov 26 07:16:41 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.