maximum protected phsical standy database

From: <A.Bahar_at_billing-components.com>
Date: Wed, 1 Dec 2004 18:14:31 +0100
Message-ID: <CE6EC205C1F2FA40AB48B034F50317792AA442@sendling.it.corp.dir>

=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 ;

db_name =3D ODG1
instance_name =3D ODG1
service_names =3D ODG1.db.corp.dir
db_domain =3D db.corp.dir
log_archive_start =3D TRUE
remote_archive_enable =3D TRUE

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

db_name =3D ODG1
instance_name =3D ODG2
service_names =3D ODG2.db.corp.dir
db_domain =3D db.corp.dir

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

standby_archive_dest =3D "/disk1/oradata/admin/odg2/arch" db_file_name_convert =3D=20
("/disk1/oradata/odg1/","/disk1/oradata/odg2/")
log_file_name_convert =3D=20
("/disk1/oradata/odg1/","/disk1/oradata/odg2/")
standby_file_management =3D Auto
control_files =3D=20
("/disk1/oradata/odg2/ctrl/odg2_cntrl01.ctl","/disk1/oradata/odg2/ctrl/od=
g2_cnt
r
l02.ctl")

Protection mode of standby database=20

SQL> select=20
name,open_mode,protection_mode,protection_level,database_role,switchover_= status

from v$database
2 ;
NAME OPEN_MODE PROTECTION_MODE PROTECTION_LEVEL DATABASE_ROLE

--------- ---------- -------------------- -------------------- =
----------------

SWITCHOVER_STATUS

ODG1 MOUNTED MAXIMUM PERFORMANCE MAXIMUM PERFORMANCE PHYSICAL STANDBY NOT ALLOWED
SQL>=20

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Dec 01 2004 - 11:15:27 CST