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

From: Alexander Skwar <usenet_at_alexander.skwar.name>
Date: Sat, 14 Jul 2007 11:58:25 +0200
Message-ID: <1275480.AfhysX43TK@m-id.message-center.info>

· DA Morgan <damorgan_at_psoug.org>:

> hpuxrac wrote:

>> On Jul 12, 6:02 pm, sybra..._at_hccnet.nl wrote:

>>> On Wed, 11 Jul 2007 15:23:08 -0700, hpuxrac
>>>
>>>
>>>
>>>
>>>
>>> <johnbhur..._at_sbcglobal.net> wrote:
>>>> On Jul 9, 9:08 am, "fitzjarr..._at_cox.net" <fitzjarr..._at_cox.net> wrote:
>>>>> On Jul 9, 6:42 am, Steve Robin <ocma..._at_gmail.com> wrote:
>>>>>> On Jul 9, 4:28 pm, sybrandb <sybra..._at_gmail.com> wrote:
>>>>>>> On 9 jul, 13:22, Steve Robin <ocma..._at_gmail.com> 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

-- 
<Mercury> Knghtbrd: I'd love to see support for xor crosshairs..
<Knghtbrd> Mercury: you're on quack.
<Mercury> Knghtbrd: You're the dealer... <G>
*** Knghtbrd is now known as QuackDealer

Received on Sat Jul 14 2007 - 04:58:25 CDT