Problem after restore and recovery...HELP!

From: <chiuljnk_at_my-deja.com>
Date: Wed, 25 Aug 1999 18:08:41 GMT
Message-ID: <7q1beu$60n$1@nnrp1.deja.com>

I backed up DB1 in online mode.
During the online backup, another DBA added a datafile. This datafile was not backed up.
At the end of the online backup, I backed up the archive logs generated during the online backup. Also, I backed up controlfile to trace

I then restored the online backup of DB1 to another server, renaming it DB2. Edited trace to reflect new name. Because new datafile was not part of the backup set, creating the new controlfiles using trace sql script failed. Edited trace again to remove line referencing new datafile. Created new controlfiles using trace successfully.

Rolled forward a bunch of archivelogs.
Error encountered.
File #198 added to control file as 'UNNAMED0198'. Originally created as: '/oracle/DB1/data1/data37'
Media Recovery failed with error 1244

Entered command: alter database create datafile 'UNNAMED0198'. This created a 10M file in /oracle/DB1/dbs directory called UNNAMED0198.

Continue rolling forward until all archivelogs (generated during backup) are applied. No more errors.

Entered command: alter database archivelog and alter database open resetlogs. Success.

PROBLEM:
For some reason, added datafile added is somehow corrupted. It has status OFFLINE. But I can't bring it online because I get the error:
alter database datafile '/oracle/DB2/data1/data37' online *
ORA-01190: control file or data file 198 is from before the last RESETLOGS
ORA-01110: data file 198: '/oracle/DB2/data1/data37'

I can't drop the datafile.
Database is functioning without error, but I can't bring tablespace DATA into backup mode for online backups.
I am guessing that after creating the datafile, it was offline the entire time, even through the roll-forward. That means that there is no data in the datafile. How can I get rid of this datafile without dropping the entire tablespace?

Thank you very much for your assistance.

Regards,
Larry Chiu
chiuljnk_at_my-deja.com

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Aug 25 1999 - 13:08:41 CDT