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: 990
Share this:
- Click to share on Facebook (Opens in new window) Facebook
- Click to share on LinkedIn (Opens in new window) LinkedIn
- Click to share on X (Opens in new window) X
- Click to share on Pinterest (Opens in new window) Pinterest
- Click to share on Telegram (Opens in new window) Telegram
- Click to share on WhatsApp (Opens in new window) WhatsApp