Thursday, June 2, 2016

How to solve the ORA-10873 error message of Oracle

When I's trying to startup my Oracle instance with this method because It got the "ORA-01109 Database not open" error. I encountered another error:

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

Here is how I solved it. From the command prompt:

sqlplus /@MYDBINSTANCE as sysdba

STARTUP MOUNT
SELECT * FROM V$BACKUP
ALTER DATABASE END BACKUP
ALTER DATABASE OPEN