Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Advanced Replication Question for Advanced DBAs
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
![]() |
![]() |