ORA-10873: file 4 needs to be either taken out of backup mode or media

最新推荐文章于 2022-07-23 16:00:44 发布

原创

最新推荐文章于 2022-07-23 16:00:44 发布 · 2.8k 阅读

4 ·

CC 4.0 BY-SA版权

问题描述：

今天主机宕机后，使用./autostart无法启动数据库。报出一下错误 ORA-10873: file 4 needs to be either taken out of backup mode or media

问题分析：

在宕机的时候数据库正在备份状态，此时意外停机则数据库的备份无法正常进行。而在数据库备份的时候数据库中的v$backup表中会将STATUS列置成Active状态，此时停机数据库无法将把STATUS换成NOT ACTIVE状态。而v$backup表中STATUS列不是NOT ACTIVE，这数据库无法正常启动。

develop:/auto>su - oradvp -c "lsnrctl start"

LSNRCTL for IBM/AIX RISC System/6000: Version 11.2.0.2.0 - Production on 20-JUL-2012 12:23:07

Copyright (c) 1991, 2010, Oracle.  All rights reserved.

TNS-01106: Listener using listener name LISTENER has already been started
develop:/auto>su - dvpadm -c "startsap"
Checking DVP Database
Database is not available via R3trans
-------------------------------------------
Trying to start DVP database ...
Log file: /home/dvpadm/startdb.log
/usr/sap/DVP/SYS/exe/run/startdb: Terminating with error code 12
DB startup failed

please send the tracefile /home/dvpadm/startsap.trc to support

develop:/auto>cd  
develop:/>cd /home/dvpadm            
develop:/home/dvpadm>ls
.TTauthority               .j2eeenv.sh                .sapenv_develop.sh         startsap_DVEBMGS00.log.1   stopsap.trc
.Xauthority                .j2eeenv_develop.csh       .sapsrc.csh                startsap_DVEBMGS00.log.2   stopsap_DVEBMGS00.log
.cshrc                     .j2eeenv_develop.sh        .sapsrc.sh                 startsap_DVEBMGS00.log.3   stopsap_DVEBMGS00.log.1
.cshrc.1                   .login                     .sapsrc_develop.csh        startsap_DVEBMGS00.log.4   stopsap_DVEBMGS00.log.2
.dbenv.csh                 .login.1                   .sapsrc_develop.sh         startsap_DVEBMGS00.log.5   stopsap_DVEBMGS00.log.3
.dbenv.sh                  .profile                   .sh_history                startsap_DVEBMGS00.log.6   stopsap_DVEBMGS00.log.4
.dbenv_develop.csh         .profile.1                 .wmrc                      startsap_DVEBMGS00.log.7   stopsap_DVEBMGS00.log.5
.dbenv_develop.sh          .profile.2                 dsierror.log               startsap_DVEBMGS00.log.8   stopsap_DVEBMGS00.log.6
.dt                        .sapenv.csh                startdb.log                startsap_DVEBMGS00.log.9   stopsap_DVEBMGS00.log.7
.dtprofile                 .sapenv.sh                 startsap.trc               startsap_saphostagent.log  stopsap_DVEBMGS00.log.8
.j2eeenv.csh               .sapenv_develop.csh        startsap_DVEBMGS00.log     stopdb.log                 stopsap_DVEBMGS00.log.9
develop:/home/dvpadm>more startdb.log

------------------------------ Fri Jul 20 12:23:21 BEIST 2012
LOGFILE FOR STARTING ORACLE

Trying to start DVP database ...

----