![](https://img-blog.csdnimg.cn/20201014180756930.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Oracle数据库
文章平均质量分 68
李德鹏-LDP
记录
展开
-
goldengate ddl enable,ORA-04098: trigger 'SYS.GGS_DDL_TRIGGER_BEFORE' is invalid
环境: 数据库版本11.2.0.3.11Oracle GoldenGate Command Interpreter for OracleVersion 11.2.1.0.5_01 16224002 OGGCORE_11.2.1.0.6_PLATFORMS_130205.0600_FBOLinux, x64, 64bit (optimized), Oracle 11g on Feb 5 2...原创 2014-10-14 18:52:20 · 4255 阅读 · 0 评论 -
Adding / Dropping Disks From a ASM Disk Group
磁盘组规划出现问题,需要踢出磁盘,具体添加删除步骤如下: Adding / Dropping Disks From a ASM Disk Groupby Jeff Hunter, Sr. Database AdministratorContents Introduction Identify Candidate Disks Add Disks to a Disk Gro...转载 2014-09-20 23:08:32 · 761 阅读 · 0 评论 -
归档误删除,RMAN备份失败
错误信息如下:Starting backup at 16-AUG-14current log archivedreleased channel: c1released channel: c2RMAN-00571: ===========================================================RMAN-00569: ==============...原创 2014-08-18 22:03:02 · 962 阅读 · 0 评论 -
IOT/Abort trap 故障
故障现象:RAC节点2新建连接无法连接数据库,已有连接报无法扩展空间。crs_stat –t -v报错,IOT/Abort trap节点1执行crs_stat –t -v发现节点2的ONS和GSD服务为OFFLINE$errpt C69F5C9B 0719173614 P S SYSPROC SOFTWARE PROGRAM ABNORMALLY TER...原创 2014-07-22 11:22:32 · 4905 阅读 · 0 评论 -
ORA-00600: internal error code, arguments: [kcblasm_1], [103], [], [], [], [], [], []
环境描述 AIX5.3 HACMP Oracle 10.2.0.5 故障描述 Sun Jun 01 06:46:43 BEIST 2014 Errors in file /u01/app/admin/findbb/udump/findbb_ora_696582.trc: ORA-00600: internal ...原创 2014-07-25 23:19:50 · 1858 阅读 · 0 评论 -
SPOOL sql语句实现LOOP循环转储多文件
客户想在sql文件的spool中实现循环,每次循环为每天生成一个结果文件,在Oracle community 中找到如下方式记录: SET serverout onSET some_more_appropriate_headingsSPOOL my_master_spool_fileBEGIN FOR i IN 1 .. 10 LOOP DBMS_OUT...转载 2014-08-02 11:49:14 · 1442 阅读 · 0 评论