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
---------------------------------