ocm中dataguar的配置，在同一主机上实现 1、打开主数据库的logging功能alter database force logging;2、打开主数据库的归档功能
ocm中dataguar的配置，在同一主机上实现
1、打开主数据库的logging功能
alter database force logging;
2、打开主数据库的归档功能
alter database archivelog;
3、关闭主数据库，启动到mount模式
alter database add standby logfile group 4 '/oracle/oradata/test/sredo4.dbf' size 20m;
alter database add standby logfile group 5 '/oracle/oradata/test/sredo5.dbf' size 20m;
alter database add standby logfile group 6 '/oracle/oradata/test/sredo6.dbf' size 20m;
alter database create standby controlfile as '/oracle/oradata/std/control01.dbf';
备份主数据库的数据文件、控制文件到/oracle/oradata/std/
4、配置网络参数
监听器和tnsnames
主库与从库的listener.ora
listener =
   (description_list =
     (description =
        (address_list =
        (address = (protocol = tcp)(host = db)(port = 1521))
        )
     )
   )
sid_list_listener =
   (sid_list =
      (sid_desc =
        (global_dbname = test)
        (oracle_home = /oracle/db10g)
        (sid_name = test)
      )
      (sid_desc =
        (global_dbname = standby)
        (oracle_home = /oracle/db10g)
        (sid_name = stb)
      )
   )
主库与从库的tnsnames.ora：
test =
   (description =
      (address_list =
         (address = (protocol = tcp)(host = db)(port = 1521))
      )
      (connect_data =
         (server = dedicated)
         (service_name = test)
      )
   )
stb =
   (description =
      (address_list =
         (address = (protocol = tcp)(host = db)(port = 1521))
      )
      (connect_data =
         (server = dedicated)
         (service_name = stb)
      )
   )
5、创建备用数据库的参数文件
create pfile from spfile;
cp inittest.ora initstb.ora
主test数据库创建pfile文件，添加以下参数：
注：删除一切关于mts的参数（shared server）
db_unique_name=test
log_archive_config='dg_config=(test,stb)'
log_archive_dest_1='location=/oracle/arch/test valid_for=(all_logfiles,all_roles) '
log_archive_dest_2='service=stb lgwr async valid_for=(online_logfiles,primary_role)  db_unique_name=standby'
fal_server=stb
fal_client=test
db_file_name_convert='/oracle/oradata/stb','/oracle/oradata/test'
log_file_name_convert='/oracle/oradata/stb','/oracle/oradata/test'
standby_file_management=auto
从库standby数据库修改以下pfile内容
control_files='/oracle/oradata/stb/control01.ctl'
core_dump_dest='/oracle/admin/stb/cdump'
user_dump_dest='/oracle/admin/stb/udump'
background_dump_dest='/oracle/admin/stb/bdump'
以下为添加的参数
db_unique_name=stb
log_archive_config='dg_config=(stb,test)'
log_archive_dest_1='location=/oracle/arch/stb valid_for=(all_logfiles,all_roles) '
log_archive_dest_2='service=test lgwr async valid_for=(online_logfiles,primary_role) db_unique_name=test'
fal_server=test
fal_client=stb
db_file_name_convert='/oracle/oradata/test','/oracle/oradata/stb'
log_file_name_convert='/oracle/oradata/test','/oracle/oradata/stb'
standby_file_management=auto
6、启动从库到mount，，并把数据库变成recover managed状态，注意过程从库的警告日志文件：
sql>startup mount；
alter database recover managed standby database disconnect from session;
7、启动主库数据库，切换日志，并观察主从库的警告日志文件，如果归档成功，说明配置成功：
sql>alter system switch logfile;
8、主从角色的切换，主库查看状态：
sql> select switchover_status from v$database;
switchover_status
 -----------------
 to standby
sql>alter database commit to switchover to standby;
9、从库操作：
sql>alter database commit to switchover to primary;
10、在主库上（注意此时的角色转换）切换日志，如果主从库归档成功，说明standby配置成功。
更多oracle相关信息见oracle 专题页面 ?tid=12