OraFAQ Forum: Backup & Recovery » database failing to start up / database recovery without a backup (merged)

Home » RDBMS Server » Backup & Recovery » database failing to start up / database recovery without a backup (merged)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

database failing to start up / database recovery without a backup (merged) [message #302872]

Wed, 27 February 2008 03:50

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'

Report message to a moderator

database failing to start up [message #302876 is a reply to message #302872]

Wed, 27 February 2008 04:10

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