99精品欧美,欧美亚洲高清,成人免费影院

本文介紹了如何刪除 AWS RDS Oracle 實例上的存檔日志文件的處理方法，對大家解決問題具有一定的參考價值，需要的朋友們下面隨著小編來一起學習吧！

問題描述

限時送ChatGPT賬號..

我們有一個 AWS Oracle RDS 實例，最近用 ORA-01653 和 ORA-01654 耗盡了空間(無法在表空間 X 中將索引 X 擴展 8...) 錯誤.

We have an AWS Oracle RDS instance that recently ran out of space with ORA-01653 and ORA-01654 (Unable to extend index X by 8 in tablespace X...) errors.

通過運行查詢進行調查:

On investigation by running query:

select nvl(sum(BLOCKS * BLOCK_SIZE),0)/1024/1024/1024 GB from V$ARCHIVED_LOG  where DEST_ID=1 and ARCHIVED='YES' and DELETED='NO';

這顯示了輸出:

        GB
----------
26.3267608

這讓我相信我們有 26 GB 的存檔日志.

This leads me to believe we have 26 GB of Archive logs.

運行以下查詢以獲取有關存檔文件的一些信息:

Running the following query to get some info on the archive files:

select * from V$ARCHIVED_LOG  where DEST_ID=1 and ARCHIVED='YES' and DELETED='NO';

我們有近 5000 行結果.一些示例行:

We have nearly 5000 rows of results. Some example rows:

 RECID      STAMP NAME                                                           DEST_ID    THREAD#  SEQUENCE# RESETLOGS_CHANGE# RESETLOGS RESETLOGS_ID FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME     BLOCKS BLOCK_SIZE CREATOR REGISTR STA ARC APPLIED   DEL S COMPLETIO DIC DIC END BACKUP_COUNT ARCHIVAL_THREAD# ACTIVATION# IS_ COM FAL END_OF_RED BAC
------ ---------- ------------------------------------------------------------ --------- ---------- ---------- ----------------- --------- ------------ ------------- --------- ------------ --------- ---------- ---------- ------- ------- --- --- --------- --- - --------- --- --- --- ------------ ---------------- ----------- --- --- --- ---------- ---
 56851 1021006860 /rdsdbdata/db/DRGNFLY_A/arch/redolog-56852-1-1002024260.arc          1          1      56852            222206 04-MAR-19   1002024260     108023802 07-OCT-19    108025497 07-OCT-19       1721        512 ARCH    ARCH    NO  YES NO        NO  A 07-OCT-19 NO  NO  NO             0                1  1073401855 NO  NO  NO             NO 
 56852 1021007166 /rdsdbdata/db/DRGNFLY_A/arch/redolog-56853-1-1002024260.arc          1          1      56853            222206 04-MAR-19   1002024260     108025497 07-OCT-19    108026500 07-OCT-19        626        512 ARCH    ARCH    NO  YES NO        NO  A 07-OCT-19 NO  NO  NO             0                1  1073401855 NO  NO  NO             NO

這個存檔文件的位置是:/rdsdbdata/db/DRGNFLY_A/arch/redolog-56849-1-1002024260.arc其他行也在此目錄中:/rdsdbdata/db/DRGNFLY_A/arch

The location of this archive file is: /rdsdbdata/db/DRGNFLY_A/arch/redolog-56849-1-1002024260.arc The other rows are also in this directory: /rdsdbdata/db/DRGNFLY_A/arch

來自 AWS Oracle 常見 DBA 任務文件，我們已經運行了存儲過程:

From AWS Oracle Common DBA Tasks document, we have ran the stored proc:

exec rdsadmin.rdsadmin_master_util.drop_archivelog_dir;
exec rdsadmin.rdsadmin_master_util.drop_onlinelog_dir;

此命令成功執行，但再次運行上述查詢時，仍顯示 26 GB 的存檔日志文件.

This command executed successfully, but when running the query above again it still shows 26 GB of archive log files.

要查看我運行的存檔日志保留配置:

To see the archive log retention config I ran:

set serveroutput on
exec rdsadmin.rdsadmin_util.show_configuration;

這會產生輸出:

NAME:archivelog retention hours
VALUE:0
DESCRIPTION:ArchiveLog expiration specifies the duration in hours before archive/redo log files are automatically deleted.
NAME:tracefile retention
VALUE:1440
DESCRIPTION:tracefile expiration specifies the duration in minutes before tracefiles in bdump are automatically deleted.

這會讓我相信，由于歸檔日志保留時間的值為 0，這些文件應該被自動刪除嗎?

This would lead me to believe that as archivelog retention hours has a value of 0, these files should be automatically deleted?

我的問題:

我的上述分析/查詢是否有誤?這些存檔日志實際上并未導致我的表空間錯誤?
如何刪除這些存檔日志文件并回收空間，以便將其用于普通數據庫存儲等.據我所知，AWS-RDS 不提供刪除這些文件的直接訪問權限，這就是我嘗試使用的原因rdsadmin.rdsadmin_master_util.drop_archivelog_dir 存儲過程.
還有如何確保日志文件不會在適當的保留期內繼續生成或清理.

pbootcms网站模板|日韩1区2区|织梦模板||网站源码|日韩1区2区|jquery建站特效-html5模板网

如何刪除 AWS RDS Oracle 實例上的存檔日志文件

問題描述

推薦答案

相關文檔推薦