Hi David, take a look at Metalink note 266991.1 - Recovering READONLY tablespace backups made before a RESETLOGS Open. Since you're in noarchivelog mode you may have problems, but this worked for me.
At 02:33 AM 4/17/2008, David Lord wrote:
Joe,Thanks for your reply. I think the datafile 1 thing is a red herring - everything else points to datafile 13 being the problem. I haven't applied any patches or upgrades, but I wouldn't be at all surprised if you're right about there being a corruption in the datafile header.Regards David Lord
-- //www.freelists.org/webpage/oracle-l
