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

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

Error: Getting the following error while starting the Oracle database.

2023-10-19T17:06:08.542854-04:00
Errors in file E:\ORACLE\diag\rdbms\orcl\orcl\trace\orcl_ora_1964.trc:
ORA-10873: file 1 needs to be either taken out of backup mode or media recovered
ORA-01110: data file 1: 'E:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF'
ORA-10873 signalled during: alter database open... 

Cause: As per the error the system data file seems to be in backup mode or media recovered. The reason may be that while taking a backup the database aborts or the machine reboots.

Solution: Alter the database to end backup state.

Login to the SQLPLUS with /as sysdba or sys as sysdba.

sqlplus / as sysdba

Start the database in mount state

startup mount

Check the backup file status

select * from V$BACKUP;

Disable the backup with the following command:

alter database end backup;

Open the database in read-write mode:

alter database open;