WEB开发网
开发学院数据库Oracle Oracle 10g RAC 的部署(2) 阅读

Oracle 10g RAC 的部署(2)

 2008-09-02 12:49:02 来源:WEB开发网   
核心提示: //显示redo文件的组和位置信息SQL>select2group#,3type,4member,5is_recovery_dest_file6fromv$logfile7orderbygroup#;GROUP#TYPEMEMBERIS_---1ONLINE+RECOVERYDEST

//显示redo文件的组和位置信息

SQL>select 
  2group#, 
  3type, 
  4member, 
  5is_recovery_dest_file 
  6fromv$logfile 
  7orderbygroup#; 
  GROUP#TYPEMEMBERIS_ 
  ------------------------------------------------------------------- 
  1ONLINE+RECOVERYDEST/gemni/onlinelog/group_1.257.606468581YES 
  1ONLINE+DG1/gemni/onlinelog/group_1.261.606468575NO 
  2ONLINE+RECOVERYDEST/gemni/onlinelog/group_2.258.606468589YES 
  2ONLINE+DG1/gemni/onlinelog/group_2.262.606468583NO 
  3ONLINE+DG1/gemni/onlinelog/group_3.265.606468865NO 
  3ONLINE+RECOVERYDEST/gemni/onlinelog/group_3.259.606468875YES 
  4ONLINE+DG1/gemni/onlinelog/group_4.266.606468879NO 
  4ONLINE+RECOVERYDEST/gemni/onlinelog/group_4.260.606468887YES

//显示asm实例的参数

$exportORACLE_SID=+ASM1 
  $sqlplus/assysdba 
  SQL>showsga 
  TotalSystemGlobalArea92274688bytes 
  FixedSize1217884bytes 
  VariableSize65890980bytes 
  ASMCache25165824bytes 
  $showparameterasm_disk 
  NAMETYPEVALUE 
  ----------------------------------------------------------------- 
  asm_diskgroupsstringDG1,RECOVERYDEST 
  asm_diskstringstring 
  SQL>select 
  2group_number, 
  3name, 
  4allocation_unit_sizealloc_unit_size, 
  5state, 
  6type, 
  7total_mb, 
  8usable_file_mb 
  9fromv$asm_diskgroup; 
  ALLOCUSABLE 
  GROUPUNITTOTALFILE 
  NUMBERNAMESIZESTATETYPEMBMB 
  ---------------------------------------------------- 
  1DG11048576MOUNTEDNORMAL61341868 
  2RECOVERYDEST1048576MOUNTEDEXTERN20471713 
  SQL>select 
  2name, 
  3path, 
  4header_status, 
  5total_mbfree_mb, 
  6trunc(bytes_read/1024/1024)read_mb, 
  7trunc(bytes_written/1024/1024)write_mb 
  8fromv$asm_disk; 
  NAMEPATHHEADER_STATUFREE_MBREAD_MBWRITE_MB 
  --------------------------------------------------------- 
  VOL1ORCL:VOL1MEMBER30672291242 
  VOL2ORCL:VOL2MEMBER30671641242 
  VOL3ORCL:VOL3MEMBER204711354

上一页  5 6 7 8 9 10 

Tags:Oracle RAC 部署

编辑录入:爽爽 [复制链接] [打 印]
赞助商链接