cancel
Showing results for 
Search instead for 
Did you mean: 

SAP Oracle system replication status like HANA 2.0

danielsapbasis
Participant
0 Kudos
338

Hi Experts,

How to find the system replication status of Oracle 19.1 like HANA 2.0 using HANA studio...to know the DR set up

Are there any specific commands for Oracle database?

Pleas share.

Thanks in advance

Accepted Solutions (1)

Accepted Solutions (1)

janos_mucsi-besze
Product and Topic Expert
Product and Topic Expert
0 Kudos

Here are some DB queries for you information:

PRIMARY:

SQL> select * from V$ARCHIVE_DEST_STATUS;

SQL> select DEST_ID,DEST_NAME,STATUS,DESTINATION,STANDBY_LOGFILE_COUNT,STANDBY_LOGFILE_ACTIVE,ARCHIVED_THREAD#,ARCHIVED_SEQ#,APPLIED_THREAD#,APPLIED_SEQ#,ERROR from v$archive_dest_status where DEST_ID in ('1','2');

SQL> select * from V$ARCHIVED_LOG;

SQL> select NAME,THREAD#,SEQUENCE#,FIRST_CHANGE#,NEXT_CHANGE#,STANDBY_DEST,ARCHIVED,APPLIED from v$archived_log;

SQL> select * from V$LOG;

STANDBY:

SQL> select * from V$ARCHIVED_LOG;

SQL> select NAME,THREAD#,SEQUENCE#,FIRST_CHANGE#,NEXT_CHANGE#,STANDBY_DEST,ARCHIVED,APPLIED from v$archived_log;

SQL> select * from V$LOG_HISTORY;

danielsapbasis
Participant
0 Kudos

Hi Janos,

Please let me know the commands to check the HA and DR system information.

Replication and operation mode.

Thanks in advance

Answers (2)

Answers (2)

danielsapbasis
Participant
0 Kudos

Hi Janos,

Please let me know the commands to check the HA and DR system information.from Primary database server.

Replication and operation mode too.

Thanks in advance

janos_mucsi-besze
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi Daniel,

You could use for example DGMGRL Utility to get the status of the Configuration with command "SHOW CONFIGURATION", but there are the V$ views inside the database. Like V$LOG and V$ARCHIVED_LOG.

In any case if there is a problem with the "replication" / "log shipping", Oracle Alert Log notifies you. Also our built in functions by BRCONNECT lists the errors visible in Alert Log, so any "brconnect -f check" will contain the error too.