ORA-01196: file 1 is inconsistent due to a failed media recovery session

柔光的暖阳◎ 2023-06-27 03:14 110阅读 0赞

在Oracle RAC物理备库启动的时候报如下错误：

  1. SQL> startup
  2. ORACLE instance started.
  4. Total System Global Area  839282688 bytes
  5. Fixed Size            2217992 bytes
  6. Variable Size          574621688 bytes
  7. Database Buffers      255852544 bytes
  8. Redo Buffers            6590464 bytes
  9. Database mounted.
  10. ORA-10458: standby database requires recovery
  11. ORA-01196: file 1 is inconsistent due to a failed media recovery session
  12. ORA-01110: data file 1: '+DATA/phydb/datafile/system.259.1028135687'

解决方法为：

  1. SQL> shutdown immediate;
  2. ORA-01109: database not open
  5. Database dismounted.
  6. ORACLE instance shut down.
  7. SQL> startup mount; 
  8. ORACLE instance started.
  10. Total System Global Area  839282688 bytes
  11. Fixed Size            2217992 bytes
  12. Variable Size          574621688 bytes
  13. Database Buffers      255852544 bytes
  14. Redo Buffers            6590464 bytes
  15. Database mounted.
  16. SQL>  alter database recover managed standby database using current logfile disconnect from session;
  18. Database altered.
  20. SQL> alter database recover managed standby database cancel;
  22. Database altered.
  24. SQL> alter database open;
  26. Database altered.

发表评论

表情：
评论列表 （有 0 条评论，110人围观）

还没有评论，来说两句吧...

相关阅读