Shulou(Shulou.com)05/31 Report--

This article is about how to check whether DG is a real-time application in the database. Xiaobian thinks it is quite practical, so share it with everyone for reference. Let's follow Xiaobian and have a look.

When doing DG of a certain business system, it is found that DG extraction is wrong, check DG status and find that it switches twice a day. Read only, application

Select database_role,switchover_status from v$database;

select protection_mode,protection_level from v$database;

Select process, status, thread#,sequence#, block#, blocks from v$managed_standby;

Select recovery_mode from v$archive_dest_status;

View archive logs lost during backup apply redo select * from v$archive_gap;

See also v$archive_dest_status:

Reserve:

SQL > select DEST_NAME , STATUS , RECOVERY_MODE from v$archive_dest_status

DEST_NAME STATUS RECOVERY_MODE

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

LOG_ARCHIVE_DEST_1 VALID MANAGED REAL TIME APPLY

LOG_ARCHIVE_DEST_2 VALID IDLE

Master Library:

15:30:25 SQL> select DEST_NAME , STATUS , RECOVERY_MODE from v$archive_dest_status;

DEST_NAME STATUS RECOVERY_MODE

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

LOG_ARCHIVE_DEST_1 VALID IDLE

LOG_ARCHIVE_DEST_2 VALID MANAGED REAL TIME APPLY

Summary: Whether it is the main library or the backup library:

recover_mode is MANAGED REAL TIME APPLY is real-time application; is MANAGED is non-real-time application.

See also: v$managed_standby

Reserve:

15:24:23 SQL> select process ,status , sequence# from v$managed_standby;

PROCESS STATUS SEQUENCE#

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

ARCH CONNECTED 0

ARCH CONNECTED 0

ARCH CONNECTED 0

ARCH CLOSING 18

RFS IDLE 0

RFS IDLE 19

MRP0 APPLYING_LOG 19

Master Library:

15:30:53 SQL> select process, status, sequence# from v$managed_standby;

PROCESS STATUS SEQUENCE#

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

ARCH CLOSING 15

ARCH CLOSING 15

ARCH CLOSING 16

ARCH CLOSING 18

LNS WRITING 19

SQL> select process, status, sequence# from v$managed_standby;

PROCESS STATUS SEQUENCE#

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

ARCH CLOSING 1530

ARCH CLOSING 1531

LGWR WRITING 1532

Summary: From v$managed_standby,

MRP process STATUS is APPLYING_LOG is real-time application, or LNS process is WRITING is real-time reference;

Standby MRP process STATUS is WAIT_FOR_LOG non-real-time application, or main library LGWR or archiving process is WRITING non-real-time reference;(real-time application uses LNS process to send logs, non-real-time application uses LGWR or ARCH process to send logs)

Thank you for reading! About "how to check whether DG is a real-time application in the database" this article is shared here, I hope the above content can be of some help to everyone, so that everyone can learn more knowledge, if you think the article is good, you can share it to let more people see it!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.