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

Hi friends, recently our system went down and at that time backup is running. So now when we are starting our database we are getting following issue: ORA-10873: file 1 needs to be either taken out of backup mode or media recovered.

Solution:

Step1: Shutdown the Database.

shut immediate;

Step2: Start the Oracle database in mount mode.

startup mount;

Step3: Look up the running backup status.

select * from v$backup;

Step4: Alter the database to End the backup state, and Open the database for connections.

alter database end backup;

alter database open.