开启辅助访问

Bo's Oracle Station

Bo's Oracle Station»社区 › 培训进行时（结课后图标变灰，但是欢迎继续发帖！） › 10002-11g管理类OCM认证班第一期 › Section7
返回列表 发新帖
查看: 2248|回复: 0

Section7

[复制链接]
admin

75

主题

115

帖子

2772

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
2772
发表于 2015-10-10 10:43:35 | 显示全部楼层 |阅读模式
我的输出：


----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
******************** Section7 ********************
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------


******************** TOPIC 1 ********************
/dev/raw/raw1:    bound to major 8, minor 1
/dev/raw/raw2:    bound to major 8, minor 2
/dev/raw/raw3:    bound to major 8, minor 3
/dev/raw/raw5:    bound to major 8, minor 5
/dev/raw/raw6:    bound to major 8, minor 6
/dev/raw/raw7:    bound to major 8, minor 7
/dev/raw/raw8:    bound to major 8, minor 8
raw devices OK
Status of Oracle Cluster Registry is as follows :
     Version                  :          2
     Total space (kbytes)     :    1003976
     Used space (kbytes)      :       4556
     Available space (kbytes) :     999420
     ID                       :  139970712
     Device/File Name         : /dev/raw/raw2
                                    Device/File integrity check succeeded

                                    Device/File not configured

     Cluster registry integrity check succeeded



R100001=0.66


A:      Device/File Name         : /dev/raw/raw2
0.     0    /dev/raw/raw3

located 1 votedisk(s).


R100002=0.66


A:  0.     0    /dev/raw/raw3


******************** TOPIC 2 ********************
bin
cdata
cfgtoollogs
clone
crs
css
cv
diagnostics
evm
has
install
install.platform
inventory
jdk
jlib
jre
JRE
ldap
lib
log
network
nls
OPatch
opmn
oracore
oraInst.loc
oui
perl
plsql
precomp
racg
rdbms
relnotes
root.sh
slax
sqlplus
srvm
xdk


R200000=0.1


A: crs


R200000=.66


B: ACTION_SCRIPT=/u01/crs_1/bin/racgwrap
ACTION_SCRIPT=/u01/crs_1/bin/racgwrap
ACTION_SCRIPT=/u01/crs_1/bin/racgwrap
ACTION_SCRIPT=/u01/crs_1/bin/racgwrap
ACTION_SCRIPT=/u01/crs_1/bin/racgwrap
ACTION_SCRIPT=/u01/crs_1/bin/racgwrap
ACTION_SCRIPT=/u01/crs_1/bin/racgwrap


******************** TOPIC 3 ********************
assistants
bin
cdata
cfgtoollogs
clone
config
crs
css
ctx
dbs
demo
diagnostics
has
hs
install
install.platform
inventory
javavm
jdbc
jdk
jlib
jre
ldap
lib
log
md
mesg
mgw
network
nls
oc4j
odbc
olap
OPatch
opmn
oracore
oraInst.loc
ord
oui
owm
perl
plsql
precomp
racg
rdbms
relnotes
root.sh
root.sh.old
slax
sqlj
sqlnet.log
sqlplus
srvm
station37_racdb1
station38_racdb2
sysman
uix
wwg
xdk


R300000=0.66


A: sqlplus


******************** TOPIC 4 ********************
Name           Type           Target    State     Host        
------------------------------------------------------------
ora.racdb.db   application    ONLINE    ONLINE    station38   
ora....b1.inst application    ONLINE    ONLINE    station37   
ora....b2.inst application    ONLINE    ONLINE    station38   
ora....serv.cs application    ONLINE    ONLINE    station37   
ora....db1.srv application    ONLINE    ONLINE    station37   
ora....db2.srv application    ONLINE    ONLINE    station38   
ora....SM1.asm application    ONLINE    ONLINE    station37   
ora....37.lsnr application    ONLINE    ONLINE    station37   
ora....n37.gsd application    ONLINE    ONLINE    station37   
ora....n37.ons application    ONLINE    ONLINE    station37   
ora....n37.vip application    ONLINE    ONLINE    station37   
ora....SM2.asm application    ONLINE    ONLINE    station38   
ora....38.lsnr application    ONLINE    ONLINE    station38   
ora....n38.gsd application    ONLINE    ONLINE    station38   
ora....n38.ons application    ONLINE    ONLINE    station38   
ora....n38.vip application    ONLINE    ONLINE    station38   


