Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Flashback Technology of Oracle 10g

Re: Flashback Technology of Oracle 10g

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Mon, 20 Jun 2005 20:51:32 +0800
Message-ID: <42B6BBD4.72D2@yahoo.com>


Terminator wrote:
>
> Connor Please can you tell me the difference between the flashback
> database and the normal database and how the Flashback database can be
> created. Can it be created through the DBCA of the Oracle.
> And as you told there is another mechanism please brief it SIR.
>
> Regards
> Terminator

you enable a new form of logging called "flashback logs". They can be used to "rewind" a database back to point in time...I've done no testing as yet to determine what overhead this might have or how fast a rewind is (or isn't)

-- 
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
Co-author: "Oracle Insight - Tales of the OakTable"

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com


"Semper in excremento, sole profundum qui variat."

------------------------------------------------------------
Received on Mon Jun 20 2005 - 07:51:32 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US