Re: LogMiner-PITR

  • From: Joe Testa <jtesta@xxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 12 Apr 2004 06:51:03 -0400

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@xxxxxxxxxxxxx
>put 'unsubscribe' in the subject line.
>--
>Archives are at //www.freelists.org/archives/oracle-l/
>FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: