Oracle 10g RAC 的部署(2)
2008-09-02 12:49:02 来源:WEB开发网//显示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
- ››oracle 中 UPDATE nowait 的使用方法
- ››Oracle ORA-12560解决方法
- ››Oracle 10g RAC 常用维护命令
- ››Oracle如何在ASM中定位文件的分布
- ››Oracle的DBMS_RANDOM.STRING 的用法
- ››oracle 外部表导入时间日期类型数据,多字段导入
- ››Oracle中查找重复记录
- ››oracle修改用户登录密码
- ››Oracle创建删除用户、角色、表空间、导入导出等命...
- ››Oracle中登陆时报ORA-28000: the account is lock...
- ››Oracle数据库在配置文件中更改最大连接数
- ››Oracle中在pl/sql developer修改表的两种方式
更多精彩
赞助商链接