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_at_cobblesoft.com>
To: <oracle-l_at_freelists.org>
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_at_freelists.org
> 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_at_freelists.org
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
-----------------------------------------------------------------
Received on Thu Aug 12 2004 - 19:18:16 CDT
