My Oracle Support Banner

SRL(Standby redo log ) Files Are Not getting Used On Physical Standby Database even though they are Configured. (Doc ID 2747195.1)

Last updated on JANUARY 27, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

 

SELECT dest_id, database_mode, recovery_mode, protection_mode, standby_logfile_count, standby_logfile_active FROM v$archive_dest_status WHERE destination IS NOT NULL;

DEST_ID DATABASE_MODE RECOVERY_MODE PROTECTION_MODE STANDBY_LOGFILE_COUNT STANDBY_LOGFILE_ACTIVE
1 OPEN IDLE MAXIMUM PERFORMANCE 0 0
2 OPEN_READ-ONLY MANAGED REAL TIME APPLY MAXIMUM PERFORMANCE 16 0

 

Standby v$standby_log and alert log doesnot show SRL is used

SQL> select thread#, group#, bytes, status from v$standby_log order by thread#, group#;

  THREAD# GROUP# BYTES STATUS
---------- ---------- ---------- ------------------------------
  1 511 52428800 UNASSIGNED   =====================================> Unassigned
  1 512 52428800 UNASSIGNED
  1 513 52428800 UNASSIGNED
  2 521 52428800 UNASSIGNED
  2 522 52428800 UNASSIGNED
  2 523 52428800 UNASSIGNED
 

 

 

Command used for 11g :- 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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