[Solved] Issue: SWITCHOVER VERIFY: Online Redo Logfile 1 requires clearing

Ambiente primary:

SQL> SELECT NAME,OPEN_MODE,DATABASE_ROLE FROM V$DATABASE;
 
NAME      OPEN_MODE            DATABASE_ROLE
--------- -------------------- ----------------
CORTEX    READ WRITE           PRIMARY
 
SQL> SHO PARAMETER UNIQUE
 
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_unique_name                       string      cortexDR

Ambiente physical standby:

SQL> SELECT NAME,OPEN_MODE,DATABASE_ROLE FROM V$DATABASE;
 
NAME      OPEN_MODE            DATABASE_ROLE
--------- -------------------- ----------------
CORTEX    MOUNTED              PHYSICAL STANDBY
 
SQL> SHO PARAMETER UNIQUE
 
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_unique_name                       string      cortex

Ao tentar realizar o comando de verify, um warning é reportado:

SQL> ALTER DATABASE SWITCHOVER TO cortex VERIFY;
ALTER DATABASE SWITCHOVER TO cortex VERIFY
*
ERROR at line 1:
ORA-16475: succeeded with warnings, check alert log for more details

No alert temos:

ALTER DATABASE SWITCHOVER TO cortex VERIFY
2021-04-18T04:57:36.424612-03:00
SWITCHOVER VERIFY: Send VERIFY request to switchover target CORTEX
SWITCHOVER VERIFY WARNING: switchover target has dirty online redo logfiles that require clearing. It takes time to clear online redo logfiles. This may slow down switchover process.
ORA-16475 signalled during: ALTER DATABASE SWITCHOVER TO cortex VERIFY...

O Oracle Note “12c Data guard Switchover Best Practices using SQLPLUS (Doc ID 1578787.1)” (Link AQUI) nos traz uma pista do problema:

Validando que meu standby não possui o parâmetro preenchido:

SQL> SELECT NAME,OPEN_MODE,DATABASE_ROLE FROM V$DATABASE;
 
NAME      OPEN_MODE            DATABASE_ROLE
--------- -------------------- ----------------
CORTEX    MOUNTED              PHYSICAL STANDBY
 
SQL> show parameter log_file_name_convert;
 
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_file_name_convert                string

Inserindo os valores apropriados do parâmetro do standby:

SQL> ALTER SYSTEM SET log_file_name_convert='+DG_DATA/CORTEXDR','+DG_DATA/CORTEX','+DG_FRA/CORTEXDR','+DG_FRA/CORTEX' SCOPE=SPFILE;
 
System altered.
 
SQL> SHU IMMEDIATE;
ORA-01109: database not open
 
 
Database dismounted.
ORACLE instance shut down.
SQL> STARTUP MOUNT;
ORACLE instance started.
 
Total System Global Area 2583690520 bytes
Fixed Size                  8899864 bytes
Variable Size             553648128 bytes
Database Buffers         2013265920 bytes
Redo Buffers                7876608 bytes
Database mounted.

Agora o comando de verify é realizado com sucesso, sem nenhuma consideração a ser tratada:

SQL> ALTER DATABASE SWITCHOVER TO cortex VERIFY;
 
Database altered.

2021-04-18T05:11:49.530419-03:00
ALTER DATABASE SWITCHOVER TO cortex VERIFY
2021-04-18T05:11:53.226049-03:00
SWITCHOVER VERIFY: Send VERIFY request to switchover target CORTEX
2021-04-18T05:11:56.635946-03:00
SWITCHOVER VERIFY COMPLETE: READY FOR SWITCHOVER
Completed: ALTER DATABASE SWITCHOVER TO cortex VERIFY

Leave a Comment Cancel Reply