Database Administration (MOSC)

MOSC Banner

dr log process is coming closed in v$managed_standby

edited Feb 13, 2014 12:00PM in Database Administration (MOSC) 7 commentsAnswered

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

---------- --------- ------------ ----------

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center