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



Share this article :

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;

Tags:

Related posts

ORA-00155: cannot perform work outside of global transaction
ORA-00258: manual archive in NOARCHIVELOG must identify log
ORA-00360: not a logfile member: string
ORA-00498: XDWK process terminated with error
© 2017 ITsiti. All Rights Reserved
Powered by KEEM