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
-----------------------------------------------------------------