asktom的含义maxloghistory
来源:互联网 发布:小米手机网络制式查询 编辑:程序博客网 时间:2024/06/05 05:58
1) well -- the documentation seems clear on this to me:<quote>Note: This parameter is useful only if you are using Oracle with the Parallel Server option in parallel mode, and archivelog mode enabled.</quote>so, it would be saying that is has not significance outside of OPS/RAC. It controls the number of log history records available on v$log_history.2) well, it depends. RMAN usually uses a recovery catalog, not the control file. If you are using RMAN with just the control file and no recovery catalog, it'll totally depend on how fast you cycle through and reuse reusable records in the control file. In any case -- you can always recover manually regardless (you do not lose the ability to recover, we just might not be able to supply you the filenames)3 & 4) they shouldn't be the same. loghist (log_history is the prefered view) is controled by the maxloghistory. v$archived_log is controlled by the control_file_record_keep_time -- those records are among the circularly reusable records. We'll dynamically expand the control file to hold 7 days worth of archive log information for you (if you have it set to 7). On the 8th day, we just overwrite the old records and reuse their slots.So, one is retained by a physical count (maxloghistory) and shows the history of the logs.The other is retained by a number of days -- keep the history for the last N days -- and will cause the control file to grow as needed.As for why you are seeing really old records in v$archived log -- you must have had a 7 day period in which you generated LOTS of archives, more then you did in the recent past. That caused this section to grow larger to hold it. We won't shrink it back -- hence you have more space then you need to hold your current 7 days worth of information. The 7 is a MINIMUM retention time. It does not mean we purge records older then 7 days.5) set your control_file_record_keep_time to be at least one day GREATER then the period of time between your backups, else there is a chance that an archive record gets aged out during the backup which thoroughly confuses the situation.
0 0
- asktom的含义maxloghistory
- 来自AskTom的关于SoftParse的解释
- 关于Trigger的使用 - 转自AskTom
- 来自AskTom的关于Soft Parse的解释
- ASKTOM 关于更新上百万的数据方法
- Correlation between MAXLOGHISTORY & CONTROL_FILE_RECORD_KEEP_TIME
- connect as sysdba problem.--asktom
- Efficient SQL - 转自AskTom
- "/"的含义
- /的含义
- $的含义
- *&的含义
- 确定系统中是否存在绑定变量的情况,ASKTOM提供函数remove_constans()来检查共享池中的SQL运行情况
- 未使用绑定变量检查【摘抄ASKTOM】
- [花的含义]用花含义指南
- 数组名的含义、指针含义
- CRUD的含义
- 字母的爱情含义
- 优秀Android博客大全,整理了国内外大神博客/Github地址,是学习Android进阶的首选[转]
- 开始刷leetcode day60: Unique Paths II
- nginx反向代理tomcat
- E: Sub-process /usr/bin/dpkg returned an error code (1) 出错解决方案
- Java基础之接口抽象类的内部实现
- asktom的含义maxloghistory
- 画财经:台湾股市泡沫是如何破灭的
- C#获取目录的几种方法
- Serializable:自定义序列化
- xcode模拟器的安装路径
- AndroidAnnotations快速开发框架
- IPA 包不经过APP Store直接发布到网站供用户下载安装
- 每天一个linux命令(19):find 命令概览
- leetcode: Power of Two