dataguard protection mode...

From: Volker Hetzer <volker.hetzer_at_ieee.org>
Date: Mon, 25 Oct 2004 22:01:21 +0200
Message-ID: <cljm2i$spk$1@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
         1         ONLINE  /home/oracle/admin/NOBBY/DBFILES_LINKDIR/RedoLogs2/Redo1.rdo
         2         ONLINE  /home/oracle/admin/NOBBY/DBFILES_LINKDIR/RedoLogs1/Redo2.rdo
         2         ONLINE  /home/oracle/admin/NOBBY/DBFILES_LINKDIR/RedoLogs2/Redo2.rdo
         3         ONLINE  /home/oracle/admin/NOBBY/DBFILES_LINKDIR/RedoLogs1/Redo3.rdo
         3         ONLINE  /home/oracle/admin/NOBBY/DBFILES_LINKDIR/RedoLogs2/Redo3.rdo
         4         ONLINE  /home/oracle/admin/NOBBY/DBFILES_LINKDIR/RedoLogs1/Redo4.rdo
         4         ONLINE  /home/oracle/admin/NOBBY/DBFILES_LINKDIR/RedoLogs2/Redo4.rdo
         5         ONLINE  /home/oracle/admin/NOBBY/DBFILES_LINKDIR/RedoLogs1/Redo5.rdo
         5         ONLINE  /home/oracle/admin/NOBBY/DBFILES_LINKDIR/RedoLogs2/Redo5.rdo
         6         STANDBY /home/oracle/admin/NOBBY/DBFILES_LINKDIR/StbRedoLogs1/StbRedo1.rdo
         6         STANDBY /home/oracle/admin/NOBBY/DBFILES_LINKDIR/StbRedoLogs2/StbRedo1.rdo
         7         STANDBY /home/oracle/admin/NOBBY/DBFILES_LINKDIR/StbRedoLogs1/StbRedo2.rdo
         7         STANDBY /home/oracle/admin/NOBBY/DBFILES_LINKDIR/StbRedoLogs2/StbRedo2.rdo
         8         STANDBY /home/oracle/admin/NOBBY/DBFILES_LINKDIR/StbRedoLogs1/StbRedo3.rdo
         8         STANDBY /home/oracle/admin/NOBBY/DBFILES_LINKDIR/StbRedoLogs2/StbRedo3.rdo
         9         STANDBY /home/oracle/admin/NOBBY/DBFILES_LINKDIR/StbRedoLogs1/StbRedo4.rdo
         9         STANDBY /home/oracle/admin/NOBBY/DBFILES_LINKDIR/StbRedoLogs2/StbRedo4.rdo
        10         STANDBY /home/oracle/admin/NOBBY/DBFILES_LINKDIR/StbRedoLogs1/StbRedo5.rdo
        10         STANDBY /home/oracle/admin/NOBBY/DBFILES_LINKDIR/StbRedoLogs2/StbRedo5.rdo
        11         STANDBY /home/oracle/admin/NOBBY/DBFILES_LINKDIR/StbRedoLogs1/StbRedo6.rdo
        11         STANDBY /home/oracle/admin/NOBBY/DBFILES_LINKDIR/StbRedoLogs2/StbRedo6.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.

Any ideas what I do wrong?

Lots of Greetings!
Volker Received on Mon Oct 25 2004 - 15:01:21 CDT