?

GROUP# MEMBERS M

-------------------- ----------

1 2 100

2 2 100

3 2 100

standby redo log只少应比redo log多一组，且大小相等

备库添加(启动到MOUNT)：

alter database addstandby logfile('/u01/app/oracle/oradata/standby/disk1/std_redo01.log','/u01/app/oracle/oradata/standby/disk2/std_redo01.log')size 100m;

alter database addstandby logfile('/u01/app/oracle/oradata/standby/disk1/std_redo02.log','/u01/app/oracle/oradata/standby/disk2/std_redo02.log')size 100m;

alter database addstandby logfile('/u01/app/oracle/oradata/standby/disk1/std_redo03.log','/u01/app/oracle/oradata/standby/disk2/std_redo03.log')size 100m;

alter database addstandby logfile('/u01/app/oracle/oradata/standby/disk1/std_redo04.log','/u01/app/oracle/oradata/standby/disk2/std_redo04.log')size 100m;

主库添加(因为主库有可能会切换成备库)：

alter database addstandby logfile('/u01/app/oracle/oradata/PROD/disk1/std_redo01.log','/u01/app/oracle/oradata/PROD/disk2/std_redo01.log')size 100m;

alter database addstandby logfile('/u01/app/oracle/oradata/PROD/disk1/std_redo02.log','/u01/app/oracle/oradata/PROD/disk2/std_redo02.log')size 100m;

alter database addstandby logfile('/u01/app/oracle/oradata/PROD/disk1/std_redo03.log','/u01/app/oracle/oradata/PROD/disk2/std_redo03.log')size 100m;

alter database addstandby logfile('/u01/app/oracle/oradata/PROD/disk1/std_redo04.log','/u01/app/oracle/oradata/PROD/disk2/std_redo04.log')size 100m;

?

?

?

5.开库

?

open主库后

?

备库：

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECTFROM SESSION;

?

如果有STANDBY REDO LOG：

SQL> ALTER DATABASE RECOVER MANAGED STANDBYDATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;

?

?

?

11g可以open备库,10g备库只能在MOUNT

?

RECOVER MANAGED STANDBY DATABASE CANCEL后再OPEN

?

?

6.模式切换

MAXIMUM AVAILABILITY

idle>alterdatabase set standby database to maximize AVAILABILITY;

?

Database altered.

?

idle>selectname,dbid,database_role,protection_mode from v$database;

?

NAME DBIDDATABASE_ROLE PROTECTION_MODE

--------- -------------------------- --------------------

PROD 239015079PRIMARY MAXIMUM AVAILABILITY

?

MAXIMUMPROTECTION：

idle>alterdatabase set standby database to maximize protection;

?

Database altered.

?

idle>selectname,dbid,database_role,protection_mode from v$database;

?

NAME DBIDDATABASE_ROLE PROTECTION_MODE

--------- -------------------------- --------------------

PROD 239015079PRIMARY MAXIMUM PROTECTION

?

Note that the data protection mode can be set toMAXIMUM PROTECTION on an open database only if the current data protection modeis MAXIMUM AVAILABILITY and if there is at least one synchronized standbydatabase.

?

?

11g在OPEN状态下就可以切换到MAXIMIZE PROTECTION

?

?

?

?

?

?

?

?

?

?

?

?

?

?

Configuring an Oracle Database toSend Redo Data

This section describes how toconfigure an Oracle database to send redo data to a redo transportdestination.

?

The LOG_ARCHIVE_DEST_n database initialization parameter (where n is an integer from 1 to 31) isused to specify the location of a local archive redo log or to specify a redotransport destination. This section describes the latter use of this parameter.