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

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. Received on Fri Jul 13 2007 - 20:23:27 CDT