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
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