数据库|mysql教程
Oracle RMAN,Oracle删除归档,关于Oracl
数据库-mysql教程
彩票网站源码破解版,vscode 生成方法插件,ubuntu配置视觉,tomcat指定项目目录,爬虫开源网站,php关键词搜索,如何快速学习seo 网销,帝国网站后台无法登陆,wordpress 免费 模板lzw
RMANgt; show all; CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; 在Oracle10g 11g 中 归档删除策略 缺省是没有配置的； 那么
微信订餐系统源码,ubuntu 将文件改名,笑傲江湖鱼竿tomcat,网络爬虫 qt,php论坛网页,沈阳求推荐好的seo关键词排名lzw
逆战源码,vscode还原之前,ubuntu20设置中文输入,tomcat配置xmx,sqlite时间段,js 3d图表模型插件,spring支持的前端框架,爬虫发展方向,linux php 开发,seo优化全套教程seo公司,c mvc 发布网站源码,网页计数器的实现代码,dz 手机模板下载,项目管理系统php开发开源,小程序文章付费阅读lzw
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__822927217.dbf thread=1 sequence=
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__822927217.dbf thread=1 sequence=
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
=====================================================================
KeyThrd SeqS Low Time
——- —- ——- – ——————–
2526 2 350A 22-NOV- 02:01:04
Name: +FLASH/oradb/archivelog/_11_24/thread_2_seq_350.600.864470143
2527 2 351A 23-NOV- 13:01:27
Name: +FLASH/oradb/archivelog/_11_24/thread_2_seq_351.620.864470173
2531 2 352A 24-NOV- 10:29:04
Name: +FLASH/oradb/archivelog/_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/_11_24/thread_2_seq_350.600.864470143 RECID=2526 STAMP=864470171
deleted archived log
archived log file name=+FLASH/oradb/archivelog/_11_24/thread_2_seq_351.620.864470173 RECID=2527 STAMP=864470193
deleted archived log
archived log file name=+FLASH/oradb/archivelog/_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.
————————————–推荐阅读 ————————————–
RMAN 配置归档日志删除策略
Oracle基础教学之通过RMAN复制数据库
RMAN备份策略制定参考内容
RMAN备份学习笔记
Oracle数据库备份加密 RMAN加密
————————————–分割线 ————————————–
本文永久更新链接地址：
，
