程序師世界是廣大編程愛好者互助、分享、學習的平台,程序師世界有你更精彩!
首頁
編程語言
C語言|JAVA編程
Python編程
網頁編程
ASP編程|PHP編程
JSP編程
數據庫知識
MYSQL數據庫|SqlServer數據庫
Oracle數據庫|DB2數據庫
 程式師世界 >> 數據庫知識 >> Oracle數據庫 >> Oracle教程 >> 關於oraclerman歸檔刪除策略

關於oraclerman歸檔刪除策略

編輯:Oracle教程

關於oraclerman歸檔刪除策略


RMAN> show all;

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;

在oracle10g 11g 中 歸檔刪除策略 缺省是沒有配置的;

那麼這時去刪除未應用過的的歸檔日志會是怎麼一種情況:


RMAN> delete archivelog all;

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=60 device type=DISK
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process

archived log file name=/u01/app/ora11/flash_recovery_area/1_2019_822927217.dbf thread=1 sequence=2019
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process

archived log file name=/u01/app/ora11/flash_recovery_area/1_2023_822927217.dbf thread=1 sequence=2023
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process

oracle 拋出報警;warning 歸檔日志沒有刪除,歸檔日志需要用作standby 或者 stream 捕獲進程使用

關於rman中這個配置策略:

CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY


不是自動刪除歸檔。而是刪除的時候確認歸檔已經被DATA GUARD、流環境所應用。這個功能的目的是避免刪除其他功能所需要的歸檔日志。

如果配置歸檔刪除策略:

CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY;
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/db_home/dbs/snapcf_oradb1.f'; # default

嘗試刪除歸檔日志:
RMAN> delete archivelog all;


released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=27 instance=oradb1 device type=DISK
List of Archived Log Copies for database with db_unique_name ORADB
=====================================================================

Key Thrd Seq S Low Time
------- ---- ------- - --------------------
2526 2 350 A 22-NOV-2014 02:01:04
Name: +FLASH/oradb/archivelog/2014_11_24/thread_2_seq_350.600.864470143
2527 2 351 A 23-NOV-2014 13:01:27
Name: +FLASH/oradb/archivelog/2014_11_24/thread_2_seq_351.620.864470173
2531 2 352 A 24-NOV-2014 10:29:04
Name: +FLASH/oradb/archivelog/2014_11_26/thread_2_seq_352.554.864634011




Do you really want to delete the above objects (enter YES or NO)? yes
deleted archived log
archived log file name=+FLASH/oradb/archivelog/2014_11_24/thread_2_seq_350.600.864470143 RECID=2526 STAMP=864470171
deleted archived log
archived log file name=+FLASH/oradb/archivelog/2014_11_24/thread_2_seq_351.620.864470173 RECID=2527 STAMP=864470193
deleted archived log
archived log file name=+FLASH/oradb/archivelog/2014_11_26/thread_2_seq_352.554.864634011 RECID=2531 STAMP=864634090
Deleted 3 objects


RMAN-08591: WARNING: invalid archived log deletion policy

[oracle@vmrac1 ~]$ oerr rman 8591
8591, 3, "WARNING: invalid archived log deletion policy"
// *Cause: An invalid ARCHIVELOG DELETION POLICY was supplied. The archived
// log deletion policy was APPLIED but there was no mandatory
// archived log destinations.
// *Action: One of the following:
// 1) Change archived log deletion policy using CONFIGURE command
// 2) Make one or more of standby destination as MANDATORY.

  1. 上一頁:
  2. 下一頁:
Copyright © 程式師世界 All Rights Reserved