Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Usenet -> c.d.o.server -> Re: exp and archive available.... recover table

Re: exp and archive available.... recover table

From: DA Morgan <>
Date: Sat, 14 Jul 2007 06:22:26 -0700
Message-ID: <>

Alexander Skwar wrote:
> ยท DA Morgan <>:

>> hpuxrac wrote:
>>> On Jul 12, 6:02 pm, wrote:
>>>> On Wed, 11 Jul 2007 15:23:08 -0700, hpuxrac
>>>> <> wrote:
>>>>> On Jul 9, 9:08 am, "" <> wrote:
>>>>>> On Jul 9, 6:42 am, Steve Robin <> wrote:
>>>>>>> On Jul 9, 4:28 pm, sybrandb <> wrote:
>>>>>>>> On 9 jul, 13:22, Steve Robin <> wrote:
>>>>>>>>> Last night I took table backup with exp command.
>>>>>>>>> Now since morning so many people worked on database, in evening one
>>>>>>>>> table was dropped.... (user error).
>>>>>>>>> Now I have all archive after that export.... I know that table can be
>>>>>>>>> recoverd with all data by using log minor.
>>>>>>>>> But I don't know how.... can someone pls help me with this.
>>>>>>>>> Any doc or link will help a lot....
>>>>>>>>> thanks
>>>>>>>> Look up dbms_logmnr and dbms_logmnr_d in the Oracle supplied packages
>>>>>>>> manual for your version.
>>>>>>>> NB: Exp is NOT a *backup*
>>>>>>>> also dbms_logmnr doesn't support all operations.
>>>>>>>> --
>>>>>>>> Sybrand Bakker
>>>>>>>> Senior Oracle DBA
>>>>>>> Thanks for help.
>>>>>>> if I am not mistaking.... exp is logical backup.... which can help to
>>>>>>> recover these kind of user errors as well as help us to find any block
>>>>>>> corruption also.
>>>>>>> Please inform.... because if it is wrong then I apologies for wrong
>>>>>>> comment for export.
>>>>>>> thanks- Hide quoted text -
>>>>>>> - Show quoted text -
>>>>>> An export is a logical copy of the object or objects exported at the
>>>>>> time the object copy began.  It is not a backup, even in the loosest
>>>>>> sense of the word.
>>>>>> David Fitzjarrell
>>>>> Not correct.
>>>> Not true. David is correct.
>>>> --
>>>> Sybrand Bakker
>>>> Senior Oracle DBA
>>> Not even close.  Look up logical backup ... it's a complement to a
>>> physical backup.
>>> Have you never recovered a copy of a table at a point in time from an
>>> export?
>>> Wow.
>> Have you ever recovered an export to a point after the export was
>> taken? If so double wow.

> Have you ever recovered a table to a point in time, after
> redo logs have been wiped and standby database has been
> lost? If so, tripple wow.
> Alexander Skwar

Actually I have, it is easy, and here's is how:

Following best practice guidelines the logs are duplexed with one copy going to an off-site WORM drive.

It meets the requirement for guaranteed recovery and also for audit compliance as required by government regulations in some countries and for some industries.

When you get done trolling for the title "neolithic" you might discover that a few technical advances have been made since the 1980s.

Others with an interest in "best practice" might want to follow up here:

Daniel A. Morgan
University of Washington (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Sat Jul 14 2007 - 08:22:26 CDT

Original text of this message