1.Configure Oracle Net
2.Configure Primary Database
3.Configure Physical Standby Database
4.Testing & Troubleshooting
第一步:配置网络连接
1.配置主库的tnsnames
2.配置备库的tnsnames
保证主库连接备库和备库连接主库成功。
第二步:配置主库
主库操作
1.强制设定主库为logging
alter database force logging
2.创建pfile
create pfile from spfile
3.创建口令文件
orapwd file=orapwdbbk0110g.ora password=oracle entries=5
4.配置pfile文件
log_archive_dest_1='LOCATION=/u010g/oradata/archive'
log_archive_dest_state_1=enable
log_archive_dest_2='SERVICE=standby'
log_archive_dest_state_2=enable
log_archive_format='%t_%s_%r.arc'
log_archive_max_processes=2
fal_server=standby
fal_client=primary
db_unique_name=primary
5.查看主库是否归档模式
archive log list
6.关闭主库
shutdown immediate
7.创建备库控制文件
startup mount
alter database create standby controlfile as '/oradata/LCC/standby.ctl';
alter database open
8.关闭主库
shutdown immediate
备库操作
1.拷贝主库oradata/LCC文件到备库相应位置
2.拷贝主库admin下文件到备库相应的位置
3.拷贝主库生成的pfile和口令文件到相应的位置
4.修改standby.ctl文件为control01.ctl,control02.ctl,control03.ctl文件
5.修改pfile文件
log_archive_dest_1='LOCATION=/u010g/oradata/archive'
log_archive_dest_state_1=enable
log_archive_dest_2='SERVICE=primary'
log_archive_dest_state_2=enable
log_archive_format='%t_%s_%r.arc'
log_archive_max_processes=2
fal_server=primary
fal_client=standby
db_unique_name=standby
6.启动主库
create spfile from pfile
startup
7.查看网络监听是否启动
lsnrctl status
conn bms/bms@primary
8.启动备库到nomout
create spfile from pfile
startup nomount
9.修改备库到备库状态
alter database mount standby database;
10.查看
select name,database_role from v$database;
11.在主库查询
select name,database_role from v$database;
第三步:验证
备库操作
1.设置备库接受数据状态
alter database recover managed standby database disconnect from session
2.在主库中执行
alter system switch logfile;
3.在主库创建表
create table t(id int,name varchar2(20));
insert into t values(1,'zhangsan');
insert into t values(2,'lisi');
commit;
alter system switch logfile;
4.在备库执行
select sequence#,first_time,next_time from v$archived_log order by sequence#;
select sequence#,applied from v$archived_log order by sequence#;
5.在备库执行,打开备库查看数据模式
alter database recover managed standby database cancel;
alter database open read only;
6.切换到接受状态
alter database recover managed standby database disconnect from session