场景一:使用dmrman执行backup备份数据库操作时,提示报错:[-137]:服务器正在运行或者存在其他进程正在操作同一个库

报错原因:使用dmrman备份数据库时,需要确保数据库在脱机状态,也就是数据库服务必须处于shutdown状态,必须停掉数据库服务后才能开展备份。
参考过程命令:
[dmdba@localhost bin]$ ps -ef | grep dmse
dmdba 1544 1 5 14:56 ? 00:00:02 /dm/dmdbms/bin/dmserver path=/dm/dmdbms/data/DAMENG/dm.ini -noconsole
dmdba 6763 6724 0 14:57 pts/0 00:00:00 grep --color=auto dmse
[dmdba@localhost bin]$ ps -ef | grep dm.ini
dmdba 1544 1 4 14:56 ? 00:00:02 /dm/dmdbms/bin/dmserver path=/dm/dmdbms/data/DAMENG/dm.ini -noconsole
dmdba 6765 6724 0 14:57 pts/0 00:00:00 grep --color=auto dm.ini
[dmdba@localhost bin]$ ./dmrman
dmrman V8
RMAN> backup database '/dm/dmdbms/data/DAMENG/dm.ini' backupset '/dm/dmdbms/data/DAMENG/bak/fullbak' compressed level 2 task thread 4 parallel 4;
backup database '/dm/dmdbms/data/DAMENG/dm.ini' backupset '/dm/dmdbms/data/DAMENG/bak/fullbak' compressed level 2 task thread 4 parallel 4;
[-137]:服务器正在运行或者存在其他进程正在操作同一个库
RMAN> exit
time used: 0.822(ms)
[dmdba@localhost bin]$ ./DmServiceDMSERVER stop
Stopping DmServiceDMSERVER: [ OK ]
[dmdba@localhost bin]$ ./dmrman
dmrman V8
RMAN> backup database '/dm/dmdbms/data/DAMENG/dm.ini' backupset '/dm/dmdbms/data/DAMENG/bak/fullbak' compressed level 2 task thread 4 parallel 4;
backup database '/dm/dmdbms/data/DAMENG/dm.ini' backupset '/dm/dmdbms/data/DAMENG/bak/fullbak' compressed level 2 task thread 4 parallel 4;
Database mode = 0, oguid = 0
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL
EP[0]'s cur_lsn[153245], file_lsn[153245]
Processing backupset /dm/dmdbms/data/DAMENG/bak/fullbak
[Percent:100.00%][Speed:0.00M/s][Cost:00:02:01][Remaining:00:00:00]
backup successfully!
time used: 00:02:02.565
RMAN>
原创文章,作者:lzb,如若转载,请注明出处:http://www.wlkjzx.com/2023/06/27/137%ef%bc%9a%e6%9c%8d%e5%8a%a1%e5%99%a8%e6%ad%a3%e5%9c%a8%e8%bf%90%e8%a1%8c%e6%88%96%e8%80%85%e5%ad%98%e5%9c%a8%e5%85%b6%e4%bb%96%e8%bf%9b%e7%a8%8b%e6%ad%a3%e5%9c%a8%e6%93%8d%e4%bd%9c%e5%90%8c/