Hi,
I have a primary ( PRIMARYP ) and 2 standbys - 1 physical standby ( STANDBYP ) and 1 logical standby ( STANDBYL )
When I converted STANDBYL from physical to logical, a couple of new directories appeared under my FRA i.e. ONLINELOG and FOREIGN_ARCHIVELOG. Currently ONLINELOG is empty
My LOG_ARCHIVE_DEST_ID's on my STANDBYL are as such
log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ONLINE_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=standbyl'
log_archive_dest_2='SERVICE=primaryp ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=primaryp'
log_archive_dest_3='SERVICE=standbyp ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=standbyp'
log_archive_dest_4='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(STANDBY_LOGFILES,STANDBY_ROLE) DB_UNIQUE_NAME=standbyl'
I can see that DEST_4 created the FOREIGN_ARCHIVELOG and is placing the primary archive logs in it ( so not to possibly overwrite the archive logs of STANDBYL itself, now going into DEST_1 )
Q1. However I assume that ONLINELOG is being created by DEST_3 and the reason it is empty is because the FAL has been able to get all the archive logs from the primary ?
Q2. Would I ever expect to see anything under DEST_3 in these circumstances eg -
If the FAL was unable to get an archive from the Primary but was able to get it from STANDBYP - would the retried archive log go into ONLINELOG or FOREIGN_ARCHIVELOG ?
Q3. If STANDBYP became primary would in STANDBYL, the archive logs go into ONLINELOGS or FOREIGN_ARCHIVELOG ?
any clarity appreciated
thanks, Jim