Pythian Blog: Technical Track

ORA-01156 when adding standy redo log in dataguard configuration

by Fahd Mirza on Oct 11, 2016 12:00:00 AM

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.
Topics: Oracle Windows Technical Track

No Comments Yet

Let us know what you think

See all

See all

Subscribe by email
Follow us
Love Your Data
Pythian Logo

© 2024 All rights reserved.