ORA-10873 故障解决
打开库的时候报如下错误
查询备份情况
结束备份
产生此错误主要是由于任务计划里面有一个expdp备份脚本，关机之前未备份完导致
点击(此处)折叠或打开
-
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/app/oracle/oradata/mgkdb/system01.dbf'
- ORA-10873 signalled during: alter database 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
结束备份
点击(此处)折叠或打开
- SQL> alter database end backup;
点击(此处)折叠或打开
-
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
产生此错误主要是由于任务计划里面有一个expdp备份脚本，关机之前未备份完导致
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/24486203/viewspace-2157174/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
