请教一个关于oracle一进程被锁，如何解锁？谢谢各位了！

andyhenj

我用的是HP-UNIX 10.20,Oracle数据库的SAP系统，
数据备份软件用的是Netbackup-Veritas.

故障描述：
当用Veritas policy备份oracle fullbackup时人为地终止了备份进程（刚调用脚本）。以上动作造成结果：数据库无法shutdown,也无法再次做oraclefullbackup了，
从log中得知故障原因就是因为人为终止备份进程造成的。

请各位帮我个忙，告诉我如何在oracle中解锁此备份进程。谢谢！

我的msn:andyhe_topnj@hotmail.com

sshd

SQL>;  help shutdown

SHUTDOWN
--------

Shuts down a currently running Oracle instance, optionally closing
and dismounting a database.

SHUTDOWN [ABORT|IMMEDIATE|NORMAL|TRANSACTIONAL [LOCAL]]


Also v$session shows who's logging in and v$transaction to see who has uncommitted transactions.

chaoping

maybe in hotbackup mode?
what is the error message when you do shutdown immediate?

andyhenj

error message when stop db:

shutdown-log is written to/home/cnaadm/stopdb.log
Database shutdown failded!
see/home/cnaadm/stopdb.log for details

stopdb.log :
Connected.
Statement processed.
ORA-01149: cannot shutdown - file 1 has online backup set
ORA-01110: data file 1: '/oracle/CNA/sapdata1/system_1/system.data1'
Server Manager complete.

Connect to the database to check the database state:

R3trans check finished with return code: 0
Database is still running
*** ERROR: shutdown failed

thanks!

sshd

use "select * from v$backup;" to check if there is any files that are in the backup mode.

be sure to use "oerr" to check the error messages that can tell you more. you can always use "shutdown abort" to shut it down. but after that you will need to "alter tablespace xxx end backup" to end the backup.

rhas3:/u01/product/9204/rdbms>; oerr ora 01149
01149, 00000, "cannot shutdown - file %s has online backup set"
// *Cause: An attempt to shutdown normally found that an online backup is
//        still in progress.
// *Action: End the backup of the offending tablespace and retry this command.