Home » RDBMS Server » Backup & Recovery » Database not opening.  () 1 Vote
Database not opening. [message #117859] Sat, 30 April 2005 03:47 Go to next message
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
Re: Database not opening. [message #117860 is a reply to message #117859] Sat, 30 April 2005 03:56 Go to previous messageGo to next message
Frank Naude
Messages: 4579
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
Re: Database not opening. [message #117861 is a reply to message #117860] Sat, 30 April 2005 05:02 Go to previous messageGo to next message
chandanbhamra
Messages: 84
Registered: April 2005
Location: India
Member
Thanks. My database is up Now.

Frank Naude wrote on Sat, 30 April 2005 14:26

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


Re: Database not opening. [message #117894 is a reply to message #117860] Sat, 30 April 2005 17:12 Go to previous message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
Frank Naude wrote on Sat, 30 April 2005 10:56

TAKE A BACKUP!!!

I wish our (ex-)DBA had read this IMG . The poor fellow was learning Unix ("rm -r" anyone?)
Previous Topic: RMAN stuck in scheduled status ...
Next Topic: when to delete archive log file
Goto Forum:
  


Current Time: Fri Mar 29 06:33:48 CDT 2024