Re: What not to do in a standby environment ?
- From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- To: premj@xxxxxxxxxxxxxx
- Date: Tue, 7 Dec 2004 11:49:50 +0000
On 7 Dec 2004 10:40:16 -0000, Prem Khanna J <premj@xxxxxxxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
