SAP Knowledge Base Article - Preview

3060576 - ORA-01156 happens when creating standby redo log

Symptom

When creating standby redo log in standby database, the ORA-01156 error happens:

SQL> ALTER DATABASE ADD STANDBY LOGFILE THREAD 1 GROUP 5 SIZE 50M;
ALTER DATABASE ADD STANDBY LOGFILE THREAD 1 GROUP 5 SIZE 50M
*
ERROR at line 1:
ORA-01156: recovery or flashback in progress may need access to files


Read more...

Keywords

ORA-01156, dataguard, primary,standby , KBA , BC-DB-ORA , Oracle , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.