how much money do you want to spend?
If you are willing to spend a lot (like $5K for every 8 hours with a
minimum of 16 hours -- price might have gone up, it was that about 3
years ago)....
call Tech Support, ask to speak to someone in Field Support about Data
Unloader.
This is what it does perfectly -- mines the existing datafiles and
generates either sqlloader flat file input (if you don't have LONG
columns) or export dumps that can be imported.
You can restore using one of the old backups and truncate every table,
then use the Data Unloader outputs to recreate.
it will take time. Took me about 48 hours (some of which was spent
waiting for people to arrive) from the time my database crashed because
the redo logs were corrupted to the time we were back up and running.
if you want more details, email me offlist.
Rachel
- "Maser, Donna (SEA)" <Donna.Maser_at_sea.celltechgroup.com> wrote:
> HELP! I got hit with something or someone today and all the redologs
> for 2
> of my production databases disappeared. I have no idea how, and will
> leave
> it to the SysAdmin
> to figure out what happened and how to prevent it from happening
> again. I
> am not in archivelog mode and normally take nightly cold backups. If
> at all
> possible, I need to recover these databases. The other problem is
> that my
> backup script was broken and (during my absence, I should never have
> taken a
> 2 week honeymoon!) no backups were taken.
> So, I'm working with 2 week old cold backup, and wondered if anyone
> knows a
> way (unsupported, of course) to recover the tablespaces that hold
> data with
> the old system datafile?
> I have tried all methods of recovery I could come up with to get the
> database to start without the logfiles, (using "recover ... using
> backup
> controlfile", rebuilding controlfile) ... but always end up with a
> message
> that the system tablespace needs media recovery.
>
> I took a cold backup of the mess before I started tinkering with it,
> and I'm
> willing to try anything. Any ideas?
>
>
> The information contained in this email is intended for the
> personal and confidential use of the addressee only. It may
> also be privileged information. If you are not the intended
> recipient then you are hereby notified that you have received
> this document in error and that any review, distribution or
> copying of this document is strictly prohibited. If you have
> received this communication in error, please notify Celltech
> Group immediately on:
>
> +44 (0)1753 534655, or email 'is_at_celltech.co.uk'
>
> Celltech Group plc
> 216 Bath Road, Slough, SL1 4EN, Berkshire, UK
>
> Registered Office as above. Registered in England No. 2159282
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Maser, Donna (SEA)
> INET: Donna.Maser_at_sea.celltechgroup.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing
> Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Do You Yahoo!?
Check out Yahoo! Shopping and Yahoo! Auctions for all of
your unique holiday gifts! Buy at
http://shopping.yahoo.com
or bid at
http://auctions.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: wisernet100_at_yahoo.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Tue Dec 18 2001 - 04:48:55 CST