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

On Jul 12, 3: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.
>

Come on, guys, http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/glossary.htm#sthref879 , you can search the metalink knowledgebase for "logical backup" with the quotes. If you are going to argue semantics, you need to account for Oracle's usage. And you need to tell me what is the magical thing I do that lets me keep table data so I can get it back after I wipe it out.

jg

--
@home.com is bogus.
Dirty job, but someone's gotta do it:
http://www.signonsandiego.com/uniontrib/20070712/news_1n12nukes.html