On 9 jul, 13:42, 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- Tekst uit oorspronkelijk bericht niet weergeven -
>
> - Tekst uit oorspronkelijk bericht weergeven -
exp will fail if it encounters block corruption. RMAN, which is
conducting a proper physical backup, will deal with block corruption.
Depending on the size of the table, and the number of transactions,
Tablespace Point in Time Recovery, a feature of RMAN, might be
quicker, and cost less resources (especially the hours you will need
to extract all SQL from redo log files using log miner, and it also
might be incomplete).
In 10g flashback query will allow you to undo user error.
--
Sybrand Bakker
Senior Oracle DBA
Received on Mon Jul 09 2007 - 07:03:08 CDT
