OraFAQ Forum: Backup & Recovery » Database not opening.

Home » RDBMS Server » Backup & Recovery » Database not opening. (

) 1 Vote

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

Database not opening. [message #117859]

Sat, 30 April 2005 03:47

chandanbhamra
Messages: 84
Registered: April 2005
Location: India

Member

I am getting this while opening database.
ORA-01157: cannot identify/lock data file 8 - see DBWR trace file
ORA-01110: data file 8: 'D:\ORACLE\ORADATA\GLOBALDB\TESTDATE.DBF'

I accidently removed one datafile and my database is in Noarchivelog mode. I don't have any backup also. How i can start my database.

Thanks in Advance
Chandan Singh

Report message to a moderator

Re: Database not opening. [message #117860 is a reply to message #117859]

Sat, 30 April 2005 03:56

Frank Naude
Messages: 4596
Registered: April 1998

Senior Member

Before playing around trying to open your database - TAKE A BACKUP!!!

When done, do a STARTUP MOUNT and offline the datafiles that gave errors - ALTER DATABASE DATAFILE ... OFFLINE or OFFLINE DROP. Then open the database - ALTER DATABASE OPEN.

When the database is open, drop and recreate the damaged tablespace.

Best regards.

Frank

Report message to a moderator