I 'm seeking help/advice from the list on behalf of a client that no longer has a DBA - and has a production DB utterly screwed up - hope you can help me point them in the right direction.... I 've tried the basics ... but then I 'm only knowledgeable enough in this area to be dangerous!
Situation: Remote DB (Linux/8.1.7) - they lost a drive/mount point - and then lost the frame relay for best part of 3 weeks (thanks to Sprint efficiency). The system tried to perform automated disk-to-disk backups (cold, via crontab) then to tape, but failed when it hit the bad drive - each day!
Result: Their DB is mostly at July 14 - with the restore of the bad drive at Aug 3rd (includes a System datafile, 1 data and an index datafile). When I try to recover for them, it calls for archive logs dated July 2nd - and they only have ones going back to July 3rd..... Their backup cycle is a 7-day cycle (with no secure copy archived off) - so they have no good consistent backup to restore from...
At this stage, they 'd be real happy just to get a db back, even if several weeks old. My viewpoint at this stage is that there are no options ... but then I 'm hoping for them that maybe one of you knows differently???
Thanks for thoughts ...
Richard
PS: I can be reached tomorrow toll free at 1-866-380-6716 if you have something that will work that 's tough to explain in an email.
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
