oracle dataguard 太恶心了,弄了这么长时间~下面我来介绍一下最简单的安装方法~1,首先装两个相同目录的oracle(可以选择不同
oracle dataguard 太恶心了,弄了这么长时间~下面我来介绍一下最简单的安装方法~
1,首先装两个相同目录的oracle(可以选择不同的目录),因为我用的是虚机,,所以默认装在c:\app下
2,在primary库上配置client参数,tnsnames.ora 和 listener.ora, standby上面也是同理~
sid_list_listener =
(sid_list =
(sid_desc =
(sid_name = clrextproc)
(oracle_home = c:\app\product\11.2.0\dbhome_1)
(program = extproc)
(envs = extproc_dlls=only:c:\app\product\11.2.0\dbhome_1\bin\oraclr11.dll)
)
(sid_desc =
(sid_name = orcl)
(oracle_home = c:\app\product\11.2.0\dbhome_1)
)
)
listener =
(description_list =
(description =
(address = (protocol = ipc)(key = extproc1521))
(address = (protocol = tcp)(host = 192.168.70.254)(port = 1521))
)
)
orcl254 =
(description =
(address = (protocol = tcp)(host = 192.168.70.254)(port = 1521))
(connect_data =
(server = dedicated)
(service_name = orcl)
)
)
orcl253 =
(description =
(address = (protocol = tcp)(host = 192.168.70.253)(port = 1521))
(connect_data =
(server = dedicated)
(service_name = orcl)
)
)
3, enable logging:
进入sqlplus,执行alter database force logging;
4,查看日志是否归档
archive log list;
如果没有的话就执行,
sql> startup mount;
sql> alter database archivelog;
sql> alter database open;
5,重新定义pfile文件
create pfile='c:\pfile.ora' from spfile
修改对应的pfile文件(其他文档说还要备份,不用累他们~),在后面加上下面这些内容
db_unique_name=orcl254
log_archive_config='dg_config=(orcl254,orcl253)'
log_archive_dest_1='location=c:\app\oradata\orcl\ valid_for=(all_logfiles,all_roles) db_unique_name=orcl254'
log_archive_dest_2='service=orcl253 lgwr async valid_for=(online_logfiles,primary_role) db_unique_name=orcl253'
log_archive_dest_state_1=enable
log_archive_dest_state_2=enable
remote_login_passwordfile=exclusive
fal_server=orcl
fal_client=orcl
db_file_name_convert='oradata\orcl253','oradata\orcl254'
log_file_name_convert='oradata\orcl253','oradata\orcl254'
standby_file_management=auto
执行:
create spfile from pfile='c:\pfile.ora'