Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> maximum protected phsical standy database
=20
I have configured a physical standby database in maximum performance =
mode by=20
using ARCH. I have tested and It worked.
Then I wanted to turn on "maximum protection mode". After I set =
parameters ,=20
I issued "alter database set standby database to maximize protection;".
And I have tested configuration while stanby database up and running. =
Redo=20
logs have been fetched from primary to standby site and they have been =
applied.
And then I have shutdown standby server. I have shutdown listener on =
standby=20
site. And I have issued "alter system swich logfile;". Andddd... It has=20
switched. Primary database did not shutdown as explained in metalink =
note:239100.1.
Why...? What is the wrong ? How can I realize a "maximum protected = physical standby database"
Do you have any idea ?
Is there any thing such "max.protected.phsy.standy.database" in real =
life or is it only a fable in oracle documentation which is read to =
children before they sleep.
Rgds.
Arslan BAHAR.
Parameters on primary site ;
log_archive_format =3D "log%S_%T.arc" log_archive_dest_1 =3D "LOCATION=3D/disk1/oradata/admin/odg1/arch" log_archive_dest_state_1 =3D enable log_archive_dest_2 =3D "SERVICE=3Dodg2 LGWR SYNC AFFIRM" log_archive_dest_state_2 =3D enable ---------------------------------------------------------------parameters on standby side
log_archive_start =3D TRUE log_archive_format =3D "log%S_%T.arc"=20 log_archive_dest_1 =3D "LOCATION=3D/disk1/oradata/admin/odg2/arch" log_archive_dest_state_1 =3D enable
from v$database
2 ;
NAME OPEN_MODE PROTECTION_MODE PROTECTION_LEVEL DATABASE_ROLE
--------- ---------- -------------------- -------------------- = ----------------
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Dec 01 2004 - 11:15:27 CST
![]() |
![]() |