Oracle 10g RAC 的部署5

 

 

10  RAC环境

 

(1) 检查应用程序资源的状态。

csr_stat  -t命令

 

srvctl status nodeapps –n命令

 

srvctl status asm –n 命令

 

 

(2) 检查 Oracle 集群件的状态。

 

 

(3) 列出 RAC 实例

SQL> select

  2  instance_name,

  3  host_name,

  4  archiver,

  5  thread#,

  6  status

  7  from gv$instance;

 

INSTANCE_NAME  HOST_NAME             ARCHIVE  THREAD# STATUS

-------------- --------------------- ------- -------- ------

gemni         ds1.mycorpdomain.com STARTED        1 OPEN

gemni         ds2.mycorpdomain.com STARTED        2 OPEN

 

(4) 检查连接

验证您能够连接到每个节点上的实例和服务。

 

(5)   检查数据库配置

 

SQL> select

  2  name,

  3  path,

  4  header_status,

  5  total_mb free_mb,

  6  trunc(bytes_read/1024/1024) read_mb,

  7  trunc(bytes_written/1024/1024) write_mb

  8  from v$asm_disk;

 

NAME  PATH       HEADER_STATU    FREE_MB    READ_MB   WRITE_MB

----- ---------- ------------ ---------- ---------- ----------

VOL1  ORCL:VOL1  MEMBER             3067        229       1242

VOL2  ORCL:VOL2  MEMBER             3067        164       1242

VOL3  ORCL:VOL3  MEMBER             2047         11        354

 

(6) 创建表空间。

 

SQL> connect system/oracle@gemni

Connected.

SQL> create tablespace test_d datafile '+DG1' size 10M;

Tablespace created.

 

SQL> select

  2  file_name,

  3  tablespace_name,

  4  bytes

  5  from dba_data_files

  6  where tablespace_name='TEST_D';

 

FILE_NAME                                TABLESPACE_NAME      BYTES

---------------------------------------- --------------- ----------

+DG1/devdb/datafile/test_d.269.606473423 TEST_D            10485760

 

(7) 创建在线重做日志文件组。

 

SQL> connect system/oracle@gemni

Connected.

SQL> alter database add logfile thread 1 group 5 size 50M;

Database altered.

SQL> alter database add logfile thread 2 group 6 size 50M;

 

Database altered.

SQL> select

  2  group#,

  3  thread#,

  4  bytes,

  5  members,

  6  status

  7  from v$log;

 

    GROUP#    THREAD#      BYTES    MEMBERS STATUS

---------- ---------- ---------- ---------- ----------------

    1          1          52428800          2 CURRENT

    2          1          52428800          2 INACTIVE

   3          2          52428800          2 ACTIVE

    4          2          52428800          2 CURRENT

    5          1          52428800          2 UNUSED

    6          2          52428800          2 UNUSED

 

SQL> select

  2  group#,

  3  type,

  4  member,

  5  is_recovery_dest_file

  6  from v$logfile

7  where group# in (5,6)

  8  order by group#;

 

GROUP# TYPE    MEMBER                                               IS_

------ ------- ---------------------------------------------------- ---

     5 ONLINE  +DG1/devdb/onlinelog/group_5.271.606473683           NO

     5 ONLINE  +RECOVERYDEST/devdb/onlinelog/group_5.261.606473691  YES

     6 ONLINE  +DG1/devdb/onlinelog/group_6.272.606473697           NO

     6 ONLINE  +RECOVERYDEST/devdb/onlinelog/group_6.262.606473703  YES

 

(8) 检查闪回恢复区空间使用率。

 

SQL> select * from v$recovery_file_dest;

NAME          SPACE_LIMIT SPACE_USED SPACE_RECLAIMABLE NUMBER_OF_FILES

------------- ----------- ---------- ----------------- ---------------

+RECOVERYDEST  1572864000  331366400                 0               7

 

SQL> select * from v$flash_recovery_area_usage;

FILE_TYPE    PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES

------------ ------------------ ------------------------- ---------------

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/551823/viewspace-371954/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/551823/viewspace-371954/