OraFAQ Forum: Backup & Recovery » unable to create the datafile which was deleted

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)

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

unable to create the datafile which was deleted [message #310070]

Mon, 31 March 2008 03:12

kesavansundaram
Messages: 183
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

Michel Cadot
Messages: 68650
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

Report message to a moderator

Re: unable to create the datafile which was deleted [message #310075 is a reply to message #310073]

Mon, 31 March 2008 03:30

kesavansundaram
Messages: 183
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