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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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
