Linux环境下oracle9i的Data guard配置

*.DB_FILE_NAME_CONVERT=("/home/oracle/oradata/primary","/home/oracle/oradata/oracle")

*.LOG_FILE_NAME_CONVERT=("/home/oracle/oradata/archivelog","/home/oracle/oradata/archivelog")

*.STANDBY_FILE_MANAGEMENT='AUTO'

删除 log_archive_dest_2参数

修改standby的参数文件initoracle.ora(先做好备份)

增加

*.log_archive_dest_2='service=primary mandatory reopen=60'

*.log_archive_dest_state_2='ENABLE'

删除

*.STANDBY_ARCHIVE_DEST=/home/oracle/oradata/archivelog

*.fal_server='standby'

*.fal_client='primary'

*.DB_FILE_NAME_CONVERT=("/home/oracle/oradata/primary","/home/oracle/oradata/oracle")

*.LOG_FILE_NAME_CONVERT=("/home/oracle/oradata/archivelog","/home/oracle/oradata/archivelog")

*.STANDBY_FILE_MANAGEMENT=AUTO

在primary主机上执行

SQL> alter database commit to switchover to physical standby with session shutdown ;

Database altered.

察看primary主机上的后台日志

…………………………….

SQL> shutdown immediate

ORA-01507: database not mounted

ORACLE instance shut down.

以备用模式（standby）启用主数据

SQL> create spfile from pfile;

SQL> startup nomount;