ORA-01156 when adding standy redo log in dataguard configuration

Posted in: Oracle, Technical Track

Database version = 11.2.0.3.0

If you get following error while adding a Standby Redo Log (SRL) to a standby database in dataguard configuration:

SQL> alter database add standby logfile group 3 ‘/logs/test/sbyredo3a.log’ size 500M;
alter database add standby logfile group 3 ‘/logs/test/sbyredo3a.log’ size 500M
*
ERROR at line 1:
ORA-01156: recovery or flashback in progress may need access to files

Then it means that first you have to stop the redo apply, add the SRL and then start the redo apply. Best way to do is from dgmgrl like this:

DGMGRL> connect /
Connected.

DGMGRL> edit database ‘test’ set state=’APPLY-OFF’;
Succeeded.

SQL> alter database add standby logfile group 3 ‘/logs/test/sbyredo3a.log’ size 500M;

Database altered.

DGMGRL> edit database ‘CONPRO_UK’ set state=’APPLY-ON’;
Succeeded.

HTH.

email

Author

Want to talk with an expert? Schedule a call with our team to get the conversation started.

About the Author

I have been in love with Oracle blogging since 2007. This blogging, coupled with extensive participation in Oracle forums, plus Oracle related speaking engagements, various Oracle certifications, teaching, and working in the trenches with Oracle technologies has enabled me to receive the Oracle ACE award. I was the first ever Pakistani to get that award. From Oracle Open World SF to Foresight 20:20 Perth. I have been expressing my love for Exadata. For the last few years, I am loving the data at Pythian, and proudly writing their log buffer carnivals.

No comments

Leave a Reply

Your email address will not be published. Required fields are marked *