| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: LogMiner-PITR
Hi Joe,
thanks for reply, but its not cleared yet. I am saying that we can also
recover data by undoing some changes through logminer, and we can also
select the data by giving some time range and then why can't we say it point
in time recovery at , say, data level. Yes TSPITR is done at database level,
can we say logminer does the DPITR(Data Point in Time Recovery)?
thanks,
regards
Fahd
----- Original Message -----
From: "Joe Testa" <jtesta_at_dmc-it.com>
To: <oracle-l_at_freelists.org>
Sent: Monday, April 12, 2004 3:51 PM
Subject: Re: LogMiner-PITR
> thats not considered point in time recovery, as PITR at the database
> level where you restore and roll all changes across the database to a
> point in timke(ie: specific SCN).
>
> What logminer gives you is the capability to undo changes WITHOUT having
> to do a PITR. Yes its a bit more complex than that but thats the idea.
>
> yes, you can get the undo for redo thats happened during a particular
> time window, does logminer handle everything, absolutely not, but you
> can find its limitations in the docs.
>
> joe, the one who's milked logminer presentations at IOUG for way too
> many years :)
>
>
> Fahd Mirza wrote:
>
> >Hi All,
> > My question is:
> > LogMiner can be used to undo some changes in database by selecting
the redo logs between the given time range. Can we termed this process as
Point in Time recovery? Please give me a line.
> >Thanks
> >regards,
> >Fahd
> >----------------------------------------------------------------
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >----------------------------------------------------------------
> >To unsubscribe send email to: oracle-l-request_at_freelists.org
> >put 'unsubscribe' in the subject line.
> >--
> >Archives are at http://www.freelists.org/archives/oracle-l/
> >FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> >-----------------------------------------------------------------
> >
> >
> >
>
> --
> Joseph S Testa
> Chief Technology Officer
> Data Management Consulting
> p: 614-791-9000
> f: 614-791-9001
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Mon Apr 12 2004 - 05:56:35 CDT
 |
 |