又试着在vmware+linux里面装一遍RAC了,希望可以得到更多的理解,通过对照《大话RAC》.
SQL> set line 120
SQL> set pages 1000
SQL> col host_name for a15
SQL> l
1* select INSTANCE_NAME,HOST_NAME,STATUS from gv$instance
SQL> /
INSTANCE_NAME HOST_NAME STATUS
---------------- --------------- ------------
rac2 rac1 OPEN
rac1 rac2 OPEN
SQL> col file_name for a50
SQL> l
1* select file_name,TABLESPACE_NAME from dba_data_files
SQL> /
FILE_NAME TABLESPACE_NAME
-------------------------------------------------- ------------------------------
+DGDATA/rac/datafile/users.259.693480261 USERS
+DGDATA/rac/datafile/sysaux.257.693480259 SYSAUX
+DGDATA/rac/datafile/undotbs1.258.693480261 UNDOTBS1
+DGDATA/rac/datafile/system.256.693480255 SYSTEM
+DGDATA/rac/datafile/example.264.693480491 EXAMPLE
+DGDATA/rac/datafile/undotbs2.265.693480991 UNDOTBS2
6 rows selected.
SQL>
|
阅读(589) | 评论(0) | 转发(0) |