OraFAQ Forum: Data Guard » RAC

Home » Server Options » Data Guard » RAC - DG (Red Hat Enterprise Linux Server release 5.8 (Tikanga))

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

RAC - DG [message #671051]

Mon, 13 August 2018 05:32

dirish
Messages: 232
Registered: November 2006

Senior Member

We have a 2 Node RAC on Dataguard. Log files are being shipped but not applied.

From Primary Node 1

SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /archive/mtmeddb
Oldest online log sequence     233073
Next log sequence to archive   233083
Current log sequence           233083

From Primary Node 2

SQL> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /archive/mtmeddb
Oldest online log sequence     118877
Next log sequence to archive   118880
Current log sequence           118880

From Standby Database

   INST_ID PROCESS   STATUS          THREAD#  SEQUENCE#     BLOCK#     BLOCKS
---------- --------- ------------ ---------- ---------- ---------- ----------
         1 ARCH      CONNECTED             0          0          0          0
         1 ARCH      CONNECTED             0          0          0          0
         1 ARCH      CONNECTED             0          0          0          0
         1 ARCH      CONNECTED             0          0          0          0
         1 RFS       IDLE                  0          0          0          0
         1 RFS       IDLE                  1     233083     480820          2
         1 RFS       IDLE                  0          0          0          0
         1 RFS       IDLE                  0          0          0          0
         1 MRP0      WAIT_FOR_LOG          2     118441          0          0

Report message to a moderator

[Message index]

		RAC - DG By: dirish on Mon, 13 August 2018 05:32
		Re: RAC - DG By: dirish on Mon, 13 August 2018 05:34
		Re: RAC - DG By: John Watson on Mon, 13 August 2018 05:36
		Re: RAC - DG By: dirish on Mon, 13 August 2018 05:47
		Re: RAC - DG By: John Watson on Mon, 13 August 2018 05:50
		Re: RAC - DG By: dirish on Mon, 13 August 2018 05:59
		Re: RAC - DG By: John Watson on Mon, 13 August 2018 06:01

Previous Topic:	RMAN and Dataguard
Next Topic:	Error: ORA-12154 when add standby

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 12:32:26 CDT 2024