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

On Jul 14, 12:54 am, DA Morgan <damor..._at_psoug.org> wrote:
> 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.
> --
> Daniel A. Morgan
> University of Washington
> damor..._at_x.washington.edu (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org

Why are you even bother to continue in this thread?

Look up logical backup.

Looks like you just want to keep spamming your favorite url in this thread. Received on Sat Jul 14 2007 - 17:39:13 CDT