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
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Fri Jul 13 2007 - 23:54:04 CDT
