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

Introduction

This Post demonstrates about ORA-10873 , the file 1 needs to be either taken out of backup mode or media recovered

Scenario :

Database went down due to power fluctuation and during that time hot backup was running.So once we started the database we face the following issue.

Error :

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

ORA-01110: data file 1: ‘/system/PROD/system01.dbf’

Cause :

Database is in backup mode while it went down.

Solution :

Step 1 : Sqlplus ‘/as sysdba’

Step 2 : startup mount

Step 3 : Check backup file using below command.

select * from V$BACKUP

Step 4 : The following command can be used to take all of the data files out of hot backup mode:

ALTER DATABASE END BACKUP;

Step 5 : Alter database open