How to resolve archivelog gap (ORA-10458: standby database requires recovery ORA-01152: file 1 was not restored from a sufficiently old backup ORA-01110: data file 1: '/u01/app/oracle/oradata/DB2/datafile/o1_mf_system_lkrj2wxr_.dbf' )

# Check DB Name and Database role both DC & DR

SELECT NAME,
OPEN_MODE,
DATABASE_ROLE
FROM v$database;

# Check current status of database environment

SELECT client_process, 
       process, 
       sequence#, 
       status 
FROM v$managed_standby;

# Check error in data guard environment

COLUMN DEST_NAME FORMAT a30

COLUMN ERROR FORMAT a25

SELECT DEST_NAME,
       STATUS,
       DATABASE_MODE,
       ARCHIVED_SEQ#,
       APPLIED_SEQ#,
       ERROR,
       GAP_STATUS
  FROM v$archive_dest_status
 WHERE dest_id < 3

# Missing archivelog files

COLUMN SEQUENCE# FORMAT 999999

COLUMN THREAD# FORMAT 99

COLUMN NAME FORMAT A100

SELECT SEQUENCE#, THREAD#, NAME, ARCHIVED, APPLIED, DELETED
FROM   v$archived_log

# Make dericetory on standby side and transfer to scp command 

mkdir archivelog_missing

scp /u01/app/oracle/fast_recovery_area/DB1/archivelog/2025_02_06/o1_mf_1_17_mt9glxvc_.arc /u01/app/oracle/fast_recovery_area/DB1/archivelog/2025_02_06/o1_mf_1_18_mt9gm16k_.arc oracle@db2:/u02/archivelog_missing

# Run the register command

alter database register logfile '/u02/archivelog_missing/o1_mf_1_10_mt6fgc9n_.arc'  

alter database register logfile '/u02/archivelog_missing/o1_mf_1_14_mt92mgs0_.arc'  

alter database register logfile '/u02/archivelog_missing/o1_mf_1_18_mt9gm16k_.arc' 

# CANCEL MEDIA RECOVERY PROCESS

 alter database recover managed standby database cancel;

 alter database recover managed standby database nodelay disconnect;

# ERROR at line 1:

# ORA-16136: Managed Standby Recovery not active

# ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

# on The Primary Side

SQL> alter system switch logfile; 

OR 

SQL> startup 

ORACLE instance started. 

Total System Global Area 1795159104 bytes 

Fixed Size 

8897600 bytes 

Variable Size 

419430400 bytes 

Database Buffers 

1358954496 bytes 

Redo Buffers 

7876608 bytes 

Database mounted. 

ORA-10458: standby database requires recovery 

ORA-01152: file 1 was not restored from a sufficiently old backup 

ORA-01110: data file 1: 

'/u01/app/oracle/oradata/DB2/datafile/o1_mf_system_lkrj2wxr_.dbf' 

SQL> alter database recover managed standby database disconnect from session; 

Database altered. 

SQL> shut abort 

ORACLE instance shut down. 

SQL> startup 

ORACLE instance started. 

Total System Global Area 1795159104 bytes 

Fixed Size 

8897600 bytes 

Variable Size 

419430400 bytes 

Database Buffers 

1358954496 bytes 

Redo Buffers 

7876608 bytes  

Database mounted. 

Database opened.