Re: dataguard protection mode...

"Volker Hetzer" <volker.hetzer_at_ieee.org> wrote in message news:<cljm2i$spk$1_at_nntp.fujitsu-siemens.com>...
> Hi!
> I'm trying to switch from maximum performance to maximum availability mode
> on 9.2.0.4.
>
> I did do standby redologs on the standby database:
> GROUP# STATUS TYPE MEMBER
> ---------- ------- ------- --------------------------------------------------------------------------------
> 1 ONLINE /home/oracle/admin/NOBBY/DBFILES_LINKDIR/RedoLogs1/Redo1.rdo
...
> 6 STANDBY /home/oracle/admin/NOBBY/DBFILES_LINKDIR/StbRedoLogs1/StbRedo1.rdo
...
> And I did configure the Transport service (using dgmgrl):
> log_archive_dest_3 string service="NOBBY_ORACLE3", LGWR NOAFFIRM delay=0 OPTIONAL max_failure=0 reopen=300 async=2048 register
>
> Yet, when I "alter configuration set protection mode as maxavailability"
> I get an ORA-16627.

Hi, Volker,

Change NOAFFIRM to AFFIRM and change async=2048 to SYNC in your log_archive_dest_3. Look at Table 5-2 in "Oracle Data Guard Concepts and Administration" in 9i documentation. The Data Guard Broker documentation doesn't seem to be complete.

Yong Huang Received on Tue Oct 26 2004 - 14:01:36 CDT