略
版本: 7.3 E0705P06
某局点安装iMC+Oracle的版本,采用的双机冷备的方式进行备份,设置为凌晨一点自动备份,备份后发现接入用户的信息并未同步备份至备机
1、查看dbman进程是否正常启动 //进程是正常启动的
2、查看dbman.log和dbman_debug.log
备份和恢复都是提示的成功,日志里记得也是成功,实际没有恢复成功,看有ORA的报错,报错如下:
2020-11-19 15:21:31 [DEBUG] [WriteFile] Write file /opt/iMC/dbman/bin/dbop.sql.
2020-11-19 15:21:31 [DEBUG] [CDbRestore::ExecRestoreSql] Exec command: sqlplus "-115-105-83-78-62/"-74-99-72-52-33-20-13-193-178-163-222-206"@ORCL" AS SYSDBA @"/opt/iMC/dbman/bin/dbop.sql" > "/opt/iMC/dbman/bin/dbop.sql.log"
2020-11-19 15:21:31 [INFO] [runCommand] runCommand result OK. ret=0, WIFEXITED(ret)=1, WEXITSTATUS(ret)=0
2020-11-19 15:21:31 [DEBUG] [CDbRestore::ExecRestoreSql] Exec sql log:
SQL*Plus: Release 11.2.0.1.0 Production on Thu Nov 19 15:21:31 2020
Copyright (c) 1982, 2009, Oracle. All rights reserved.
ERROR:
ORA-28009: connection as SYS should be as SYSDBA or SYSOPER
查看dbman_debug.log
2020-11-19 15:21:33 [INFO] [CDbRestore::RestoreDatabaseList] Restore databases finished
2020-11-19 15:21:33 [INFO] [ManualRestoreBase] Success to manual restore databases. ManualType: 0
3、
E0705P06引入了一个配置iMC/dbman/etc/DBEtcInfo.conf
这个配置里配置了使用不使用SYSDBA权限登录,默认是FALSE,改成TRUE
将iMC/dbman/etc/DBEtcInfo.conf 的SYSDBA的权限由FALSE改成TRUE
DBEtcInfo.conf文件中原先显示//将以下FALSE改成true
RestartDB=FALSE
IsSYSDBA=FALSE
若更改之后无法生效,可以直接删除DBEtcInfo.conf
该案例暂时没有网友评论
✖
案例意见反馈
亲~登录后才可以操作哦!
确定你的邮箱还未认证,请认证邮箱或绑定手机后进行当前操作