设为首页 加入收藏

TOP

ASM下裸设备的路径更改是否会影响数据库的运行(三)
2014-11-24 07:45:03 来源: 作者: 【 】 浏览:8
Tags:ASM 设备 路径 更改 是否 影响 数据库 运行
e1 [oracle@node2 ~]$ export ORACLE_SID=+ASM2 [oracle@node2 ~]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.5.0 - Production on Sun Aug 31 13:14:31 2014 Copyright (c) 1982, 2010, Oracle. All Rights Reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production With the Partitioning, Real Application Clusters, OLAP, Data Mining and Real Application Testing options SQL> col name for a31 SQL> col label for a31 SQL> col path for a31 SQL> set linesize 211 SQL> select name,label,path from v$asm_disk order by 1; NAME LABEL PATH ------------------------------- ------------------------------- ------------------------------- DG1_0000 /dev/raw/raw3 DG2_0000 /dev/raw/raw4 DG3_0000 /dev/raw/raw5 DG3_0001 /dev/raw/raw6 DG4_0000 /dev/raw/raw7 /dev/raw/raw2 /dev/raw/raw1 7 rows selected. SQL> exit Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production With the Partitioning, Real Application Clusters, OLAP, Data Mining and Real Application Testing options [oracle@node2 ~]$ export ORACLE_SID=easy2 [oracle@node2 ~]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.5.0 - Production on Sun Aug 31 13:15:31 2014 Copyright (c) 1982, 2010, Oracle. All Rights Reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production With the Partitioning, Real Application Clusters, OLAP, Data Mining and Real Application Testing options SQL> select count(*) from t1; COUNT(*) ---------- 128 SQL> select min(id),max(id) from t1; MIN(ID) MAX(ID) ---------- ---------- 1 128 由此可见,裸设备路径和名称的改变不会影响asm的使用,但是,我们依然建议保持路径名称的稳定性,方便管理。
首页 上一页 1 2 3 下一页 尾页 3/3/3
】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
分享到: 
上一篇QlikView图表显示同比数据 下一篇QlikView显示所选时间前一年的数据

评论

帐  号: 密码: (新用户注册)
验 证 码:
表  情:
内  容:

·请问c语言刚入门,该 (2025-12-26 10:21:04)
·python 编程怎么定义 (2025-12-26 10:21:01)
·09-指 针 (一)-c语言 (2025-12-26 10:20:58)
·About - Redis (2025-12-26 08:20:56)
·Redis: A Comprehens (2025-12-26 08:20:53)