R400000=0.03


A: ora.racdb.db   application    ONLINE    ONLINE    station38   


R400000=.06


B: ora....b1.inst application    ONLINE    ONLINE    station37   


R400000=.10


C: ora....b2.inst application    ONLINE    ONLINE    station38   
ASM
/u01/db_1

SQL*Plus: Release 10.2.0.1.0 - Production on Sun Sep 13 16:28:24 2015

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


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

SQL> SQL>
  COUNT(*)
----------
     2

SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options


R400000=.11


D: 2
ASM
/u01/db_1

SQL*Plus: Release 10.2.0.1.0 - Production on Sun Sep 13 16:28:24 2015

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


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

SQL> SQL>
  COUNT(*)
----------
     2

SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options


R400000=.12


E: 2
ASM
/u01/db_1

SQL*Plus: Release 10.2.0.1.0 - Production on Sun Sep 13 16:28:25 2015

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


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

SQL> SQL>
COUNT(TYPE)
-----------
      2

SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options


R400000=.13


F: 2
R400000=0.5


******************** TOPIC 5 ********************
DATABASE

SQL*Plus: Release 10.2.0.1.0 - Production on Sun Sep 13 16:28:25 2015

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


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

SQL> SQL>
NAME                     TYPE     VALUE
------------------------------------ ----------- ------------------------------
db_name                  string     racdb
SQL>
NAME                     TYPE     VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest             string     +RECOVERDG
db_recovery_file_dest_size         big integer 4G
SQL>
OPEN_MODE
----------
READ WRITE

SQL>
NAME
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+DATADG/racdb/datafile/system.256.890322567
+DATADG/racdb/datafile/undotbs1.258.890322567
+DATADG/racdb/datafile/sysaux.257.890322567
+DATADG/racdb/datafile/users.259.890322567
+DATADG/racdb/datafile/undotbs2.264.890322767

SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options


R500001=0.1


A: db_name                  string     racdb
+DATADG/racdb/datafile/system.256.890322567
+DATADG/racdb/datafile/undotbs1.258.890322567
+DATADG/racdb/datafile/sysaux.257.890322567
+DATADG/racdb/datafile/users.259.890322567
+DATADG/racdb/datafile/undotbs2.264.890322767

SQL*Plus: Release 10.2.0.1.0 - Production on Sun Sep 13 16:28:25 2015

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


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

SQL> SQL>
NAME                     TYPE     VALUE
------------------------------------ ----------- ------------------------------
db_name                  string     racdb
SQL>
NAME                     TYPE     VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest             string     +RECOVERDG
db_recovery_file_dest_size         big integer 4G
SQL>
OPEN_MODE
----------
READ WRITE

SQL>
NAME
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+DATADG/racdb/datafile/system.256.890322567
+DATADG/racdb/datafile/undotbs1.258.890322567
+DATADG/racdb/datafile/sysaux.257.890322567
+DATADG/racdb/datafile/users.259.890322567
+DATADG/racdb/datafile/undotbs2.264.890322767

SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options


R500001=.2


B: READ WRITE

SQL*Plus: Release 10.2.0.1.0 - Production on Sun Sep 13 16:28:25 2015

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


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

SQL> SQL>
NAME                     TYPE     VALUE
------------------------------------ ----------- ------------------------------
db_name                  string     racdb
SQL>
NAME                     TYPE     VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest             string     +RECOVERDG
db_recovery_file_dest_size         big integer 4G
SQL>
OPEN_MODE
----------
READ WRITE

