Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: What not to do in a standby environment ?
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-lReceived on Tue Dec 07 2004 - 05:45:05 CST
![]() |
![]() |