on 2023 Oct 13 3:26 PM
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
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;
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
79 | |
10 | |
9 | |
7 | |
6 | |
6 | |
6 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.