;  YES OPEN         ACTIVE            NORMAL    vzwc2 
SQL> SELECT
  2      inst_id
  , instance_number inst_no
  , instance_name inst_name
  , parallel
  6    , status
  7    , database_status db_status
  8    , active_state state
  9    , host_name host
 10  FROM gv$instance
 11  /

   INST_ID    INST_NO INST_NAME        PAR STATUS       DB_STATUS         STATE     HOST
---------- ---------- ---------------- --- ------------ ----------------- --------- ----------
         1          1 zwc1             YES OPEN         ACTIVE            NORMAL    vzwc1
         2          2 zwc2             YES OPEN         ACTIVE            NORMAL    vzwc2
磁盘组中的所有数据文件

 

[plain] view plaincopyprint?
01.SQL> select name from v$datafile 
02.  2  union 
03.  3  select member from v$logfile 
04.  4  union 
05.  5  select name from v$controlfile 
06.  6  union 
07.  7  select name from v$tempfile 
08.  8  / 
09. 
10.NAME 
11.-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 
12.+DATADG/zwc/controlfile/current.260.810684377 
13.+DATADG/zwc/datafile/example.264.810684397 
14.+DATADG/zwc/datafile/sysaux.257.810684333 
15.+DATADG/zwc/datafile/system.256.810684333 
16.+DATADG/zwc/datafile/undotbs1.258.810684333 
17.+DATADG/zwc/datafile/undotbs2.265.810684503 
18.+DATADG/zwc/datafile/users.259.810684333 
19.+DATADG/zwc/onlinelog/group_1.261.810684379 
20.+DATADG/zwc/onlinelog/group_2.262.810684383 
21.+DATADG/zwc/onlinelog/group_3.266.810684557 
22.+DATADG/zwc/onlinelog/group_4.267.810684559 
23.+DATADG/zwc/tempfile/temp.263.810684393 
24.+FLASHDG/zwc/controlfile/c

上一页  [1] [2] [3] [4] [5] [6] [7] 下一页