How to fix the Oracle error ORA-16156: LGWR archive log dependency not allowed if database is standby protected?

In this post, you’ll learn more about the Oracle ErrorORA-16156: LGWR archive log dependency not allowed if database is standby protected with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-16156: LGWR archive log dependency not allowed if database is standby protected

Reason for the Error ORA-16156: LGWR archive log dependency not allowed if database is standby protected

The use of a LGWR archive log dependency is not allowed when the primary is protected by a standby database, as this requires use of the standby redo log files.

How to fix the Error ORA-16156: LGWR archive log dependency not allowed if database is standby protected ?

You can fix this error in Oracle by following the below steps

Remove the LGWR archive log dependency and use normal LGWR archival instead.