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

Symptom

We are getting below ORA error message while trying to bringing up the Oracle database.

SQL> startup;
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area 1.7638E+10 bytes
Fixed Size 2260272 bytes
Variable Size 7985955536 bytes
Database Buffers 9596567552 bytes
Redo Buffers 53452800 bytes
Database mounted.
ORA-10873: file 1 needs to be either taken out of backup mode or media
recovered
ORA-01110: data file 1: 'D:\ORACLE\PRD\SAPDATA1\SYSTEM_1\SYSTEM.DATA1'

Solution

1. Bring down the Oracle database.

SQL> shutdown immediate;
Database dismounted.
ORACLE instance shut down.

2. Start the Oracle database in mount mode.

SQL> startup mount;
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area 1.7638E+10 bytes
Fixed Size 2260272 bytes
Variable Size 7985955536 bytes
Database Buffers 9596567552 bytes
Redo Buffers 53452800 bytes
Database mounted.

3. Look up the backup status.

SQL> select * from V$BACKUP;

FILE# STATUS CHANGE# TIME
---------- ------------------ ---------- ---------------
1 ACTIVE 347324791 21-SEP-15
2 ACTIVE 347324820 21-SEP-15
3 ACTIVE 347324835 21-SEP-15
4 ACTIVE 347324841 21-SEP-15
5 ACTIVE 347324841 21-SEP-15
6 ACTIVE 347324847 21-SEP-15
7 ACTIVE 347324847 21-SEP-15
8 ACTIVE 347324853 21-SEP-15
9 ACTIVE 347324847 21-SEP-15
10 ACTIVE 347324841 21-SEP-15
11 ACTIVE 347324841 21-SEP-15
11 rows selected.

4. End the backup state.

SQL> alter database end backup;

5. Open the database.

SQL> alter database open;