设为首页 加入收藏

TOP

使用dataguard将单实例数据库转换为rac数据库(四)
2015-11-21 01:51:26 来源: 作者: 【 】 浏览:6
Tags:使用 dataguard 实例 数据库 转换 rac
dbf output file name=+DATADG/suq/datafile/system01.dbf tag=TAG20150726T222829 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:45 channel ORA_DISK_1: starting datafile copy input datafile file number=00002 name=/opt/oracle/oradata/suq/sysaux01.dbf output file name=+DATADG/suq/datafile/sysaux01.dbf tag=TAG20150726T222829 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:45 channel ORA_DISK_1: starting datafile copy input datafile file number=00003 name=/opt/oracle/oradata/suq/undotbs01.dbf output file name=+DATADG/suq/datafile/undotbs01.dbf tag=TAG20150726T222829 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15 channel ORA_DISK_1: starting datafile copy input datafile file number=00004 name=/opt/oracle/oradata/suq/users01.dbf output file name=+DATADG/suq/datafile/users01.dbf tag=TAG20150726T222829 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01 Finished backup at 26-JUL-15 sql statement: alter system archive log current contents of Memory Script: { switch clone datafile all; } executing Memory Script datafile 1 switched to datafile copy input datafile copy RECID=3 STAMP=886113015 file name=+DATADG/suq/datafile/system01.dbf datafile 2 switched to datafile copy input datafile copy RECID=4 STAMP=886113015 file name=+DATADG/suq/datafile/sysaux01.dbf datafile 3 switched to datafile copy input datafile copy RECID=5 STAMP=886113015 file name=+DATADG/suq/datafile/undotbs01.dbf datafile 4 switched to datafile copy input datafile copy RECID=6 STAMP=886113015 file name=+DATADG/suq/datafile/users01.dbf Finished Duplicate Db at 26-JUL-15 RMAN> exit Recovery Manager complete.
6.standby开启实时应用:

?

?

SQL> alter database recover managed standby database disconnect from session;

SQL> alter database recover managed standby database cancel;

SQL> alter database open read only;

Database altered.

SQL> alter database recover managed standby database using current logfile disconnect from session;

Database altered.

注意:我在做到这一步的时候一开始发现主库怎么也不向备库发送归档文件,也没有任何报错信息,搞了很长时间,后来将log_archive_dest_state_2重新设置为enable后就正常了。

?

7.switch over,将备库转换为主库,分别在主库我备库进行角色转换:

?

主库:

SQL> SELECT SWITCHOVER_STATUS FROM V$DATABASE;

SWITCHOVER_STATUS
--------------------
SESSIONS ACTIVE

注:当SWITCHOVER_STATUS的值为TO STANDBY or SESSIONS ACTIVE的时候表示主库可以支持SWITCHOVER.

SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION SHUTDOWN;

Database altered.



备库:

SQL> SELECT SWITCHOVER_STATUS FROM V$DATABASE;

SWITCHOVER_STATUS
--------------------
SESSIONS ACTIVE

注:只有SWITCHOVER_STATUS的值为TO PRIMARY or SESSIONS ACTIVE的状态时,表示备库当前支持switch over操作。

SQL>  ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY with session shutdown;

Database altered.

SQL> select status from v$instance;

STATUS
------------
MOUNTED

SQL> alter database open;

Database altered.


?

8.到这一步,rac的一个节点已经可以正常打开数据库了,但是节点2需要的redo,undo表空间都还没有,需要手工创建:

?

SQL> alter database add logfile thread 2 group 8 ('+DATADG/suq/datafile/redo08.log') size 50m;

Database altered.

SQL> alter database add logfile thread 2 group 9 ('+DATADG/suq/datafile/redo09.log') size 50m;

Database altered.

SQL> alter database add l
首页 上一页 1 2 3 4 5 6 下一页 尾页 4/6/6
】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
分享到: 
上一篇oracle获取某时间段内的年份、月.. 下一篇oracle10g不支持continue解决方法

评论

帐  号: 密码: (新用户注册)
验 证 码:
表  情:
内  容: