Home » RDBMS Server » Server Administration » dataguard server (physical standby) (Sun Solaris , 12c (12.1.0.1.0))
dataguard server (physical standby) [message #668523] Wed, 28 February 2018 01:00 Go to next message
daulat01
Messages: 62
Registered: May 2011
Location: Delhi
Member
Hello Dear,

I am new into Datagurad technology , I have some confusion.Please help
@Primary
SQL> select max(sequence#) from v$log_history;

MAX(SEQUENCE#)
--------------
        471983

@standby
SQL> select max(sequence#) from v$log_history;

MAX(SEQUENCE#)
--------------
        471911

@standby
SQL> select LOW_SEQUENCE#, HIGH_SEQUENCE# from V$ARCHIVE_GAP ;

no rows selected

SQL> select name , value from V$DATAGUARD_STATS where name like '%lag';

NAME                             VALUE
-------------------------------- ----------------------------------------------------------------
transport lag                    +00 00:08:43
apply lag                        +00 06:29:31

Can you please let me know , my dataguard is in sync with primary or not because there is no V$ARCHIVE_GAP ; but V$DATAGUARD_STATS shows lag time. Can you please let me know what I should do in this case.

Thanks,
Re: dataguard server (physical standby) [message #668524 is a reply to message #668523] Wed, 28 February 2018 01:24 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Please use [code] tags in your posts. You have been asked to do this before. Also I notice that you never responded to replies to your previous question, http://www.orafaq.com/forum/m/668392/#msg_668392 which makes me wonder if you are interested in what I say.

In this case, you need to query v$managed_standby to see what is going on.

Re: dataguard server (physical standby) [message #668625 is a reply to message #668524] Wed, 07 March 2018 06:15 Go to previous messageGo to next message
daulat01
Messages: 62
Registered: May 2011
Location: Delhi
Member
Thanks for you support. I have started the listener & MRP process then Issue was resolved.
Re: dataguard server (physical standby) [message #669280 is a reply to message #668523] Wed, 11 April 2018 20:46 Go to previous message
rainy
Messages: 1
Registered: March 2018
Junior Member
I think create a test table and check on standby is one good method!
Previous Topic: ORA-27369: job of type EXECUTABLE failed with exit code: Permission denied
Next Topic: ORA-28040: No matching authentication protocol error on fresh installation of Oracle 12c
Goto Forum:
  


Current Time: Thu Mar 28 06:06:15 CDT 2024