Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Datafile Problem: recover, resetlogs,drop

Datafile Problem: recover, resetlogs,drop

From: A. Fuentes <alvarof2_at_hotmail.com>
Date: Mon, 07 Apr 2003 01:12:04 GMT
Message-ID: <Ef4ka.20143$vI3.702412@twister.austin.rr.com>

Fellow Oracle Netters:

I have the following problem:

Enviroment: Solaris8/Oracle9i Enterprise Server, General Purpose Testing Database in Archivelog mode.

  1. Firstly, I lost a Hard Drive Containing part of the Archived Logs. (With the oldest SCNs, I still have about 1/2 of the more recent logs).

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,

  1. Fuentes 512-297-9937
Received on Sun Apr 06 2003 - 20:12:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US