Home » RDBMS Server » Backup & Recovery » database failing to start up / database recovery without a backup (merged)
database failing to start up / database recovery without a backup (merged) [message #302872] Wed, 27 February 2008 03:50 Go to next message
vmuzenda
Messages: 3
Registered: February 2008
Location: Harare
Junior Member
i am trying to recover a datafile from a hardware failure and i am getting this error




ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/data7/ics/icsdev/dbicsdev01/system01.dbf'

database failing to start up [message #302876 is a reply to message #302872] Wed, 27 February 2008 04:10 Go to previous messageGo to next message
vmuzenda
Messages: 3
Registered: February 2008
Location: Harare
Junior Member
i have done this but my database is refusing to start and i dont have a a cold backup . How do i solve the issue pliz help

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open


SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ora-01110: data file 1: '/home/oracle/oradata/ics/system01.dbf'

[Updated on: Wed, 27 February 2008 04:13]

Report message to a moderator

Re: database failing to start up [message #302883 is a reply to message #302876] Wed, 27 February 2008 04:27 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Try "recover automatic database" in mount mode.
If it fails, you lost your database.

Regards
Michel
Re: database failing to start up [message #302895 is a reply to message #302876] Wed, 27 February 2008 05:06 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
vmuzenda wrote on Wed, 27 February 2008 05:10
... i dont have a a cold backup .

Do you have any backups?

Are your redo logs still accessible?
Re: database failing to start up [message #303097 is a reply to message #302895] Wed, 27 February 2008 23:53 Go to previous messageGo to next message
vmuzenda
Messages: 3
Registered: February 2008
Location: Harare
Junior Member
my redo logs are not accessible and i cant locate them
Re: database failing to start up [message #303107 is a reply to message #303097] Thu, 28 February 2008 00:29 Go to previous message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So you lost your database.

Regards
Michel
Previous Topic: RMAN: Recover from new backup set to point-in-time in the past
Next Topic: recover database with out redo and controlfiles
Goto Forum:
  


Current Time: Fri Dec 09 05:54:02 CST 2016

Total time taken to generate the page: 0.25361 seconds