设为首页 加入收藏

TOP

使用dataguard将单实例数据库转换为rac数据库(五)
2015-11-21 01:51:26 来源: 作者: 【 】 浏览:1
Tags:使用 dataguard 实例 数据库 转换 rac
ogfile thread 2 group 10 ('+DATADG/suq/datafile/redo10.log') size 50m; Database altered. SQL> create undo tablespace undotbs2 datafile '+DATADG/suq/datafile/undotbs02.dbf' size 20m; Tablespace created. SQL> alter database enable public thread 2; Database altered. SQL> @?/rdbms/admin/catclust.sql Package created. Package body created. PL/SQL procedure successfully completed. View created. Synonym created. Grant succeeded. View created. Grant succeeded. Synonym created. View created. Grant succeeded. Synonym created. View created. Grant succeeded. Synonym created. View created. Grant succeeded. Synonym created. View created. Grant succeeded. Synonym created. View created. Grant succeeded. Synonym created. View created. Grant succeeded. Synonym created. View created. Grant succeeded. View created. Grant succeeded. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. View created. Grant succeeded. Synonym created. View created. Grant succeeded. Synonym created. PL/SQL procedure successfully completed.

?

节点2打开数据库,测试数据库是否正常:

?

[oracle@suq2 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Mon Jul 27 09:54:00 2015

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area  835104768 bytes
Fixed Size		    2257840 bytes
Variable Size		  553651280 bytes
Database Buffers	  272629760 bytes
Redo Buffers		    6565888 bytes
Database mounted.
Database opened.
SQL> 

SQL> select * from v$active_instances;

INST_NUMBER INST_NAME
----------- --------------------------------------------------
	  1 suq1:suq1


	  2 suq2:suq2
	  
SQL> select * from v$Log;

    GROUP#    THREAD#  SEQUENCE#      BYTES  BLOCKSIZE	  MEMBERS ARC STATUS	       FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME
---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- --------- ------------ ---------
	 1	    1	      35   52428800	   512		1 NO  CURRENT		      288331 27-JUL-15	 2.8147E+14
	 2	    1	      33   52428800	   512		1 YES INACTIVE		      281944 27-JUL-15	     282047 27-JUL-15
	 3	    1	      34   52428800	   512		1 YES ACTIVE		      282047 27-JUL-15	     288331 27-JUL-15
	 8	    2	       4   52428800	   512		1 NO  CURRENT		      288227 27-JUL-15	 2.8147E+14
	 9	    2	       2   52428800	   512		1 YES INACTIVE		      286810 27-JUL-15	     286815 27-JUL-15
	10	    2	       3   52428800	   512		1 YES ACTIVE		      286815 27-JUL-15	     288227 27-JUL-15

8.此时的数据库是可以正常打开使用了,一般还需将参数文件写到asm中,而且此时的数据库都是本地管理,并没有注册到grid中,还需要手工注册:

?

?

[grid@suq1 admin]$ srvctl config database
[grid@suq1 admin]$ 
[grid@suq1 admin]$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS       
--------------------------------------------------------------------------------
Local Resources
---------------------------------
首页 上一页 2 3 4 5 6 下一页 尾页 5/6/6
】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
分享到: 
上一篇oracle获取某时间段内的年份、月.. 下一篇oracle10g不支持continue解决方法

评论

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