Recovery Help? 2004-08-12 - By Darrell Landrum
Hi Richard, I know this isn 't the help you 're looking for, but these folks
really need to get oracle support involved. There are a lot of seriously
knowledgeable and experienced folks on this list, but I 'm not sure how many
would have the time to devote to this recovery. I know I 'm talking money
(assuming they don 't have support already or they would be involved
already), but they have "alternative " options for recovery that aren 't
typically supported. Some of these options may (and that is only a maybe)
help you get past that missing archived redo log.
Good luck with this!
-- -- Original Message -- --
From: <rstevenson@(protected) >
To: <oracle-l@(protected) >
Sent: Thursday, August 12, 2004 7:01 PM
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
