This article is about ORA-10873: file 1 needs to be either taken out of backup mode or media recovered.
Index
Cause
This is may be due to database went down while database is in backup mode.
Error in the alert log
Errors in file F:\ORACLE\PRODUCT\DIAG\diag\rdbms\bwdb\bwdb\trace\bwdb_ora_1268.trc:
ORA-10873: file 1 needs to be either taken out of backup mode or media recovered
ORA-01110: Datendatei 1: 'G:\ORACLE\ORADATA\BWDB\SYSTEM01.DBF'
ORA-10873 signalled during: ALTER DATABASE OPEN...
Solution
Step 1 – shutdown the database.
shut immediate
Step 2 – start the database in mount mode.
startup mount
Step 3 – Check backup files using the below command.
select * from V$BACKUP;
Step 4 – The below command can be used to take all of the data files out of hot backup mode.
ALTER DATABASE END BACKUP;
Step 5 – Now open the database.
ALTER DATABASE OPEN;
Conclusion
Hope this will be a helpful document for you to consider while resolving the error ora-10873.
Views: 468