1. Mục đích:
2. Setup:
3. Chi tiết
Thứ tự các câu lệnh như bên dưới:1.sys@bill1> ALTER SESSION SET nls_date_format='DD-MON-YYYY HH24:MI:SS';
Session altered.
2.sys@bill1> set linesize 150;
sys@bill1> SELECT NAME, VALUE FROM V$DATAGUARD_STATS WHERE NAME='apply lag';
NAME VALUE
-------------------------------- ----------------------------------------------------------------
apply lag
3.sys@bill1> SELECT PROCESS, CLIENT_PROCESS, THREAD#, SEQUENCE#,STATUS, BLOCK#, BLOCKS FROM Gv$MANAGED_STANDBY order by PROCESS, thread#, SEQUENCE#;
PROCESS CLIENT_P THREAD# SEQUENCE# STATUS BLOCK# BLOCKS
--------- -------- ---------- ---------- ------------ ---------- ----------
ARCH ARCH 0 0 CONNECTED 0 0
ARCH ARCH 0 0 CONNECTED 0 0
ARCH ARCH 0 0 CONNECTED 0 0
ARCH ARCH 0 0 CONNECTED 0 0
ARCH ARCH 0 0 CONNECTED 0 0
ARCH ARCH 0 0 CONNECTED 0 0
ARCH ARCH 0 0 CONNECTED 0 0
ARCH ARCH 0 0 CONNECTED 0 0
ARCH ARCH 0 0 CONNECTED 0 0
ARCH ARCH 0 0 CONNECTED 0 0
ARCH ARCH 0 0 CONNECTED 0 0
ARCH ARCH 0 0 CONNECTED 0 0
ARCH ARCH 0 0 CONNECTED 0 0
ARCH ARCH 0 0 CONNECTED 0 0
ARCH ARCH 0 0 CONNECTED 0 0
ARCH ARCH 0 0 CONNECTED 0 0
MRP0 N/A 1 13558 WAIT_FOR_LOG 0 0
RFS LGWR 1 13558 IDLE 634237 4
RFS LGWR 2 25100 IDLE 2058626 77
19 rows selected.
4.Sequence:
1 13531 23-FEB-2026 08:50:48 23-FEB-2026 08:52:33 23-FEB-2026 08:53:00 YES
2 25074 23-FEB-2026 08:48:18 23-FEB-2026 08:52:36 23-FEB-2026 08:53:03 YES
1 13532 23-FEB-2026 08:52:33 23-FEB-2026 08:53:10 23-FEB-2026 08:53:37 YES
1 13533 23-FEB-2026 08:53:10 23-FEB-2026 08:55:10 23-FEB-2026 08:55:37 YES
1 13534 23-FEB-2026 08:55:10 23-FEB-2026 09:04:28 23-FEB-2026 09:04:56 YES
2 25075 23-FEB-2026 08:52:36 23-FEB-2026 09:04:30 23-FEB-2026 09:04:57 YES
1 13535 23-FEB-2026 09:04:28 23-FEB-2026 09:08:20 23-FEB-2026 09:08:47 YES
1 13536 23-FEB-2026 09:08:20 23-FEB-2026 09:09:02 23-FEB-2026 09:09:29 YES
1 13537 23-FEB-2026 09:09:02 23-FEB-2026 09:10:14 23-FEB-2026 09:10:41 YES
2 25076 23-FEB-2026 09:04:30 23-FEB-2026 09:10:15 23-FEB-2026 09:10:43 YES
1 13538 23-FEB-2026 09:10:14 23-FEB-2026 09:12:26 23-FEB-2026 09:12:53 YES
1 13539 23-FEB-2026 09:12:26 23-FEB-2026 09:12:59 23-FEB-2026 09:13:26 YES
1 13540 23-FEB-2026 09:12:59 23-FEB-2026 09:14:41 23-FEB-2026 09:15:08 YES
2 25077 23-FEB-2026 09:10:15 23-FEB-2026 09:14:43 23-FEB-2026 09:15:10 YES
1 13541 23-FEB-2026 09:14:41 23-FEB-2026 09:17:53 23-FEB-2026 09:18:20 YES
2 25078 23-FEB-2026 09:14:43 23-FEB-2026 09:22:28 23-FEB-2026 09:22:55 YES
1 13542 23-FEB-2026 09:17:53 23-FEB-2026 09:25:02 23-FEB-2026 09:25:29 YES
2 25079 23-FEB-2026 09:22:28 23-FEB-2026 09:28:01 23-FEB-2026 09:28:28 YES
2 25080 23-FEB-2026 09:28:01 23-FEB-2026 09:29:16 23-FEB-2026 09:29:43 YES
2 25081 23-FEB-2026 09:29:16 23-FEB-2026 09:32:46 23-FEB-2026 09:33:13 YES
1 13543 23-FEB-2026 09:25:02 23-FEB-2026 09:32:48 23-FEB-2026 09:33:15 YES
2 25082 23-FEB-2026 09:32:46 23-FEB-2026 09:34:23 23-FEB-2026 09:34:50 YES
2 25083 23-FEB-2026 09:34:23 23-FEB-2026 09:35:32 23-FEB-2026 09:35:59 YES
1 13544 23-FEB-2026 09:32:48 23-FEB-2026 09:46:33 23-FEB-2026 09:47:00 YES
2 25084 23-FEB-2026 09:35:32 23-FEB-2026 09:47:17 23-FEB-2026 09:47:44 YES
1 13545 23-FEB-2026 09:46:33 23-FEB-2026 09:47:31 23-FEB-2026 09:47:57 YES
1 13546 23-FEB-2026 09:47:31 23-FEB-2026 09:51:31 23-FEB-2026 09:51:58 YES
1 13547 23-FEB-2026 09:51:31 23-FEB-2026 09:53:04 23-FEB-2026 09:53:31 YES
2 25085 23-FEB-2026 09:47:17 23-FEB-2026 09:53:05 23-FEB-2026 09:53:32 YES
1 13548 23-FEB-2026 09:53:04 23-FEB-2026 09:54:31 23-FEB-2026 09:54:58 YES
1 13549 23-FEB-2026 09:54:31 23-FEB-2026 09:55:40 23-FEB-2026 09:56:07 YES
2 25086 23-FEB-2026 09:53:05 23-FEB-2026 10:04:15 23-FEB-2026 10:04:42 YES
1 13550 23-FEB-2026 09:55:40 23-FEB-2026 10:04:46 23-FEB-2026 10:05:13 YES
2 25087 23-FEB-2026 10:04:15 23-FEB-2026 10:06:00 23-FEB-2026 10:06:27 YES
2 25088 23-FEB-2026 10:06:00 23-FEB-2026 10:07:30 23-FEB-2026 10:07:57 YES
2 25089 23-FEB-2026 10:07:30 23-FEB-2026 10:13:15 23-FEB-2026 10:13:42 YES
1 13551 23-FEB-2026 10:04:46 23-FEB-2026 10:13:17 23-FEB-2026 10:13:43 YES
2 25090 23-FEB-2026 10:13:15 23-FEB-2026 10:14:57 23-FEB-2026 10:15:24 YES
2 25091 23-FEB-2026 10:14:57 23-FEB-2026 10:16:03 23-FEB-2026 10:16:30 YES
2 25092 23-FEB-2026 10:16:03 23-FEB-2026 10:19:07 23-FEB-2026 10:19:33 YES
1 13552 23-FEB-2026 10:13:17 23-FEB-2026 10:19:08 23-FEB-2026 10:19:35 YES
2 25093 23-FEB-2026 10:19:07 23-FEB-2026 10:22:37 23-FEB-2026 10:23:04 YES
2 25094 23-FEB-2026 10:22:37 23-FEB-2026 10:24:28 23-FEB-2026 10:24:55 YES
2 25095 23-FEB-2026 10:24:28 23-FEB-2026 10:25:10 23-FEB-2026 10:25:37 YES
1 13553 23-FEB-2026 10:19:08 23-FEB-2026 10:25:11 23-FEB-2026 10:25:38 YES
2 25096 23-FEB-2026 10:25:10 23-FEB-2026 10:27:07 23-FEB-2026 10:27:34 YES
1 13554 23-FEB-2026 10:25:11 23-FEB-2026 10:33:24 23-FEB-2026 10:33:50 YES
1 13555 23-FEB-2026 10:33:24 23-FEB-2026 10:34:12 23-FEB-2026 10:34:39 YES
1 13556 23-FEB-2026 10:34:12 23-FEB-2026 10:36:12 23-FEB-2026 10:36:39 YES
2 25097 23-FEB-2026 10:27:07 23-FEB-2026 10:36:13 23-FEB-2026 10:36:40 YES
1 13557 23-FEB-2026 10:36:12 23-FEB-2026 10:42:00 23-FEB-2026 10:42:27 YES
2 25098 23-FEB-2026 10:36:13 23-FEB-2026 10:42:55 23-FEB-2026 10:43:22 NO
2 25099 23-FEB-2026 10:42:55 23-FEB-2026 10:43:52 23-FEB-2026 10:44:19 NO
630 rows selected.
5.sys@bill1> SELECT thread#,sequence#, first_time, completion_time, applied FROM v$archived_log where next_time>sysdate-3 and applied='NO' order by thread#,completion_time ;
THREAD# SEQUENCE# FIRST_TIME COMPLETION_TIME APPLIED
---------- ---------- -------------------- -------------------- ---------
2 25098 23-FEB-2026 10:36:13 23-FEB-2026 10:43:22 NO
2 25099 23-FEB-2026 10:42:55 23-FEB-2026 10:44:19 NO
6.sys@bill1> select thread#,sequence#,completion_time, applied from v$archived_log where sequence# in (select max(sequence#) from v$archived_log where thread#=1);
select thread#,sequence#,completion_time,applied from v$archived_log where sequence# in (select max(sequence#) from v$archived_log where thread#=2);
THREAD# SEQUENCE# COMPLETION_TIME APPLIED
---------- ---------- -------------------- ---------
1 13557 23-FEB-2026 10:42:27 YES
sys@bill1>
THREAD# SEQUENCE# COMPLETION_TIME APPLIED
---------- ---------- -------------------- ---------
2 25099 23-FEB-2026 10:44:19 NO
7.sys@bill1> SELECT ARCH.THREAD# "Thread", ARCH.SEQUENCE# "Last Sequence Received", APPL.SEQUENCE# "Last Sequence Applied",(ARCH.SEQUENCE# - APPL.SEQUENCE#) "Difference" FROM (SELECT THREAD# ,SEQUENCE# FROM V$ARCHIVED_LOG WHERE (THREAD#,FIRST_TIME ) IN (SELECT THREAD#,MAX(FIRST_TIME) FROM V$ARCHIVED_LOG GROUP BY THREAD#)) ARCH, (SELECT THREAD# ,SEQUENCE# FROM V$LOG_HISTORY WHERE (THREAD#,FIRST_TIME ) IN (SELECT THREAD#,MAX(FIRST_TIME) FROM V$LOG_HISTORY GROUP BY THREAD#)) APPL WHERE ARCH.THREAD# = APPL.THREAD# ORDER BY 1 ;
Thread Last Sequence Received Last Sequence Applied Difference
---------- ----------------------- --------------------- ----------
1 13557 13557 0
2 25099 25098 1
8.Minus:
sys@bill1> SELECT NAME, thread#, sequence#, next_time, first_change#, creator, fal, registrar, archived, applied, deleted, TRUNC (blocks * block_size / 1024 / 1024) || 'M' arc FROM v$archived_log WHERE thread# = 1 AND sequence# >= (SELECT MAX (sequence#) FROM v$archived_log WHERE applied = 'YES' AND thread# = 1) and dest_id=2 UNION ALL SELECT NAME, thread#, sequence#, next_time, first_change#, creator, fal, registrar, archived, applied, deleted, TRUNC (blocks * block_size / 1024 / 1024) || 'M' arc FROM v$archived_log WHERE thread# = 2 AND sequence# >= (SELECT MAX (sequence#) FROM v$archived_log WHERE applied = 'YES' AND thread# = 2) and dest_id=2 ORDER BY thread#, sequence# DESC;
NAME
------------------------------------------------------------------------------------------------------------------------------------------------------
THREAD# SEQUENCE# NEXT_TIME FIRST_CHANGE# CREATOR FAL REGISTR ARC APPLIED DEL ARC
---------- ---------- -------------------- ------------- ------- --- ------- --- --------- --- -----------------------------------------
+RECO/bill/archivelog/2026_02_23/thread_1_seq_13558.2427.1225968147
1 13558 23-FEB-2026 10:48:00 1.4530E+13 LGWR NO RFS YES NO NO 532M
+RECO/bill/archivelog/2026_02_23/thread_1_seq_13557.2423.1225967799
1 13557 23-FEB-2026 10:42:00 1.4530E+13 LGWR NO RFS YES YES NO 1249M
+RECO/bill/archivelog/2026_02_23/thread_2_seq_25100.2429.1225968259
2 25100 23-FEB-2026 10:47:58 1.4530E+13 LGWR NO RFS YES NO NO 1261M
+RECO/bill/archivelog/2026_02_23/thread_2_seq_25099.2425.1225968203
2 25099 23-FEB-2026 10:43:52 1.4530E+13 LGWR NO RFS YES NO NO 1297M
+RECO/bill/archivelog/2026_02_23/thread_2_seq_25098.2424.1225967801
2 25098 23-FEB-2026 10:42:55 1.4530E+13 LGWR NO RFS YES NO NO 1277M
+RECO/bill/archivelog/2026_02_23/thread_2_seq_25097.2419.1225967255
2 25097 23-FEB-2026 10:36:13 1.4530E+13 LGWR NO RFS YES YES NO 1081M
9.Seq_
1 13543 23-FEB-2026 09:25:02 23-FEB-2026 09:32:48 YES
2 25082 23-FEB-2026 09:32:46 23-FEB-2026 09:34:23 YES
2 25083 23-FEB-2026 09:34:23 23-FEB-2026 09:35:32 YES
1 13544 23-FEB-2026 09:32:48 23-FEB-2026 09:46:33 YES
2 25084 23-FEB-2026 09:35:32 23-FEB-2026 09:47:17 YES
1 13545 23-FEB-2026 09:46:33 23-FEB-2026 09:47:31 YES
1 13546 23-FEB-2026 09:47:31 23-FEB-2026 09:51:31 YES
1 13547 23-FEB-2026 09:51:31 23-FEB-2026 09:53:04 YES
2 25085 23-FEB-2026 09:47:17 23-FEB-2026 09:53:05 YES
1 13548 23-FEB-2026 09:53:04 23-FEB-2026 09:54:31 YES
1 13549 23-FEB-2026 09:54:31 23-FEB-2026 09:55:40 YES
2 25086 23-FEB-2026 09:53:05 23-FEB-2026 10:04:15 YES
1 13550 23-FEB-2026 09:55:40 23-FEB-2026 10:04:46 YES
2 25087 23-FEB-2026 10:04:15 23-FEB-2026 10:06:00 YES
2 25088 23-FEB-2026 10:06:00 23-FEB-2026 10:07:30 YES
2 25089 23-FEB-2026 10:07:30 23-FEB-2026 10:13:15 YES
1 13551 23-FEB-2026 10:04:46 23-FEB-2026 10:13:17 YES
2 25090 23-FEB-2026 10:13:15 23-FEB-2026 10:14:57 YES
2 25091 23-FEB-2026 10:14:57 23-FEB-2026 10:16:03 YES
2 25092 23-FEB-2026 10:16:03 23-FEB-2026 10:19:07 YES
1 13552 23-FEB-2026 10:13:17 23-FEB-2026 10:19:08 YES
2 25093 23-FEB-2026 10:19:07 23-FEB-2026 10:22:37 YES
2 25094 23-FEB-2026 10:22:37 23-FEB-2026 10:24:28 YES
2 25095 23-FEB-2026 10:24:28 23-FEB-2026 10:25:10 YES
1 13553 23-FEB-2026 10:19:08 23-FEB-2026 10:25:11 YES
2 25096 23-FEB-2026 10:25:10 23-FEB-2026 10:27:07 YES
1 13554 23-FEB-2026 10:25:11 23-FEB-2026 10:33:24 YES
1 13555 23-FEB-2026 10:33:24 23-FEB-2026 10:34:12 YES
1 13556 23-FEB-2026 10:34:12 23-FEB-2026 10:36:12 YES
2 25097 23-FEB-2026 10:27:07 23-FEB-2026 10:36:13 YES
1 13557 23-FEB-2026 10:36:12 23-FEB-2026 10:42:00 YES
2 25098 23-FEB-2026 10:36:13 23-FEB-2026 10:42:55 YES
2 25099 23-FEB-2026 10:42:55 23-FEB-2026 10:43:52 YES
2 25100 23-FEB-2026 10:43:52 23-FEB-2026 10:47:58 IN-MEMORY
1 13558 23-FEB-2026 10:42:00 23-FEB-2026 10:48:00 NO
8846 rows selected.
sys@bill1>
sys@bill1> show parameter standby_file_management
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
standby_file_management string AUTO
sys@bill1> show parameter log_archive_dest_state_2;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_2 string DEFER
log_archive_dest_state_20 string enable
log_archive_dest_state_21 string enable
log_archive_dest_state_22 string enable
log_archive_dest_state_23 string enable
log_archive_dest_state_24 string enable
log_archive_dest_state_25 string enable
log_archive_dest_state_26 string enable
log_archive_dest_state_27 string enable
log_archive_dest_state_28 string enable
log_archive_dest_state_29 string enable
sys@bill1> alter database recover managed standby database using current logfile disconnect;
sys@bill1> alter database recover managed standby database cancel;
sys@bill1> show parameter log_archive_dest_2;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_2 string SERVICE=billhcm ASYNC NOAFFIRM
DELAY=0 OPTIONAL COMPRESSION=
ENABLE MAX_FAILURE=0 MAX_CONNE
CTIONS=1 REOPEN=300 DB_UNIQUE_
NAME=bill NET_TIMEOUT=30 VALID
_FOR=(ALL_LOGFILES,PRIMARY_ROL
E)
log_archive_dest_20 string
log_archive_dest_21 string
log_archive_dest_22 string
log_archive_dest_23 string
log_archive_dest_24 string
log_archive_dest_25 string
log_archive_dest_26 string
log_archive_dest_27 string
log_archive_dest_28 string
log_archive_dest_29 string
...
sys@bill1> select DATABASE_ROLE,db_unique_name,primary_db_unique_name,open_mode from gv$database;
DATABASE_ROLE DB_UNIQUE_NAME PRIMARY_DB_UNIQUE_NAME OPEN_MODE
---------------- ------------------------------ ------------------------------ --------------------
PHYSICAL STANDBY bill bill READ ONLY WITH APPLY
PHYSICAL STANDBY bill bill READ ONLY WITH APPLY
TƯ VẤN: Click Here hoặc Hotline/Zalo 090.29.12.888
=============================
Website không chứa bất kỳ quảng cáo nào, mọi đóng góp để duy trì phát triển cho website (donation) xin vui lòng gửi về STK 90.2142.8888 - Ngân hàng Vietcombank Thăng Long - TRAN VAN BINH
=============================
Nếu bạn không muốn bị AI thay thế và tiết kiệm 3-5 NĂM trên con đường trở thành DBA chuyên nghiệp hay làm chủ Database thì hãy đăng ký ngay KHOÁ HỌC ORACLE DATABASE A-Z ENTERPRISE, được Coaching trực tiếp từ tôi với toàn bộ bí kíp thực chiến, thủ tục, quy trình của gần 20 năm kinh nghiệm (mà bạn sẽ KHÔNG THỂ tìm kiếm trên Internet/Google) từ đó giúp bạn dễ dàng quản trị mọi hệ thống Core tại Việt Nam và trên thế giới, đỗ OCP.
- CÁCH ĐĂNG KÝ: Gõ (.) hoặc để lại số điện thoại hoặc inbox https://m.me/tranvanbinh.vn hoặc Hotline/Zalo 090.29.12.888
- Chi tiết tham khảo:
https://bit.ly/oaz_w
=============================
2 khóa học online qua video giúp bạn nhanh chóng có những kiến thức nền tảng về Linux, Oracle, học mọi nơi, chỉ cần có Internet/4G:
- Oracle cơ bản: https://bit.ly/admin_1200
- Linux: https://bit.ly/linux_1200
=============================
KẾT NỐI VỚI CHUYÊN GIA TRẦN VĂN BÌNH:
📧 Mail: binhoracle@gmail.com
☎️ Mobile/Zalo: 0902912888
👨 Facebook: https://www.facebook.com/BinhOracleMaster
👨 Inbox Messenger: https://m.me/101036604657441 (profile)
👨 Fanpage: https://www.facebook.com/tranvanbinh.vn
👨 Inbox Fanpage: https://m.me/tranvanbinh.vn
👨👩 Group FB: https://www.facebook.com/groups/DBAVietNam
👨 Website: https://www.tranvanbinh.vn
👨 Blogger: https://tranvanbinhmaster.blogspot.com
🎬 Youtube: https://www.youtube.com/@binhguru
👨 Tiktok: https://www.tiktok.com/@binhguru
👨 Linkin: https://www.linkedin.com/in/binhoracle
👨 Twitter: https://twitter.com/binhguru
👨 Podcast: https://www.podbean.com/pu/pbblog-eskre-5f82d6
👨 Địa chỉ: Tòa nhà Sun Square - 21 Lê Đức Thọ - Phường Mỹ Đình 1 - Quận Nam Từ Liêm - TP.Hà Nội
=============================
cơ sở dữ liệu, cơ sở dữ liệu quốc gia, database, AI, trí tuệ nhân tạo, artificial intelligence, machine learning, deep learning, LLM, ChatGPT, DeepSeek, Grok, oracle tutorial, học oracle database, Tự học Oracle, Tài liệu Oracle 12c tiếng Việt, Hướng dẫn sử dụng Oracle Database, Oracle SQL cơ bản, Oracle SQL là gì, Khóa học Oracle Hà Nội, Học chứng chỉ Oracle ở đầu, Khóa học Oracle online,sql tutorial, khóa học pl/sql tutorial, học dba, học dba ở việt nam, khóa học dba, khóa học dba sql, tài liệu học dba oracle, Khóa học Oracle online, học oracle sql, học oracle ở đâu tphcm, học oracle bắt đầu từ đâu, học oracle ở hà nội, oracle database tutorial, oracle database 12c, oracle database là gì, oracle database 11g, oracle download, oracle database 19c/21c/23c/23ai, oracle dba tutorial, oracle tunning, sql tunning , oracle 12c, oracle multitenant, Container Databases (CDB), Pluggable Databases (PDB), oracle cloud, oracle security, oracle fga, audit_trail,oracle RAC, ASM, oracle dataguard, oracle goldengate, mview, oracle exadata, oracle oca, oracle ocp, oracle ocm , oracle weblogic, postgresql tutorial, mysql tutorial, mariadb tutorial, ms sql server tutorial, nosql, mongodb tutorial, oci, cloud, middleware tutorial, docker, k8s, micro service, hoc solaris tutorial, hoc linux tutorial, hoc aix tutorial, unix tutorial, securecrt, xshell, mobaxterm, putty