,关于oracle rac部署请访问这里,http://worms.blog.51cto.com/969144/1416975
主要rac,主要
RACDG1 RACDG2
172.20.10公共IP。11
172.20.10。12
Virtual IP
10.0.0.11
10.0.0.12
Instance
racdg1
racdg2
DB name
RACDG
DATA file
+DATA2/racdg/datafile
Control file
+DATA2/racdg/controlfile
+DATA1/racdg/controlfile/
Redo Log file
+DATA2/racdg/onlinelog/
db_recovery_file_dest
db_unique_name
racdg
service_names
racdg
Oracle_Version
11.2.0.1.0
Standby
Single instance standby
IP
172.20.10.100
Oracle_version
11.2.0.1.0
Instance
racdg
DB name
RACDG
DB_unique_name
racdg_standy
service_names
racdg_standy
DATA file
/u01/oracle/racdg_standy/datafile/
Control file
/u01/app/oracle/controlfile1/
/u01/app/oracle/controlfile2/
Redo Log file
/u01/oracle/racdg_standy/onlinelog3/
/u01/oracle/racdg_standy/onlinelog/
结构图
1、
2、
1Force logging
SQL> 改变数据库迫使伐木;
数据库mountedopenenable迫使loggingall unlogged写I/O
从v $数据库;选择force_logging
2配置RedoTransport认证
数据警卫队usesOracle净会话之间运输重做数据和控制消息(数据保护配置。这些重新传输会话areauthenticated使用安全套接字层(SSL)协议或remotelogin密码文件。密码文件
rac 1 pwdfile
orapwdfile=/u01/app/oracle/产品/11.2.0/db_1/dbs/orapwracdg1密码=FANfan1234entries=10力=y
,,,orapwracdg12备用DB
scp $ ORACLE_HOME/dbs/orapwracdg1 oracle@racdg2: $ ORACLE_HOME/dbs/orapwracdg2
,,,scp $ ORACLE_HOME/dbs/orapwracdg1 oracle@racdg2: $ ORACLE_HOME/dbs/orapwracdg
3配置首要数据库接受重做数据
,,,,,,,,主要switchoverto备用db
4设置主要DatabaseInitialization参数
,
主数据库初始化参数
完成显示参数pfile
,
NAME ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,TYPE ,,,,,,值
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
spfile ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,string ,,,,+ DATA1/racdg spfileracdg.ora
完成
createpfile='/home/oracle/primary_pfile。pfile ' fromspfile=' + DATA1/racdg spfileracdg.ora”
,
异步
的
fal_serverfal_clientdb_unique_name
<强>主要DB spfile:
,
[grid@racdg1 ~] srvctl 美元;停止数据库- d racdg
,
[oracle@racdg1 ~] sqlplus/美元sysdba
,
SQL * +:释放11.2.0.1.0生产alt="部署物理Dataguard与双节点Oracle RAC环境">
,,
2, switchover_status
<强> PrimaryDB
完成选择切换#、SWITCHOVER_STATUS DATABASE_ROLE fromv $数据库;
,
切换#,,SWITCHOVER_STATUS ,,DATABASE_ROLE
- - - - - - - - - - - - - - - - - -,,- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
, 1110966030,,,,, STANDBY ,,,,,,,,,null
部署物理Dataguard与双节点Oracle RAC环境
