Home » RDBMS Server » Backup & Recovery » unable to create the datafile which was deleted (oracle 9.2.0.6.0, o/s : sun solaris 5.9)
unable to create the datafile which was deleted [message #310070] Mon, 31 March 2008 03:12 Go to next message
kesavansundaram
Messages: 181
Registered: October 2007
Location: MUMBAI
Senior Member

Dear sir,
Iam not able to up the database.
one data file is missing it seems.
we tried to create the file..using
alter database create datafile 'a' as 'b';
but we are getting following error:

ERROR at line 1:
ORA-01516: nonexistent log file, datafile, or tempfile
"/APCTEST_DB/database/APCTEST/data/mis_data_02.dbf"

pls adv at the earliest.


rgds
kesavan.

[Edit: Remove Code tag] Taj

[Updated on: Mon, 31 March 2008 08:50] by Moderator

Report message to a moderator

Re: unable to create the datafile which was deleted [message #310073 is a reply to message #310070] Mon, 31 March 2008 03:19 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Have you a backup?
Are youi archivelog mode?
Have you all archived logs since last backup?

Regards
Michel
Re: unable to create the datafile which was deleted [message #310075 is a reply to message #310073] Mon, 31 March 2008 03:30 Go to previous messageGo to next message
kesavansundaram
Messages: 181
Registered: October 2007
Location: MUMBAI
Senior Member

Dear sir,
it is in NOARCHIVELOG mode
and we dont' have backup also.


we just want to up the database.
even if we loss any data.....no problem.

pls adv us.
kesavan.

[Edit:Remove Code Tag] Taj

[Updated on: Mon, 31 March 2008 08:50] by Moderator

Report message to a moderator

Re: unable to create the datafile which was deleted [message #310083 is a reply to message #310075] Mon, 31 March 2008 03:50 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Try "startup mount" then "drop tablespace including contents"

Regards
Michel
Re: unable to create the datafile which was deleted [message #310088 is a reply to message #310070] Mon, 31 March 2008 04:09 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Don't press the Code Tag without selecting any text.
Previous Topic: open resetlogs
Next Topic: Log_Archive_dest setting to remote standby server
Goto Forum:
  


Current Time: Thu Dec 08 16:12:04 CST 2016

Total time taken to generate the page: 0.05102 seconds