随笔分类 -  Oracle数据库

性能优化，故障处理
定位消耗temp空间SQL
摘要：For 8.1.7 to 9.2: SELECT a.username, a.sid, a.serial#, a.osuser, b.tablespace, b.blocks, c.sql_text FROM v$session a, v$sort_usage b, v$sqlarea c WHER 阅读全文
posted @ 2021-03-18 10:00 菲阳公社 阅读(72) 评论(0) 推荐(0)
RAC更换controlfile位置
摘要：1.Stop Instance srvctl stop instance -d dbname -i instance1,instance2 -o immediate 2.Start database to nomount srvctl start database -d dbname -o nomo 阅读全文
posted @ 2021-03-16 16:41 菲阳公社 阅读(97) 评论(0) 推荐(0)
EXPDP ORA-02354 error in exporting/importing data ORA-01555: snapshot too old
摘要：Check lob status Cause The cause of these errors could be a LOB corruption. Maintaining the LOBs will solve the problem with Exp/Expdp. Copyright (c) 阅读全文
posted @ 2021-03-16 11:05 菲阳公社 阅读(783) 评论(0) 推荐(0)
19c 迁移OCR&MTGTDB到新的DISKGROUP
摘要：OCR and VOTEDISK as root user, 1.ocrconfig -add newdiskgroup ocrconfig -delete olddiskgroup as grid user, 2.crsctl replace votedisk newdiskgroup as ro 阅读全文
posted @ 2021-03-15 17:09 菲阳公社 阅读(238) 评论(0) 推荐(0)
Oracle Expdp由高版本到低版本数据库
摘要：## expdp需要添加 version参数 version=11.2.0.4.0（低版本号） 阅读全文
posted @ 2021-03-09 16:18 菲阳公社 阅读(113) 评论(0) 推荐(0)