Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Datafile Problem: recover, resetlogs,drop
Fellow Oracle Netters:
I have the following problem:
Enviroment: Solaris8/Oracle9i Enterprise Server, General Purpose Testing Database in Archivelog mode.
After part of these archived logs were lost, one of the datafiles, say
MyDatafile1.dbf (non-system) needed
recovery, so I have been doing: SQL> recover automatic datafile
'/mypath/MyDatafile1.dbf'; and replies with:
ORA-01179: file /mypath/MyDatafile.dbf does not exist.
I checked /mypath/MyDatafile and the file is there!!!
2)Then I do: SQL> alter database open;
Error ORA-01589: must use RESETLOGS or NORESETLOGS
Then I did: SQL> alter database open NORESETLOGS; ORA-01113: Datafile 11 Needs Media Recovery. ORA-01110: Datafile 11: '/mypath/MyDatafile1.dbf'
If I do again the SQL> recover automatic datafile '/mypath/MyDatafile1.dbf'
same response and error
as described above ORA-01179 Datafile doesnt exist.
3)For the sake of continuing my evaluation and testing, it is more important
to me to be able to
open this database, so I did:
SQL> alter database datafile '/mypath/MyDatafile1.dbf' drop; and it comes:
ORA-01916: Keyword ONLINE, OFFLINE, RESIZE, AUTOEXTEND, or END/DROP
expected.
(but the keyword DROP is there!!!)
Eventhough the bad datafile MyDatafile1.dbf is already offline, I also did:
SQL> alter database datafile '/mypath/MyDatafile1.dbf' offline drop; and it
came:
ORA-0116: Nonexistent Log file, datafile, or temp file
'/mypath/MyDatafile1.dbf'
I would appreciate any ideas/suggestions about how to Drop or Erase this bad
datafile and
be able to Open the database.
Thanks in advance,
![]() |
![]() |