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

This article is about ORA-10873: file 1 needs to be either taken out of backup mode or media recovered.

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

ByuRPbSwFZgAAAABJRU5ErkJggg==

Solution

Step 1 – shutdown the database.

shut immediate

 

P1pWaCQYi0YAAAAASUVORK5CYII=

Step 2 – start the database in mount mode.

startup mount 

 

Step 3 – Check backup files using the below command.

select * from V$BACKUP;

 

ck6yAQAAAAzj6f4lAAAAALogyQYAAAAGRpINAAAADIwkGwAAABgYSTYAAAAwMJJsAAAAYGAk2QAAAMDASLIBAACAgZFkAwAAAAMjyQYAAAAG9jfAfLaKDzsMagAAAABJRU5ErkJggg==

Step 4 – The below command can be used to take all of the data files out of hot backup mode.

ALTER DATABASE END BACKUP;

JpgDgAAAQRzAAAIIJgDAEAAwRwAAAII5gAAEEAwBwCAAII5AAAEEMwBACCAYA4AAAEEcwAACCCYAwBAgBdmIieeOyNXZQAAAABJRU5ErkJggg==

Step 5 – Now open the database.

ALTER DATABASE OPEN;

P2ktcAAAAASUVORK5CYII=

 

Conclusion

Hope this will be a helpful document for you to consider while resolving the error ora-10873.

Leave a Comment

Your email address will not be published. Required fields are marked *