本文主要记录了创建物理备库的完整过程,以便实践中参考.耐于机器配置,此实验实现的是在本机上建立两个数据库test和std_assg,test
本文主要记录了创建物理备库的完整过程,以便实践中参考.耐于机器配置,此实验实现的是在本机上建立两个数据库test和std_assg,test是主库，，std_assg 是备库，最后实现主库发生日志切换后，全部应用于物理备库
--------------------------------------分割线 --------------------------------------
相关参考:
oracle data guard 重要配置参数
基于同一主机配置 oracle 11g data guard
探索oracle之11g dataguard
oracle data guard （rac+dg) 归档删除策略及脚本
oracle data guard 的角色转换
oracle data guard的日志fal gap问题
oracle 11g data guard error 16143 heartbeat failed to connect to standby 处理方法
--------------------------------------分割线 --------------------------------------
一 创建物理备库需要的目录
[oracle@dbsv admin]$ cd std_assg/
[oracle@dbsv std_assg]$ ls
[oracle@dbsv std_assg]$ mkdir arch
[oracle@dbsv std_assg]$ mkdir adump
[oracle@dbsv std_assg]$ mkdir bdump
[oracle@dbsv std_assg]$ mkdir cdump
[oracle@dbsv std_assg]$ mkdir udump
[oracle@dbsv std_assg]$ mkdir flash
[oracle@dbsv std_assg]$ cd $oracle_base/oradata
[oracle@dbsv oradata]$ mkdir std_assg
二创建sys用户需要的密码文件
[oracle@dbsv dbs]$ ls orapw*
orapwdbakdb.pwd orapwdorcl orapworcl orapwstdby orapwtest
[oracle@dbsv dbs]$ cp orapwtest orapwstd_assg
三创建备库的日志文件
1 启动已有主库
[oracle@dbsv ~]$ export oracle_sid=test
[oracle@dbsv ~]$ sqlplus / as sysdba
2查看备库日志情况
sql> select group#,thread#,sequence#,archived,status from v$standby_log;
group# thread# sequence# arc status
---------- ---------- ---------- --- ----------
4 0 0 yes unassigned
5 0 0 yes unassigned
6 0 0 yes unassigned
3 建立备库日志
sql> alter database add standby logfile group 7 '/u01/app/oracle/oradata/std_assg/std.redo' size 50m;
database altered.
sql> alter database add standby logfile group 8 '/u01/app/oracle/oradata/std_assg/std2.redo' size 50m;
database altered.
sql> alter database add standby logfile group 9 '/u01/app/oracle/oradata/std_assg/std3.redo' size 50m;
database altered.
四修改初始化参数，配置物理备库需要的信息
vi inittest.ora
# for primary role
db_name=test
db_unique_name=test
log_archive_config='dg_config=(test,std_assg)'
#control_files='/u01/app/oracle/oradata/test/control1.ctl', '/u01/app/oracle/oradata/test/control2.ctl', '/u01/app/oracle/oradata/test/control3.ctl'
log_archive_dest_1=
'location=/u01/app/oracle/admin/test/arch/
valid_for=(all_logfiles,all_roles)
db_unique_name=test'
log_archive_dest_2=
'service=std_assg lgwr async
valid_for=(online_logfiles,primary_role)
db_unique_name=std_assg'
log_archive_dest_state_1=enable
log_archive_dest_state_2=enable
remote_login_passwordfile=exclusive
log_archive_format=%t_%s_%r.arc
log_archive_max_processes=30
# for standby role
fal_server=std_assg
fal_client=test
db_file_name_convert='/u01/app/oracle/oradata/std_assg/','/u01/app/oracle/oradata/test/'
log_file_name_convert=
'/u01/app/oracle/oradata/std_assg/','/u01/app/oracle/oradata/test/'
standby_file_management=auto
复制并修改主库参数文件，改为备库可用参数文件
1,$ s/test/std_assg/g
# for primary role
db_name=test
db_unique_name=std_assg
log_archive_config='dg_config=(std_assg,test)'
#control_files='/u01/app/oracle/oradata/std_assg/control1.ctl', '/u01/app/oracle/oradata/std_assg/control2.ctl', '/u01/app/oracle/oradata/std_assg/control3.ctl'
log_archive_dest_1=
'location=/u01/app/oracle/admin/std_assg/arch/
valid_for=(all_logfiles,all_roles)
db_unique_name=std_assg'
log_archive_dest_2=
'service=test lgwr async
valid_for=(online_logfiles,primary_role)
db_unique_name=test'
log_archive_dest_state_1=enable
log_archive_dest_state_2=enable
remote_login_passwordfile=exclusive
log_archive_format=%t_%s_%r.arc
log_archive_max_processes=30
# for standby role
fal_server=test
fal_client=std_assg
db_file_name_convert='/u01/app/oracle/oradata/test/','/u01/app/oracle/oradata/std_assg/'
log_file_name_convert=
'/u01/app/oracle/oradata/test/','/u01/app/oracle/oradata/std_assg/'
standby_file_management=auto
更多详情见请继续阅读下一页的精彩内容：