Re: standby delay

On Tue, 1 Mar 2005, Sybrand Bakker wrote:

> >Under 8i, I've implemented a simple script to hold the standby at a 4-hour
> >window in the past (measured from the arrival of a compressed archived
> >log), so an "ALTER DATABASE OPEN READ ONLY" lets me fish out accidentally
> >deleted objects (and the like).

> >Who needs 9i flashback? :)

> Evidently you don't know flashback has nothing to do with standby (aka
> Dataguard)
> And Dataguard comes for free with 9i.

Evidently you are a complete dolt.

Flashback gives you the power to execute queries against the database AS IT APPEARED IN THE PAST. Opening a standby in read only mode also gives you this ability.

> So who needs crappy home-grown scripts? In fact you don't even need
> them in 8i. Standby database works!

While I will refrain from describing your general outlook as "crappy," I will say that you demonstrate a profound combination of arrogance and stupidity.

> And 9i implements logical standby and delays so you scripts are fully

                                                  ^^^

If your SQL is as bad as your grammar, it's a wonder that you've any data left.

> Sybrand Bakker, Senior Oracle DBA

What a lucky organization that must be.

   / Charles J. Fisher   |"Our country? In her intercourse with foreign      /
  /  cfisher_at_rhadmin.org | nations, may she always be in the right, but our /
 /   http://rhadmin.org  | country right or wrong." - Stephen Decatur      /
---------------------------------------------------------------------------