oracle 11g rac+单实例数据库构建dataguard
一、数据库及操作系统初始环境：
准备已经安装完毕可以正常运行的rac数据库，以及一台安装完oracle软件未创建数据库的。
rac和单实例安装可以参考链接：
其中rac做为dg的主库。
1.我的规划配置如下：rac 节点1：-ipip
如下：
[grid@bysrac1 ~]$ cat /etc/hosts
127.0.0.1 localhost.localdomain localhost
::1 localhost6.localdomain6localhost6
[oracle@racdg ~]$ cat .bash_profile
oracle_base=/u01
oracle_home=/u01/app/oracle/product/11.2.0/dbhome_1
oracle_sid=racdg
path=$oracle_home/bin:$oracle_home/opatch:$path:$home/bin
export path oracle_base oracle_home oracle_sid
alias sqlplus='rlwrap sqlplus'
alias rman='rlwrap rman'
2.rac数据库中各文件位置--恢复到备库时转化文件名字用sys@bysrac1>archive log list
database log mode archive mode
automatic archival enabled
archive destination +bysasmdata
oldest online log sequence 156
next log sequence to archive 157
current log sequence 157
sys@bysrac1>show parameter recovery
name type value
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string +bysasmdg
db_recovery_file_dest_size big integer 4977m
recovery_parallelism integer 0
sys@bysrac1>select db_unique_name,name from v$database;
db_unique_name name
------------------------------ ---------
bysrac bysrac
sys@bysrac1>select name from v$datafile;
name
----------------------------------------------------------------------------------------------------
+bysasmdata/bysrac/datafile/system.259.818615175
+bysasmdata/bysrac/datafile/sysaux.260.818615237
+bysasmdata/bysrac/datafile/undotbs1.261.818615291
+bysasmdata/bysrac/datafile/undotbs2.263.818615365
+bysasmdata/bysrac/datafile/users.264.818615419
+bysasmdata/bysrac/datafile/test1_undo.dbf
+bysasmdata/bysrac/datafile/test1.dbf
bys@bysrac1>selectname,block_size*file_size_blks/1024/1024 as bytes_m from v$controlfile;
name bytes_m
-------------------------------------------------- ----------
+bysasmdata/bysrac/controlfile/current.256.8186151 17.6875
19
+bysasmdg/bysrac/controlfile/current.256.818615127 17.6875
bys@bysrac1>select group#,member from v$logfile;
group# member
---------- --------------------------------------------------
1+bysasmdata/bysrac/onlinelog/group_1.257.818615137
1+bysasmdg/bysrac/onlinelog/group_1.257.818615145
2+bysasmdata/bysrac/onlinelog/group_2.258.818615153
2+bysasmdg/bysrac/onlinelog/group_2.258.818615163
3+bysasmdata/bysrac/onlinelog/group_3.265.818619941
3+bysasmdg/bysrac/onlinelog/group_3.259.818619949
4+bysasmdata/bysrac/onlinelog/group_4.266.818619961
4+bysasmdg/bysrac/onlinelog/group_4.260.818619967
二、修改rac中初始化参数3.在rac主库中修改初始化参数sql> alter system set standby_file_management=auto scope=spfile;
sql> alter system set log_archive_config=dg_config=(bysrac,racdg)scope=spfile;
sql> alter system set log_archive_dest_2=service=racdg lgwrsync valid_for=(online_logfiles,primary_role)db_unique_name=racdg scope=spfile;
sql> alter system set fal_server=racdg scope=spfile;
sql> alter system set fal_client=bysrac;
sql> alter system setdb_file_name_convert=+bysasmdata/bysrac/datafile/,/u01/oradata/racdg,'+bysasmdata/bysrac/tempfile/','/u01/oradata/racdg/' scope=spfile;
sql> alter system set log_file_name_convert=+bysasmdata/bysrac/onlinelog/,/u01/oradata/racdg，'+bysasmdg/bysrac/onlinelog/','/u01/oradata/racdg/' scope=spfile;
推荐阅读：
使用rman的duplicate功能创建物理dataguard
oracle基础教程之通过rman复制数据库
rman备份策略制定参考内容
rman备份学习笔记
oracle数据库备份加密 rman加密
通过rman备份duplicate创建dataguard
本文的更多详情请继续阅读第2页的精彩内容：
，