- [-104]:INI参数文件错误
本人在开启数据库归档日志的过程当中,执行如下命令时遇到了这个错误bash
ALTER DATABASE ADD ARCHIVELOG 'DEST=/home/dmdba/dmdbms/data/DMLAB/arch,TYPE=LOCAL,FILE_SIZE=64,SPACE_LIMIT=0'; ALTER DATABASE ADD ARCHIVELOG 'DEST=/home/dmdba/dmdbms/data/DMLAB/arch,TYPE=LOCAL,FILE_SIZE=64,SPACE_LIMIT=0'; 第1 行附近出现错误[-104]:INI参数文件错误. 已用时间: 0.751(毫秒). 执行号:0. 复制代码
经过排查,确认为dmarc.ini文件权限被修改成了root用户,致使使用dmdba用户进行归档文件添加时没有相应权限修改dmarc.ini文件。工具
解决办法:ui
chown dmdba.dinstall dmarc.ini
spa
- CMD END.CODE:[-7109],DESC:[管道链接失败]
在使用dmrman进行脱机备份时遇到该错误:日志
RMAN> BACKUP DATABASE '/dm7/dmdbs/DMDCM/dm.ini'; BACKUP DATABASE '/dm7/dmdbs/DMDCM/dm.ini'; checking if the database under system path [/dm7/dmdbs/DMDCM] is running...[4]. checking if the database under system path [/dm7/dmdbs/DMDCM] is running...[3]. checking if the database under system path [/dm7/dmdbs/DMDCM] is running...[2]. checking if the database under system path [/dm7/dmdbs/DMDCM] is running...[1]. checking if the database under system path [/dm7/dmdbs/DMDCM] is running...[0]. checking if the database under system path [/dm7/dmdbs/DMDCM] is running, write dmrman info. EP[0] max_lsn: 130255 BACKUP DATABASE [DMDCM],execute...... os_pipe2_conn_server open failed, name:[/home/dmdba/DM_PIPE_DMAP_LSNR_WR], errno:2 CMD END.CODE:[-7109],DESC:[管道链接失败] [-7109]:管道链接失败 复制代码
经过分析,发现该命令会读取当前目录下的DM_PIPE_DMAP_LSNR_WR文件,但该文件并不在当前的目录下,实际该文件位于$DM_HOME/bin 目录下,因而切换到该目录下执行dmrmancode
[dmdba@dmlab ~]$ cd $DM_HOME/bin [dmdba@dmlab bin]$ dmrman dmrman V7.6.0.142-Build(2019.03.12-103811)ENT RMAN> BACKUP DATABASE '/dm7/dmdbs/DMDCM/dm.ini'; BACKUP DATABASE '/dm7/dmdbs/DMDCM/dm.ini'; file dm.key not found, use default license! checking if the database under system path [/dm7/dmdbs/DMDCM] is running...[4]. checking if the database under system path [/dm7/dmdbs/DMDCM] is running...[3]. checking if the database under system path [/dm7/dmdbs/DMDCM] is running...[2]. checking if the database under system path [/dm7/dmdbs/DMDCM] is running...[1]. checking if the database under system path [/dm7/dmdbs/DMDCM] is running...[0]. checking if the database under system path [/dm7/dmdbs/DMDCM] is running, write dmrman info. EP[0] max_lsn: 130255 BACKUP DATABASE [DMDCM],execute...... CMD CHECK LSN...... BACKUP DATABASE [DMDCM],collect dbf...... CMD CHECK ...... DBF BACKUP SUBS...... total 1 packages processed... total 3 packages processed... total 4 packages processed... total 5 packages processed... DBF BACKUP MAIN...... BACKUPSET [/dm7/dmdbs/DMDCM/bak/DB_DMDCM_FULL_20190922_232931_000868] END, CODE [0]...... META GENERATING...... total 6 packages processed... total 6 packages processed! CMD END.CODE:[0] backup successfully! time used: 7019.548(ms) 复制代码
脱机备份执行成功,这样看来环境变量的设置对于dmrman并无任何意义,反而还成为了一个坑。server
- 错误号:-7105 错误消息:管道链接超时
在使用DM控制台工具进行脱机备份时遇到了该错误,官方给的说法是没有启用DMAP服务,但实际状况是DMAP服务是正常启用的,以下:对象
[root@dmlab init.d]# service DmAPService status DmAPService (pid 2292) is running... 复制代码
多方尝试解决未果,最后将DM控制台工具有份还原的 备份还原执行策略:使用DMAP方式取消掉之后便可正常进行备份,目前还不知道具体是什么缘由致使的,待后续进一步核实。ip
- [-7041]:数据库对象[SALARY_UPDATE]已存在
在建立名为:SALARY_UPDATE的触发器过程当中产生该错误。
错误缘由:触发器名称不能和表名称相同
解决办法:修改表名或者触发器名称
- DMAP INIT FAILED, CODE:[-7157]:管道文件已存在
在启动DmAPService服务过程当中遇到该错误
缘由:$DM_HOME/bin/目录下已经存在DM_PIPE_DMAP_LSNR_RD,DM_PIPE_DMAP_LSNR_WR文件,初步怀疑多是上次非正常关机形成
解决办法:删除$DM_HOME/bin/下DM_PIPE_DMAP_LSNR_RD及DM_PIPE_DMAP_LSNR_WR文件便可