[DataGuard] ORA-01153: an incompatible media recovery is active 해결

OS환경 : Oracle Linux6.8(64bit)

DB 환경 : Oracle Database 12.2.0.1 Active Data Guard

에러 : ADG 환경에서 standby db에 flashback 적용시 에러

#adg2는 바로 적용이 안됨

SQL> alter database flashback on;

alter database flashback on

*

ERROR at line 1:

ORA-01153: an incompatible media recovery is active

해결 방법 : switchover 후 adg2를 active db로 변경 후 적용

#adg2도 적용해주기위해 switchover 진행

노드1

$ dgmgrl sys/oracle

DGMGRL> switchover to adg2

Performing switchover NOW, please wait...

Operation requires a connection to database "adg2"

Connecting ...

Connected to "adg2"

Connected as SYSDBA.

New primary database "adg2" is opening...

Operation requires start up of instance "adg1" on database "adg1"

Starting instance "adg1"...

ORACLE instance started.

Database mounted.

Database opened.

Connected to "adg1"

Switchover succeeded, new primary is "adg2"

#switchover 후 재 적용

노드2

$ sqlplus / as sysdba

SQL> select flashback_on from v$database;

FLASHBACK_ON

------------------

NO

SQL> alter database flashback on;

Database altered.

#다시 switchover로 원상복구

노드1

$ dgmgrl sys/oracle

DGMGRL> switchover to adg1

Performing switchover NOW, please wait...

New primary database "adg1" is opening...

Operation requires start up of instance "adg2" on database "adg2"

Starting instance "adg2"...

ORACLE instance started.

Database mounted.

Database opened.

Connected to "adg2"

Switchover succeeded, new primary is "adg1"

#양쪽 모두 flashback 상태 확인

노드1

SQL> select flashback_on from v$database;

FLASHBACK_ON

------------------

YES

노드2

SQL> select flashback_on from v$database;

FLASHBACK_ON

------------------

YES

원인 : standby db는 read only이기 때문에 적용이 안됨

참조 :