| 失效链接处理 |
|
Oracle数据库DGd切换 PDF 下蝲
本站整理下蝲Q?/strong>
链接Q?a target="_blank">https://pan.baidu.com/s/1Qnr-D4xvqbA9VwMKmxmWvg
提取码：(x)kdt6
相关截图Q?/strong>
主要内容Q?/strong>
1、主库操?/div>
1.1 关闭d监听
su - oracle
lsnrctl stopQ只在主库操作）(j)
1.2 在主库端(g)查数据库可切换状?/div>
sqlplus / as sysdba
SQL> select switchover_status from v$database;
如果SWITCHOVER_STATUS 的gؓ(f)TO STANDBY 表示可以正常切换.
SQL> alter database commit to switchover to physical standby;
Database altered.
切换成功Q?/div>
如果SWITCHOVER_STATUS 的gؓ(f)SESSIONS ACTIVE表示当前有会(x)话处于ACTIVE状态：(x)
SQL> alter database commit to switchover to physical standby with session shutdown;
Database altered.
查看日志Q?/div>
tail -f $ORACLE_BASE/admin/$ORACLE_SID/bdump/alert_$ORACLE_SID.log
1.3 重启d
SQL> shutdown abort;
SQL> startup mount;
2、备库操?/div>
2.1q时候到备䆾?在备库验证可切换状?/div>
sqlplu / as sysdba
SQL> select switchover_status from v$database;
到备库验证可切换状态SWITCHOVER_STATUS
2.2.目标备库{换ؓ(f)d
如果SWITCHOVER_STATUS 的gؓ(f)TO PRIMARY ?
SQL> alter database commit to switchover to primary;
Database altered.
如果SWITCHOVER_STATUS 的gؓ(f)SESSIONS ACTIVE ?
SQL> alter database commit to switchover to primary with session shutdown;
Database altered.
查询temp文g是否同步q来Q主库创Z(f)时表I间Q备库自动创Z(f)时文Ӟ但无临时文gQ需手工d?/div>
SQL> select FILE_NAME,TABLESPACE_NAME,status from dba_temp_files;
查看日志Q?/div>
tail -f $ORACLE_BASE/admin/$ORACLE_SID/bdump/alert_$ORACLE_SID.log
2.3 打开目标备库
SQL> alter database open;
2.4 开始在目标备库应用日志
SQL> alter database recover managed standby database disconnect;
开启备库的实时日志应用Q?/div>
SQL> alter database recover managed standby database using current logfile disconnect from session;
(g)查主备库角色状态：(x)
SQL> select switchover_status,database_role from v$database;
3、修Ҏ(gu)备库ipQ原dQ?/div>
ping 10.100.0.201
修改IP地址
sed -i 's/10.100.0.9/10.100.0.201/g' /etc/sysconfig/network-scripts/ifcfg-bond0
cat /etc/sysconfig/network-scripts/ifcfg-bond0
|
| Java1234官方?5Q?/td> | 
|
| Java1234官方?5Q?/td> | 838462530 |
苏公|安?32061202001004?/p>
