实战：Windows平台下搭建Oracle11g Dataguard

导读
本文介绍在windows server 2012 r2 环境下搭建Oracle11g Dataguard。

将数据库改为强制日志模式（此步骤只在主库上做）

SQL>alter database force logging;
SQL> select name,log_mode,force_logging from v$database;

创建密码文件（此步骤只在主库上做）

orapwd file=orapwORCL password=oracle force=y

将主库的密码文件拷贝到备库

创建standby redolog 日志组（此步骤只在主库上做）

SQL>select thread#,group#,bytes/1024/1024 from v$log;
SQL> col member for a50
SQL> select group#,member from v$logfile;

SQL>alter database add standby logfile group 101 'D:\ORADATA\ORCL\redo101.log' size 200m;
SQL>alter database add standby logfile group 102 'D:\ORADATA\ORCL\redo102.log' size 200m;
SQL>alter database add standby logfile group 103 'D:\ORADATA\ORCL\redo103.log' size 200m;
SQL>alter database add standby logfile group 104 'D:\ORADATA\ORCL\redo104.log' size 200m;

SQL> select group#,sequence#,status, bytes/1024/1024 from v$standby_log;

SQL> set pagesize 100
SQL> col member for a60
SQL> select group#,member from v$logfile order by group#;

修改主库的pfile 参数文件（此步骤只在主库上做）

SQL> show parameter spfile;
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      D:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEORCL.ORA

=======================================================================================
SQL>create pfile from spfile;

备份pfile

编辑pfile：
orcl.__db_cache_size=79691776
orcl.__java_pool_size=12582912
orcl.__large_pool_size=12582912
orcl.__oracle_base='D:\app\Administrator'#ORACLE_BASE set from environment
orcl.__pga_aggregate_target=104857600
orcl.__sga_target=419430400
orcl.__shared_io_pool_size=58720256