ORACLE AUTOMATIC STORAGE MANAGEMENT翻译-第二章ASM Instance(4)完
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了ORACLE AUTOMATIC STORAGE MANAGEMENT翻译-第二章ASM Instance(4)完,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含6923字,纯文字阅读大概需要10分钟。
内容图文
Warning: Deprecated privilege SYSDBA for command ‘STARTUP‘ |
[oracle11@racnode1~]$ sqlplus "/ as sysasm" 创建ASMUSER,使用例如以下命令: SQL> CREATE USER ASMUSER IDENTIFIED BY ASMUSER1; SQL> GRANT SYSASM, SYSOPER TO ASMUSER; 使用ASMUSER连接ASM实例: [oracle@racnode1 ~]$ sqlplus "ASMUSER/ASMUSER as sysasm" SQL> select * from v$pwfile_users; USERNAME SYSDBA SYSOPER SYSASM ---------------------------- ----- ------- ------ SYS TRUE TRUE FALSE ASMUSER FALSE TRUE TRUE |
[oracle11@racnode1~]$ sqlplus " as sysoper" |
STARTUP/SHUTDOWN ALTER DISKGROUP MOUNT/DISMOUNT ALTER DISKGROUP ONLINE/OFFLINE DISK ALTER DISKGROUP REBALANCE ALTER DISKGROUP CHECK |
audit_sys_operations = TRUE _disable_instance_params_check = TRUE |
RDBMS实例与ASM实例全然分离,因此ASM拥有自己的password文件,
[oracle11@racnode1~]$ orapwd file=$ORACLE_HOME/asm/orapw+ASM1 \ password=oracle |
SQL> SELECT * FROM V$PWFILE_USERS; USERNAME SYSDB SYSOP SYSAS ------------------------------ ----- ----- ----- SYS TRUE TRUE FALSE |
- 由一个ASM管理员管理特定的ASM实例。ASM管理员能够来自Sysadmin(sa)
- ASM的软件能够由RDBMS用户来安装。这样能够加强ASM管理角色。
- 负责管理企业数据库DBA或ORACLE软件负责人同一时候管理ASM实例存储。
V$ASM_ALIAS This view displays all system- and user-defined aliases. There is one row for every alias present in every diskgroup mounted by the ASM instance. The RDBMS instance displays no rows in this view. V$ASM_ATTRIBUTE This Oracle Database 11gview displays one row for each ASM attribute defined. These attributes are listed when they are defined in CREATE DISKGROUPor ALTER DISKGROUPstatements. DISK_REPAIR_TIMERis an example of an attribute. V$ASM_CLIENT This view displays one row for each RDBMS instance that has an opened ASM diskgroup. V$ASM_DISK This view contains specifics about all disks discovered by the ASM instance, including mount status, disk state, and size. There is one row for every disk discovered by the ASM instance. V$ASM_DISK_IOSTAT This displays information about disk I/O statistics for each ASM client. If this view is queried from the database instance, only the rows for that instance are shown. V$ASM_DISK_STAT This view contains similar content as the V$ASM_ DISK, except V$ASM_DISK_STATreads disk information from cache and thus performs no disk discovery. This view is primarily used for quick access to the disk information without the overhead of disk discovery. V$ASM_DISKGROUPV$ASM_DISKGROUPdisplays one row for every ASM diskgroup discovered by the ASM instance on the node. V$ASM_DISKGROUP_STAT This view contains all the similar view contents as the V$ASM_DISKGROUP, except that V$ASM_DISK_STATreads disk information from the cache and thus performs no disk discovery. This view is primarily used for quick access to the diskgroup information without the overhead of disk discovery. V$ASM_FILE The V$ASM_FILEview displays information about ASM files. There is one row for every ASM file in every diskgroup mounted by the ASM instance. In a RDBMS instance, V$ASM_FILEdisplays no rows. V$ASM_OPERATION This view describes the progress of an influx ASM rebalance operation. In a RDBMS instance, V$ASM_OPERATIONdisplays no rows. V$ASM_TEMPLATE This view contains information on user- and systemdefined templates. V$ASM_TEMPLATEdisplays one row for every template present in every diskgroup mounted by the ASM instance. In a RDBMS instance,V$ASM_TEMPLATEdisplays one row for every template present in every diskgroup mounted by the ASM instance with which the RDBMS instance communicates |
-----------------------------------------------------------------------------------------------------------------
本站注明原创和翻译的均为原创文章,文章同意转载,但必须以链接方式注明源地址,
否则追究法律责任
!
文章中难免有疏漏欢迎网友批评指正。
QQ: 173386747
Email: hailong.sun1982@gmail.com
Blog: http://blog.csdn.net/card_2005
原文:http://www.cnblogs.com/lcchuguo/p/4001363.html
内容总结
以上是互联网集市为您收集整理的ORACLE AUTOMATIC STORAGE MANAGEMENT翻译-第二章ASM Instance(4)完全部内容,希望文章能够帮你解决ORACLE AUTOMATIC STORAGE MANAGEMENT翻译-第二章ASM Instance(4)完所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。