Lỗi ORA-16397: statement redirection from Oracle Active Data Guard standby database to primary database failed

Posted on 06/05/202406/03/2025 by Tran Anh

Lỗi ORA-16397: là lỗi xuất hiện trong khi thực thi lênh DML trên Standby database trên hệ thống Data guard.

Nguyên nhân: Standby login thông qua lệnh sqlplus / as sysdba mà không chỉ rõ instance trong khi login

Khắc phục: Exit khỏi sqlplus và thực hiện login lại có tên instance trên Standby

sqlplus sys/oracle@stand as sysdba

stand: có thể thay bằng tên instance name hiện tại của bạn.

Sau đó tiến hành thực thi câu lệnh bình thường. Kiểm tra kết quả trên Primary xem đã thực hiện được chưa?

Chúc các bạn thành công!

Xem thêm:

AI và tương lai của giao tiếp xã hội: Những rủi ro tiềm ẩn
VestaCP là gì? Cài đặt VestaCP như thế nào?
Sử dụng mệnh đề HAVING trong SQL
Q143. Which four are true about a Recovery Manager (RMAN) duplication without a TARGET connection?
Q90. You want to install Oracle Grid Infrastructure for a Standalone Server using Oracle Universal Installer (OUI)

Bài viết cùng chủ đề:

RMAN-06059: expected archived log not found, loss of archived log compromises recoverability
ORA-01652 unable to extend temp segment by 8192 in tablespace
ORA-00845 MEMORY_TARGET not supported on this system
ORA-03113 end-of-file on communication channel
Error The OpenJDK JVM is not supported on this platform when install Oracle Goldengate Studio
ORA-12754 Feature PDB SNAPSHOT CAROUSEL is disabled due to missing capability
Cài đặt Oracle Data guard sử dụng Oracle Enterprise Manager cloud control OEM
ORA-01950 no privileges on tablespace ‘USERS’
ORA-38708 not enough space for first flashback database log file
ORA-19804 cannot reclaim 1264643584 bytes disk space from 8657043456 bytes limit
ORA-00821: Specified value of sga_target 1504M is too small
Hướng dẫn export import Data broker metadata file
Disable Fast-Start Failover Oracle Data Guard Oracle Data Guard 19c
DEMO Fast-Start Failover Oracle Data Guard Oracle Data Guard 19c
Cấu hình Fast-Start Failover Oracle Data Guard sử dụng DGMGRL Utility Oracle Data Guard 19c
Rebuild Oracle Data Guard sau khi FAILOVER sử dụng DGMGRL Utility Oracle Data Guard 19c

0 0 đánh giá

Đánh giá bài viết

Theo dõi

0 Góp ý

Phản hồi nội tuyến

Xem tất cả bình luận

Lỗi ORA-16397: statement redirection from Oracle Active Data Guard standby database to primary database failed

Bài viết cùng chủ đề:

RMAN-06059: expected archived log not found, loss of archived log compromises recoverability

ORA-01652 unable to extend temp segment by 8192 in tablespace

ORA-00845 MEMORY_TARGET not supported on this system

ORA-03113 end-of-file on communication channel

Error The OpenJDK JVM is not supported on this platform when install Oracle Goldengate Studio

ORA-12754 Feature PDB SNAPSHOT CAROUSEL is disabled due to missing capability

Cài đặt Oracle Data guard sử dụng Oracle Enterprise Manager cloud control OEM

ORA-01950 no privileges on tablespace ‘USERS’

ORA-38708 not enough space for first flashback database log file

ORA-19804 cannot reclaim 1264643584 bytes disk space from 8657043456 bytes limit

ORA-00821: Specified value of sga_target 1504M is too small

Hướng dẫn export import Data broker metadata file

Disable Fast-Start Failover Oracle Data Guard Oracle Data Guard 19c

DEMO Fast-Start Failover Oracle Data Guard Oracle Data Guard 19c

Cấu hình Fast-Start Failover Oracle Data Guard sử dụng DGMGRL Utility Oracle Data Guard 19c

Rebuild Oracle Data Guard sau khi FAILOVER sử dụng DGMGRL Utility Oracle Data Guard 19c

Phần mềm bản quyền

Update sản phẩm

Thêm mới sản phẩm

Đặt hàng, thanh toán

Bài viết cùng chủ đề:

RMAN-06059: expected archived log not found, loss of archived log compromises recoverability

ORA-01652 unable to extend temp segment by 8192 in tablespace

ORA-00845 MEMORY_TARGET not supported on this system

ORA-03113 end-of-file on communication channel

Error The OpenJDK JVM is not supported on this platform when install Oracle Goldengate Studio

ORA-12754 Feature PDB SNAPSHOT CAROUSEL is disabled due to missing capability

Cài đặt Oracle Data guard sử dụng Oracle Enterprise Manager cloud control OEM

ORA-01950 no privileges on tablespace ‘USERS’

ORA-38708 not enough space for first flashback database log file

ORA-19804 cannot reclaim 1264643584 bytes disk space from 8657043456 bytes limit

ORA-00821: Specified value of sga_target 1504M is too small

Hướng dẫn export import Data broker metadata file

Disable Fast-Start Failover Oracle Data Guard Oracle Data Guard 19c

DEMO Fast-Start Failover Oracle Data Guard Oracle Data Guard 19c

Cấu hình Fast-Start Failover Oracle Data Guard sử dụng DGMGRL Utility Oracle Data Guard 19c

Rebuild Oracle Data Guard sau khi FAILOVER sử dụng DGMGRL Utility Oracle Data Guard 19c

Đăng nhập

Đăng ký