Loss of One of Many System Datafiles
Date: Wed, 2 Dec 2015 19:37:25 -0600
Message-ID: <CAFH+ifcQQ+0NoiSFti3Fc9eAgxb3-rGQq_S9AZ7iQNS=agyeMg_at_mail.gmail.com>
Oracle 10.2.0.5 HPUX 11.23 - And This is not Going to Upgraded - stuck with it due to the SAP version and resistance to change.
This is an old SAP database that has been around for years. The system tablespace now has 6 different datafiles in various filesystems/directories. Today about 11:30 or so as far as I can tell, one of these was accidentally deleted. Our backup admin restored the deleted file and I became aware of a problem about 3PM when OEM started sending me alerts about ORA-0600 errors.
The application and database are currently operating, the controlfiles are good, and no datafiles were deleted so I'm not going into panic mode or anything, I think it's a relatively standard recovery scenario, but just want some affirmation.
We've got a good backup from last night as well as all the archivelogs from before the backup through now.
Here's what I'm thinking:
First, stop and restart the database at which point, since we’ve restored a piece of the system tablespace, I’d expect to get the ‘needs media recovery’ error and then we’d apply the archivelogs.
If that didn’t work, make copies of all the datafiles, ask the backup admin to restore all 6 files, then proceed with startup and recovery.
If that doesn’t work, when the hangover wears off, restore the database from last night’s backup and roll forward using the archive logs.
Feedback appreciated.
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Dec 03 2015 - 02:37:25 CET