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 laterInformation in this document applies to any platform.
Symptoms
- Standby redo log files are Not getting used on Standby even though they have been Configured.
- SRL physically exist at ASM/Filesystem level
- Thread# is not Zero for the SRL
- Primary and Standby are in Sync and its shows using real time apply
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
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 |