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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Advanced Replication Question for Advanced DBAs

RE: Advanced Replication Question for Advanced DBAs

From: Jyoti Randive <jnair75_at_hotmail.com>
Date: Wed, 03 Jan 2001 17:31:14
Message-Id: <10730.125601@fatcity.com>


You do not have to shutdown the db when switching mode between recovery and read only.
Try
>alter database close;

Then you issue
alter database recover standby database before putting it back to managed recover mode.
'alter database recover automatic standby database' also works.

This way you do not have to shutdown the database;

Well, standby is a pain to maintain.
So we have moved to HA solutions (but we got to pay more bucks to SNA and all those disky people).
HTH.
JR



Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Received on Wed Jan 03 2001 - 17:31:14 CST

Original text of this message

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