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

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

Nguyên nhân: Phân vùng FRA thiếu dung lượng lưu trữ backup

Xử lý: Tăng dung lượng cho FRA

Kết nối vào SQLplus:

show parameter recovery

alter system set db_recovery_file_dest_size=10000m;

Tăng dung lượng FRA lên thành 10000MB, chú ý dung lượng thực của disk phải lớn hơn dung lượng khai báo này cho DB, nếu hết dung lượng thực của disk thì tham số trên cũng không có ý nghĩa gì.

Xem thêm:

Q130. Which two are true about Rapid Home Provisioning (RHP), which has been available since Orcale 18c?
Q99 Which three files are used by conventional path SQL*Loader when the TABLE option is not specified?
Supabase Là Gì? Hướng Dẫn Cơ Bản Về Supabase
Q139 Which two are true about shrinking a segment online?
Data Profiling là gì?

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
ORA-01950 no privileges on tablespace ‘USERS’
ORA-38708 not enough space for first flashback database log file
ORA-00821: Specified value of sga_target 1504M is too small
Lỗi ORA-16397: statement redirection from Oracle Active Data Guard standby database to primary database failed
Lỗi ORA-16470 Oracle Data Guard Oracle 19c
Khắc phục lỗi MoTTY X11 proxy: Unsupported authorisation protocol

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

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

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

ORA-01950 no privileges on tablespace ‘USERS’

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

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

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

Lỗi ORA-16470 Oracle Data Guard Oracle 19c

Khắc phục lỗi MoTTY X11 proxy: Unsupported authorisation protocol

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

ORA-01950 no privileges on tablespace ‘USERS’

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

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

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

Lỗi ORA-16470 Oracle Data Guard Oracle 19c

Khắc phục lỗi MoTTY X11 proxy: Unsupported authorisation protocol

Đăng nhập

Đăng ký