1 环境说明 两台数据库，分别为Beijing和shanghai，配置为Physical Standby Database。并进行主备切换测试。 2 设置Primary Database 2.1 启用Forced Logging SYS@BEIJING> col FORCE_LOGGING for a15 SYS@BEIJING> select FORCE_LOGGING from v$database; FORCE_LOGGING --------------- NO 启用Forced Logging SYS@BEIJING> alter database force logging; Database altered. 2.2 检查密码文件 [oracle@secdb1 dbs]$ ls /u01/app/oracle/product/10.2.0/db_1/dbs/ hc_BEIJING.dat  init.ora      lkBEIJING     spfileBEIJING.ora initdw.ora   initBEIJING.ora  orapwBEIJING  sqlnet.log 保证所有节点的sys密码必须一致 2.3  配置Standby Redo Log 查看现有日日志组 SYS@BEIJING> select * from v$logfile; GROUP# STATUS  TYPE    MEMBER            IS_ ---------- ------- ------- ------------------------------------- 1 ONLINE /u01/app/oracle/oradata/BEIJING/disk1/redo01.log NO 2 ONLINE … [Read more...]