Troubleshooting Standby database recover failed with ORA-19906 ORA-10576 ORA-19909

  • 2024/01/08
  • ORACLE 9i-23ai
  • 170 views
  • Troubleshooting Standby database recover failed with ORA-19906 ORA-10576 ORA-19909已关闭评论

常常有客户配置oracle dataguard 1对多或级连(cascade) standby， 当需要一个测试环境时，通常考虑拿一个standby激活或snapshot dg，但如果在激活为可读写数据库时(Failover)，如果提前DG参数没有清理，可能导致剩余standby database无法继续应用日志，这里简单记录。

, , ,

阅读全文

Troubleshooting ORA-01578 ORA-01110 ORA-26040 NOLOGGING corrupted block

  • 2020/05/20
  • Cloud, ORACLE 9i-23ai
  • 2,475 views
  • Troubleshooting ORA-01578 ORA-01110 ORA-26040 NOLOGGING corrupted block已关闭评论

The following errors have recently occurred in our database( Oracle 19c RAC):
ORA-01578: ORACLE data block corrupted (file # xxx, block # yyyyy)
ORA-01110: data file xxx: ‘xxxxxxxxxxxxxxxxx.dbf’
ORA-26040: Data block was loaded using the NOLOGGING option

, , , ,

阅读全文

如何修复ORA-01111, ORA-01110, ORA-01157 errors on Standby database

  • 2016/08/15
  • ORACLE 9i-23ai
  • 22 views
  • 如何修复ORA-01111, ORA-01110, ORA-01157 errors on Standby database已关闭评论

在oracle DATAGUARD环境，STANDBY_FILE_MANAGEMENT 参数控制standby […]

, , ,

阅读全文