dr log process is coming closed in v$managed_standby
When I run below query in production (primary) below is result:
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /port01_arch/archive/law81/
Oldest online log sequence 96016
Next log sequence to archive 96030
Current log sequence 96030
SQL> select SEQUENCE#,PROCESS,STATUS,PID from v$managed_standby;
SEQUENCE# PROCESS STATUS PID
---------- --------- ------------ ----------
96026 ARCH CLOSING 78498
96023 ARCH CLOSING 95970
96025 ARCH CLOSING 95292
96029 ARCH CLOSING 132002
96028 ARCH CLOSING 105262
96021 ARCH CLOSING 102386
96027 ARCH CLOSING 104712
When I run in DR (standby) below is the output:
SQL> select SEQUENCE#,PROCESS,STATUS,PID from v$managed_standby;
SEQUENCE# PROCESS STATUS PID
---------- --------- ------------ ----------