SQL>
NAME
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+DATADG/racdb/datafile/system.256.890322567
+DATADG/racdb/datafile/undotbs1.258.890322567
+DATADG/racdb/datafile/sysaux.257.890322567
+DATADG/racdb/datafile/users.259.890322567
+DATADG/racdb/datafile/undotbs2.264.890322767

SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options


R500001=.4


C: db_recovery_file_dest             string     +RECOVERDG
db_recovery_file_dest: db_recovery_file_dest             string     +RECOVERDG

SQL*Plus: Release 10.2.0.1.0 - Production on Sun Sep 13 16:28:25 2015

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


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

SQL> SQL>
NAME                     TYPE     VALUE
------------------------------------ ----------- ------------------------------
db_name                  string     racdb
SQL>
NAME                     TYPE     VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest             string     +RECOVERDG
db_recovery_file_dest_size         big integer 4G
SQL>
OPEN_MODE
----------
READ WRITE

SQL>
NAME
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+DATADG/racdb/datafile/system.256.890322567
+DATADG/racdb/datafile/undotbs1.258.890322567
+DATADG/racdb/datafile/sysaux.257.890322567
+DATADG/racdb/datafile/users.259.890322567
+DATADG/racdb/datafile/undotbs2.264.890322767

SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options


R500001=.5


D: 0
OTHER Diskgroup: 0
INSTANCE1

SQL*Plus: Release 10.2.0.1.0 - Production on Sun Sep 13 16:28:26 2015

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


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

SQL> SQL>
NAME                     TYPE     VALUE
------------------------------------ ----------- ------------------------------
instance_name                 string     racdb1
SQL>
OPEN_MODE
----------
READ WRITE

SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options


R500002=0.2


A: instance_name                 string     racdb1

SQL*Plus: Release 10.2.0.1.0 - Production on Sun Sep 13 16:28:26 2015

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


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

SQL> SQL>
NAME                     TYPE     VALUE
------------------------------------ ----------- ------------------------------
instance_name                 string     racdb1
SQL>
OPEN_MODE
----------
READ WRITE

SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options


R500002=.5


B: READ WRITE
INSTANCE2

SQL*Plus: Release 10.2.0.1.0 - Production on Sun Sep 13 16:28:27 2015

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


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

SQL> SQL>
NAME                     TYPE     VALUE
------------------------------------ ----------- ------------------------------
instance_name                 string     racdb2
SQL>
OPEN_MODE
----------
READ WRITE

SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options


R500003=0.2


A: instance_name                 string     racdb2

SQL*Plus: Release 10.2.0.1.0 - Production on Sun Sep 13 16:28:27 2015

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


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

SQL> SQL>
NAME                     TYPE     VALUE
------------------------------------ ----------- ------------------------------
instance_name                 string     racdb2
SQL>
OPEN_MODE
----------
READ WRITE

SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options


R500003=.5


B: READ WRITE


******************** TOPIC 6 ********************
DATABASE

SQL*Plus: Release 10.2.0.1.0 - Production on Sun Sep 13 16:28:27 2015

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


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

SQL> SQL>
LOG_MODE
------------
ARCHIVELOG

SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options


R600000=0.5


A: ARCHIVELOG


******************** TOPIC 7 ********************
ora....serv.cs application    ONLINE    ONLINE    station37   
ora....db1.srv application    ONLINE    ONLINE    station37   
ora....db2.srv application    ONLINE    ONLINE    station38   


R700001=0.33


A: 2


R700002=0.33


A: 2


R700003=0.34


A: 2
DATABASE

SQL*Plus: Release 10.2.0.1.0 - Production on Sun Sep 13 16:28:29 2015

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


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

SQL> SQL> SQL> SQL> SQL>
NAME             FAILOVER_METHOD      FAILOVER_TYPE        FAILOVER_RETRIES FAILOVER_DELAY
-------------------- -------------------- -------------------- ---------------- --------------
racdb_serv         BASIC          SELECT                180          1

SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options


R700004=0.35


