Recovery Help? 2004-08-13 - By Ruth Gramolini
Have they tried: 'recover using backup controlfile until cancel; ' and
cancelling when it asks for the archivelog from July 2.
Just a thot!
Ruth
-- --Original Message-- --
From: oracle-l-bounce@(protected)
[mailto:oracle-l-bounce@(protected)]On Behalf Of
rstevenson@(protected)
Sent: Thursday, August 12, 2004 8:01 PM
To: oracle-l@(protected)
Subject: Recovery Help?
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
