ADG Enviornment Control File Sequence Number Jumpt Sharply After Switchover (Doc ID 2911850.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

•  The control file sequence number of newly create ADG Standby db environment jumpt significantly after switchover.
  2022/9/8 19:26 <HOST_NAME> Oracle_Control_File_Sequence_Number 5567026
  2022/9/9 19:26 <HOST_NAME> Oracle_Control_File_Sequence_Number 5578806
  2022/9/10 19:28 <HOST_NAME> Oracle_Control_File_Sequence_Number 5590252
  2022/9/11 19:12 <HOST_NAME> Oracle_Control_File_Sequence_Number 5600115
  2022/9/12 19:13 <HOST_NAME> Oracle_Control_File_Sequence_Number 5610080
  2022/9/13 19:13 <HOST_NAME> Oracle_Control_File_Sequence_Number 5620198
  2022/9/14 19:11 <HOST_NAME> Oracle_Control_File_Sequence_Number 5631312
  2022/9/15 19:12 <HOST_NAME> Oracle_Control_File_Sequence_Number 5642542
  2022/9/16 20:21 <HOST_NAME> Oracle_Control_File_Sequence_Number 5653865
  2022/9/17 19:53 <HOST_NAME> Oracle_Control_File_Sequence_Number 5665242 <<<<<<<<<<<<<<<<<<<<<<
  2022/9/18 19:39 <HOST_NAME> Oracle_Control_File_Sequence_Number 1115670338 <<<<<<<<<<<<<<<<<<<<<<
  2022/9/19 19:36 <HOST_NAME> Oracle_Control_File_Sequence_Number 1115679278
  2022/9/20 20:22 <HOST_NAME> Oracle_Control_File_Sequence_Number 1115689872

   

• Customer monitor the controlfile sequence# by following query:
  set numwidth 15
  select max(FHCSQ) from x$kcvfh;

   

• Test log:  

  On Primary ORCL：

  SQL> select max(FHCSQ)
  from x$kcvfh; 2

  MAX(FHCSQ)
  ---------------
  1111997538

  On Standby ORCLS：

  SQL> select max(FHCSQ)
  from x$kcvfh; 2

  MAX(FHCSQ)
  ---------------
  1

  On Primary ORCL Execute：

  ALTER DATABASE SWITCHOVER TO ORCLS;

  On New Standby ORCL：

  SQL> select max(FHCSQ)
  from x$kcvfh; 2

  MAX(FHCSQ)
  ---------------
  1

  On New Primary ORCLS：

  SQL> select max(FHCSQ)
  from x$kcvfh; 2

  MAX(FHCSQ)
  ----------
  1119670520

  On New Primary ORCLS Execute：

  ALTER DATABASE SWITCHOVER TO ORCL;

  On New Primary ORCL：

  SQL> select max(FHCSQ)
  from x$kcvfh; 2

  MAX(FHCSQ)
  ---------------
  1119675250

  On New Standby ORCLS：

  SQL> select max(FHCSQ)
  from x$kcvfh; 2

  MAX(FHCSQ)
  ----------
  1

   

Changes

 ADG Switchover

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.