ORA-10873: file 1 needs to be either taken out of backup mode or media-recovered-ORA-01110: data file 1: ‘+DATA/ORCL/DATAFILE/system.257.1031501823’

While try to start the oracle instance, the database was in hot backup mode which prevents the instance to get open.

SQL> startup;
ORACLE instance started.

Total System Global Area 1140850688 bytes
Fixed Size                  2923584 bytes
Variable Size             419431360 bytes
Database Buffers          704643072 bytes
Redo Buffers               13852672 bytes
Database mounted.
ORA-10873: file 1 needs to be either taken out of backup mode or media
recovered
ORA-01110: data file 1: '+DATA/ORCL/DATAFILE/system.257.1031501823'

Check for active backups running on the database and any of tablespaces in backup mode

SQL> select * from v$backup;

     FILE# STATUS                CHANGE# TIME          CON_ID
---------- ------------------ ---------- --------- ----------
         1 ACTIVE               15774206 20-JUL-21          0
         2 ACTIVE               15774206 20-JUL-21          0
         3 ACTIVE               15774206 20-JUL-21          0
         4 ACTIVE               15774206 20-JUL-21          0
         5 ACTIVE               15774206 20-JUL-21          0
         6 ACTIVE               15774206 20-JUL-21          0
         7 ACTIVE               15774206 20-JUL-21          0
         8 ACTIVE               15774206 20-JUL-21          0
         9 ACTIVE               15774206 20-JUL-21          0

9 rows selected.

If yes, then wait for the backup to complete or end the hot backup mode and open the database.

SQL> alter database end backup;

Database altered.

SQL> alter database open;

Database altered.

Check the backup status

SQL> select * from v$backup;

     FILE# STATUS                CHANGE# TIME          CON_ID
---------- ------------------ ---------- --------- ----------
         1 NOT ACTIVE           15774206 20-JUL-21          0
         2 NOT ACTIVE           15774206 20-JUL-21          0
         3 NOT ACTIVE           15774206 20-JUL-21          0
         4 NOT ACTIVE           15774206 20-JUL-21          0
         5 NOT ACTIVE           15774206 20-JUL-21          0
         6 NOT ACTIVE           15774206 20-JUL-21          0
         7 NOT ACTIVE           15774206 20-JUL-21          0
         8 NOT ACTIVE           15774206 20-JUL-21          0
         9 NOT ACTIVE           15774206 20-JUL-21          0

9 rows selected.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s