A: racdb_serv         BASIC          SELECT                180          1
SERVICE

SQL*Plus: Release 10.2.0.1.0 - Production on Sun Sep 13 16:28:30 2015

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


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

SQL> SQL> SQL> SQL> SQL>
NAME             FAILOVER_METHOD      FAILOVER_TYPE        FAILOVER_RETRIES FAILOVER_DELAY
-------------------- -------------------- -------------------- ---------------- --------------
racdb_serv         BASIC          SELECT                180          1

SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options


R700004=.50


B: racdb_serv         BASIC          SELECT                180          1


******************** TOPIC 8 ********************
DATABASE.ASM.station37.+asm1.
DATABASE.ASM.station37.+asm1.
DATABASE.ASM.station38.+asm2.
DATABASE.ASM.station38.+asm2.
DATABASE.ASM.station38.+asm2.
DATABASE.ASM.station38.+asm2.
DATABASE.ASM.station38.+asm2.
DATABASE.ASM.station38.+asm2.
DATABASE.DATABASES.racdb.INST
DATABASE.DATABASES.racdb.INST
SYSTEM.css.interfaces.global.
SYSTEM.css.interfaces.global.
DATABASE.DATABASES.racdb.INST
DATABASE.DATABASES.racdb.INST
DATABASE.DATABASES.racdb.INST
DATABASE.DATABASES.racdb.INST
DATABASE.DATABASES.racdb.INST
DATABASE.DATABASES.racdb.INST
SYSTEM.css.interfaces.global.
SYSTEM.css.interfaces.global.
XXXXXXXXXXXX


R800000=0.36


A: XXXXXXXXXXXX


******************** TOPIC 9 ********************
DATABASE

SQL*Plus: Release 10.2.0.1.0 - Production on Sun Sep 13 16:28:30 2015

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


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

SQL> SQL>
SEQUENCE_OWNER               SEQUENCE_NAME               MIN_VALUE  MAX_VALUE INCREMENT_BY C O CACHE_SIZE LAST_NUMBER
------------------------------ ------------------------------ ---------- ---------- ------------ - - ---------- -----------
SYSTEM                   SEQ1                       1      99999           1 N Y         20     120

SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options


R900001=0.3


A: SYSTEM                   SEQ1                       1      99999           1 N Y         20     120
INSTANCE1

SQL*Plus: Release 10.2.0.1.0 - Production on Sun Sep 13 16:28:31 2015

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


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

SQL> SQL>
   NEXTVAL
----------
       102

SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
INSTANCE2

SQL*Plus: Release 10.2.0.1.0 - Production on Sun Sep 13 16:28:31 2015

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


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

SQL> SQL>
   NEXTVAL
----------
       103

SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
A: 102
B: 103
C: 1


R900002=0.2




******************** TOPIC 10 ********************
NULL
*****************************************************************************************************


R100001: 0.66 full is 0.66 0.66
R100002: 0.66 full is 0.66 1.32
R200000: .66 full is 0.66 1.98
R300000: 0.66 full is 0.66 2.64
R400000: 0.5 full is 0.5 3.14
R500001: .5 full is 0.5 3.64
R500002: .5 full is 0.5 4.14
R500003: .5 full is 0.5 4.64
R600000: 0.5 full is 0.5 5.14
R700001: 0.33 full is 0.33 5.47
R700002: 0.33 full is 0.33 5.8
R700003: 0.34 full is 0.34 6.14
R700004: .50 full is 0.5 6.64
R800000: 0.36 full is 0.36 7
R900001: 0.3 full is 0.3 7.3
R900002: 0.2 full is 0.2 7.5
full of this section:
RESULT:
7.50


*****************************************************************************************************

Section7.zip

11.8 KB, 下载次数: 813
回复

使用道具 举报

返回列表 发新帖
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|手机版|Bo's Oracle Station   

GMT+8, 2024-12-5 10:26 , Processed in 0.040222 second(s), 27 queries .

快速回复 返回顶部 返回列表