温馨提示！由于新浪微博认证机制调整，您的新浪微博帐号绑定已过期，请重新绑定！&&|&&
LOFTER精选
网易考拉推荐
用微信&&“扫一扫”
将文章分享到朋友圈。
用易信&&“扫一扫”
将文章分享到朋友圈。
SQL& select name from v$NAME------------------------------SYSTEMUNDOTBS1SYSAUXUSERSTEMPUNDOTBS2WOFSSPACE7 rows selected.&2、下面删除WOFSSPACE这个表空间，包括属于他的数据文件（物理上也同时删除）SQL& drop tablespace WOFSSPACE including coTablespace dropped.&3、删除之后，查询表空间视图确认SQL& select name from v$NAME------------------------------SYSTEMUNDOTBS1SYSAUXUSERSTEMPUNDOTBS26 rows selected.&4、到ASM目录去验证一把，看物理文件是否真的已经删除SQL& exitDisconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, OLAP, Data Miningand Real Application Testing options[oracle@racdb1 ~]$ export ORACLE_SID=+ASM1[oracle@racdb1 ~]$ asmcmdASMCMD& lsARCH/DATA/ASMCMD& cd DATAASMCMD& lsRACDB/ASMCMD& cd RACDBASMCMD& lsCONTROLFILE/DATAFILE/ONLINELOG/PARAMETERFILE/TEMPFILE/spfileracdb.oraASMCMD& cd DATAFILEASMCMD& ll& & & & commands:&& & & & -------- && & & & cd& & & & du& & & & find& & & & help& & & & ls& & & & lsct& & & & lsdg& & & & mkalias& & & & mkdir& & & & pwd& & & & rm& & & & rmaliasASMCMD& lsSYSAUX.262.SYSTEM.264.UNDOTBS1.267.UNDOTBS2.265.USERS.259.ASMCMD&可以可以到物理文件也已经被删除了；如果没有加INCLUDING这个参数，那么可以进去ASM目录，用RM删除之；&5、在ASM上创建表空间，自定义目录及DATAFILE的名字SQL& create tablespace WOFSSPACE datafile '+DATA/RACDB/DATAFILE/WOFSSPACE.dbf' size 4096Tablespace created.&6、查询确认OKSQL& select name from v$NAME--------------------------------------------------------------------------------+DATA/racdb/datafile/system.264.+DATA/racdb/datafile/undotbs1.267.+DATA/racdb/datafile/sysaux.262.+DATA/racdb/datafile/users.259.+DATA/racdb/datafile/undotbs2.265.+DATA/racdb/datafile/wofsspace.dbf6 rows selected.SQL& select name from v$NAME------------------------------SYSTEMUNDOTBS1SYSAUXUSERSTEMPUNDOTBS2WOFSSPACE7 rows selected.SQL&
阅读(980)|
用微信&&“扫一扫”
将文章分享到朋友圈。
用易信&&“扫一扫”
将文章分享到朋友圈。
历史上的今天
loftPermalink:'',
id:'fks_',
blogTitle:'ORACLE ASM环境中如何删除和创建表空间',
blogAbstract:'1、列出表空间SQL& select name from v$NAME------------------------------SYSTEMUNDOTBS1SYSAUXUSERSTEMPUNDOTBS2WOFSSPACE7 rows selected.&2、下面删除WOFSSPACE这个表空间，包括属于他的数据文件（物理上也同时删除）SQL& drop tablespace WOFSSPACE including co',
blogTag:'',
blogUrl:'blog/static/',
isPublished:1,
istop:false,
modifyTime:0,
publishTime:6,
permalink:'blog/static/',
commentCount:0,
mainCommentCount:0,
recommendCount:0,
bsrk:-100,
publisherId:0,
recomBlogHome:false,
currentRecomBlog:false,
attachmentsFileIds:[],
groupInfo:{},
friendstatus:'none',
followstatus:'unFollow',
pubSucc:'',
visitorProvince:'',
visitorCity:'',
visitorNewUser:false,
postAddInfo:{},
mset:'000',
remindgoodnightblog:false,
isBlackVisitor:false,
isShowYodaoAd:false,
hostIntro:'',
hmcon:'1',
selfRecomBlogCount:'0',
lofter_single:''
{list a as x}
{if x.moveFrom=='wap'}
{elseif x.moveFrom=='iphone'}
{elseif x.moveFrom=='android'}
{elseif x.moveFrom=='mobile'}
${a.selfIntro|escape}{if great260}${suplement}{/if}
{list a as x}
推荐过这篇日志的人：
{list a as x}
{if !!b&&b.length>0}
他们还推荐了：
{list b as y}
转载记录：
{list d as x}
{list a as x}
{list a as x}
{list a as x}
{list a as x}
{if x_index>4}{break}{/if}
${fn2(x.publishTime,'yyyy-MM-dd HH:mm:ss')}
{list a as x}
{if !!(blogDetail.preBlogPermalink)}
{if !!(blogDetail.nextBlogPermalink)}
{list a as x}
{if defined('newslist')&&newslist.length>0}
{list newslist as x}
{if x_index>7}{break}{/if}
{list a as x}
{var first_option =}
{list x.voteDetailList as voteToOption}
{if voteToOption==1}
{if first_option==false},{/if}&&“${b[voteToOption_index]}”&&
{if (x.role!="-1") },“我是${c[x.role]}”&&{/if}
&&&&&&&&${fn1(x.voteTime)}
{if x.userName==''}{/if}
网易公司版权所有&&
{list x.l as y}
{if defined('wl')}
{list wl as x}{/list}温馨提示！由于新浪微博认证机制调整，您的新浪微博帐号绑定已过期，请重新绑定！&&|&&
LOFTER精选
网易考拉推荐
用微信&&“扫一扫”
将文章分享到朋友圈。
用易信&&“扫一扫”
将文章分享到朋友圈。
阅读(311)|
用微信&&“扫一扫”
将文章分享到朋友圈。
用易信&&“扫一扫”
将文章分享到朋友圈。
历史上的今天
loftPermalink:'',
id:'fks_',
blogTitle:'ASM基本操作',
blogAbstract:'--reads 读的次数 writes:写的次数 read_time:读的总时间 write_time:写的总时间 bytes_read:读的总字节数 --bytes_written:写的总字节数select group_number,name,total_mb,bytes_written,bytes_read,writes,reads,write_time,read_time from v$asm_diskselect * from v$asm_diskgroupselect * from v$asm_operationselect * from v$asm_disk_statselect * from v$asm_diskgroup_statselect * from v$asm_templateselect * from v$asm_file',
blogTag:'asm,操作',
blogUrl:'blog/static/7',
isPublished:1,
istop:false,
modifyTime:0,
publishTime:7,
permalink:'blog/static/7',
commentCount:0,
mainCommentCount:0,
recommendCount:0,
bsrk:-100,
publisherId:0,
recomBlogHome:false,
currentRecomBlog:false,
attachmentsFileIds:[],
groupInfo:{},
friendstatus:'none',
followstatus:'unFollow',
pubSucc:'',
visitorProvince:'',
visitorCity:'',
visitorNewUser:false,
postAddInfo:{},
mset:'000',
remindgoodnightblog:false,
isBlackVisitor:false,
isShowYodaoAd:false,
hostIntro:'',
hmcon:'0',
selfRecomBlogCount:'0',
lofter_single:''
{list a as x}
{if x.moveFrom=='wap'}
{elseif x.moveFrom=='iphone'}
{elseif x.moveFrom=='android'}
{elseif x.moveFrom=='mobile'}
${a.selfIntro|escape}{if great260}${suplement}{/if}
{list a as x}
推荐过这篇日志的人：
{list a as x}
{if !!b&&b.length>0}
他们还推荐了：
{list b as y}
转载记录：
{list d as x}
{list a as x}
{list a as x}
{list a as x}
{list a as x}
{if x_index>4}{break}{/if}
${fn2(x.publishTime,'yyyy-MM-dd HH:mm:ss')}
{list a as x}
{if !!(blogDetail.preBlogPermalink)}
{if !!(blogDetail.nextBlogPermalink)}
{list a as x}
{if defined('newslist')&&newslist.length>0}
{list newslist as x}
{if x_index>7}{break}{/if}
{list a as x}
{var first_option =}
{list x.voteDetailList as voteToOption}
{if voteToOption==1}
{if first_option==false},{/if}&&“${b[voteToOption_index]}”&&
{if (x.role!="-1") },“我是${c[x.role]}”&&{/if}
&&&&&&&&${fn1(x.voteTime)}
{if x.userName==''}{/if}
网易公司版权所有&&
{list x.l as y}
{if defined('wl')}
{list wl as x}{/list}Oracle 11gR2 警告文件的位置_数据库技术_Linux公社-Linux系统门户网站
你好，游客
Oracle 11gR2 警告文件的位置
来源：Linux社区&
作者：haozg_oracle
11g asm实例的警告日志文件alert_+ASM.log的位置:ORACLE_BASE/diag/asm/+asm/+ASM/trace/opt/app/oracle/diag/asm/+asm/+ASM/trace
oracle 11g 数据库的警告日志文件alert_oradb1.log的位置：ORACLE_BASE/diag/rdbms/oradb1/oradb1/trace/opt/app/oracle/diag/rdbms/oradb1/oradb1/trace
数据库或者是asm出现问题先看警告日志文件按，原因是警告日志文件中提示数据在运行过程中出现的错误，还更详细的告诉你要到那个跟踪问价中找更为具体的错误。
相关资讯 & & &
& (11/26/:40)
& (07/08/:20)
　　　同意评论声明
　　　发表
尊重网上道德，遵守中华人民共和国的各项有关法律法规
承担一切因您的行为而直接或间接导致的民事或刑事法律责任
本站管理人员有权保留或删除其管辖留言中的任意内容
本站有权在网站内转载或引用您的评论
参与本评论即表明您已经阅读并接受上述条款