asktom的含义maxloghistory

转载 2015年07月08日 13:49:01
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. 

Correlation between MAXLOGHISTORY & CONTROL_FILE_RECORD_KEEP_TIME

Saibabu -- Thanks for the question regarding "Correlation between MAXLOGHISTORY & CONTROL_FILE_RECOR...
  • loryliu
  • loryliu
  • 2015年09月01日 21:38
  • 422

asktom2.rar

  • 2008年03月16日 13:44
  • 3.3MB
  • 下载

SQL 2002年度总结 asktom-2002.chm

  • 2007年08月27日 14:32
  • 5.48MB
  • 下载

关于信噪比的确切含义——Eb/No和SNR的区别

求助:关于信噪比的确切含义——Eb/No和SNR的区别 在《现代通信系统——使用matlab》一书中,一些调制方式的Monte Carlo仿真性能曲线中,横轴是用Eb/No来表示的,而matlab代...
  • jbb0523
  • jbb0523
  • 2012年08月07日 22:30
  • 36034

ASKTom_oracle.part1.rar

  • 2011年01月24日 17:53
  • 19MB
  • 下载

asktom2008年问题集合

  • 2009年09月12日 15:47
  • 7.61MB
  • 下载

事件冒泡和事件捕获的含义? — 第13.1讲

该懂得一定要懂,该学的不能再拖,该行动的就是此刻! 一:事件流的历史?  就像是在桌面上画了许多同心圆,当把手放在圆心上,那么你的手指指的不是一个圆,而是所有的圆。公司的浏览器开发团队在看待浏览器事件...

asktom1.

  • 2008年03月16日 13:32
  • 3.3MB
  • 下载

R语言函数的含义与用法,实现过程解读

R的源起 R是S语言的一种实现。S语言是由 AT&T贝尔实验室开发的一种用来进行数据探索、统计分析、作图的解释型语言。最初S语言的实现版本主要是S-PLUS。S-PLUS是一个商业 软件,它基于S语...
  • HHTNAN
  • HHTNAN
  • 2016年12月27日 10:46
  • 234
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:asktom的含义maxloghistory
举报原因:
原因补充:

(最多只允许输入30个字)