RE: Loss of One of Many System Datafiles
Date: Thu, 3 Dec 2015 03:15:21 +0000
Message-ID: <2FE2AA1C5F8DEC478F58DF8DD32BA63714D772_at_HKWPIPXMB03C.zone1.scb.net>
You’d have to delete the file that the backup admin “restored”. Of course, the database instance has to go down and then STARTUP MOUNT, RESTORE DATAFILE ‘n’, RECOVER DATAFILE ‘n’ (where ‘n’ is the file# of that datafile). You might have to OFFLINE and ONLINE the datafile.
Hemant K Chitale
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of David Barbour
Sent: Thursday, December 03, 2015 9:37 AM
To: oracle-l mailing list
Subject: Loss of One of Many System Datafiles
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.
This email and any attachments are confidential and may also be privileged. If you are not the intended recipient, please delete all copies and notify the sender immediately. You may wish to refer to the incorporation details of Standard Chartered PLC, Standard Chartered Bank and their subsidiaries at https://www.sc.com/en/incorporation-details.html
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Dec 03 2015 - 04:15:21 CET