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:

Q12 Which table or set of tables will exist after the Flashback operation has completed?
PostgreSQL Limitations – giới hạn của Postgresql
Quản trị AWR và ADDM trong môi trường Oracle Multitenant CDB và PDB
Những hiểu lầm phổ biến về Pi Network
Q39 Which two statements are true about single row functions?

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ý