We had an Oracle database that would not start up. Database users could not log on, receiving the error “ORA-01033 ORACLE initialization or shutdown in progress”.
When attempting to start the database we received the error “ORA-10873: file 1 needs to be either taken out of backup mode or media recovered“.
To resolve this issue, we need to take the file out of backup mode with the following steps:
Login: sys as sysdba
startup mount
select * from V$BACKUP
.
.
.
alter database end backup;
alter database open;
I have also found an alternative method to media recover, however I have not tested this.
startup mount
recover automatic database;
alter database open;