Re: What not to do in a standby environment ?

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Tue, 7 Dec 2004 11:49:50 +0000
Message-ID: <7765c89704120703492a530abb@mail.gmail.com>

On 7 Dec 2004 10:40:16 -0000, Prem Khanna J <premj_at_rediffmail.com> wrote:
> Hi Friends,
> I would like to know the list of "NOT TO DO" on
> Primary database in Standby database environment.

not appropriate for 817, but I suspect that FLASHBACK functionality might be an interesting experiment on a standby database. the 'UNRECOVERABLE' keyword and INSERT /*+APPEND */ would be good key words to avoid. To be honest though I think that any production database that *doesn't* have FORCE LOGGING run on it needs to carefully justify that decision.

I wonder if renaming the database and moving the archivelog destinations are good ways to break the standby as well.

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
--
http://www.freelists.org/webpage/oracle-l

Received on Tue Dec 07 2004 - 05:45:05 CST