Shulou(Shulou.com)05/31 Report--

This article mainly introduces "how to solve the database ORA-10873 fault". In the daily operation, I believe that many people have doubts about how to solve the database ORA-10873 fault problem. The editor consulted all kinds of information and sorted out simple and easy-to-use operation methods. I hope it will be helpful for you to answer the doubt of "how to solve the database ORA-10873 fault"! Next, please follow the editor to study!

The following error is reported when opening the library

Click (here) to collapse or open

Errors in file / u01/app/oracle/diag/rdbms/mgkdb/mgkdb/trace/mgkdb_ora_3062.trc:

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

ORA-01110: data file 1:'/ u01 *

ORA-10873 signalled during: alter database open...

Query backup status

Click (here) to collapse or open

SQL > select * from V$BACKUP

FILE# STATUS CHANGE# TIME

--

1 ACTIVE 534855 30-JUN-18

2 ACTIVE 524860 30-JUN-18

3 ACTIVE 524865 30-JUN-18

4 ACTIVE 534870 30-JUN-18

5 ACTIVE 534870 30-JUN-18

6 ACTIVE 554875 30-JUN-18

7 ACTIVE 554875 30-JUN-18

8 ACTIVE 554881 30-JUN-18

End backup

Click (here) to collapse or open

SQL > alter database end backup

Click (here) to collapse or open

SQL > select * from V$BACKUP

FILE# STATUS CHANGE# TIME

--

1 INACTIVE 534855 30-JUN-18

2 INACTIVE 524860 30-JUN-18

3 INACTIVE 524865 30-JUN-18

4 INACTIVE 534870 30-JUN-18

5 INACTIVE 534870 30-JUN-18

6 INACTIVE 554875 30-JUN-18

7 INACTIVE 554875 30-JUN-18

8 INACTIVE 554881 30-JUN-18

This error is mainly due to the fact that there is an expdp backup script in the task plan, which is not finished before shutdown.

At this point, the study on "how to solve the database ORA-10873 failure" is over. I hope to be able to solve everyone's doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.