Oracle Windows

ORA-01156 when adding standy redo log in dataguard configuration

1 min read

Oct 11, 2016

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.

← Rejoining a Node to MySQL's InnoDB cluster

Enabling achivelog mode in 12c RAC database →

Get Email Notifications

No Comments Yet

Let us know what you think

ORA-01156 when adding standy redo log in dataguard configuration

Share this

You May Also Like

ORA-00274 after upgrade to 19c and trying to enable a delay on recovery for standby database.

Oracle Database 12c: Network Recovery in RMAN

How to test an Oracle database upgrade using a physical standby

Get Email Notifications

No Comments Yet