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

On Wed, 11 Jul 2007 15:23:08 -0700, hpuxrac <johnbhurley_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