2 Replies Latest reply on Oct 19, 2018 7:24 AM by Mdumala

    Archiving redo log on standby

    Mdumala

      Hello Guys

       

       

      I have questions about archiving logs in standby database.

       

       

       

      My current config is

       

       

       

      Primary database (SID = prod)

      Standby database (SID = prodstb)

       

      OPEN_MODE
      DATABASE_ROLECONTROLFILE_TYPE
      READ ONLY WITH APPLYPHYSICALSTANDBY

       

                           

      Primary have params like :

       

       

       

       

      log_archive_dest_1 string LOCATION=use_db_recovery_file_

       

       

      dest VALID_FOR=(ALL_LOGFILES,A

       

       

      LL_ROLES) DB_UNIQUE_NAME=prod

       

       

       

       

       

      log_archive_dest_2 string service="prodstb", ASYNC NOAFF

       

       

      IRM delay=0 optional compressi

       

       

      on=disable max_failure=0 max_c

       

       

      onnections=1 reopen=300 db_uni

       

       

      que_name="prodstb" net_timeout

       

       

      =30, valid_for=(online_logfile,all_roles)

       

       

       

      And standby :

       

       

       

       

      log_archive_dest_1 string LOCATION=use_db_recovery_file_

       

       

      dest VALID_FOR=(ALL_LOGFILES,A

       

       

      LL_ROLES) DB_UNIQUE_NAME=prodstb,all_roles)

       

       

       

       

      Everything works fine with transport and applying but when i look in v$archived log on standby database i see rows like :

       

       

       

       

       

      select dest_id,creator,sequence# from v$archived_log  
      order by sequence# asc;  
      

       

       

       

       

       

       

      2 LGWR 29

      1 ARCH 30

      2 LGWR 31

      1 ARCH 32

      2 LGWR 33

      1 ARCH 34

      2 LGWR 35

      1 ARCH 36

      2 ARCH 37

      1 ARCH 38

      1 ARCH 39

      1 ARCH 40

       

       

       

      My questions are :

       

      • Why  i'm seeing LWGR as process which creates my archive logs? Not to mention that is show log_archive_dest_2 which doesnt expis in standby.
      • Why it shows ARCH with log_archive_dest_2 its make no sense to me.

       

       

      If anything more is need please let me know.

       

      Regards