转载 2015年07月08日 13:49:01
1) well -- the documentation seems clear on this to me:

Note: This parameter is useful only if you are using Oracle with the Parallel Server 
option in parallel mode, and archivelog mode enabled.

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 

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. 

ASKTOM 关于更新上百万的数据方法

假设如果我要更新数百万以上的数据, 我大概会选择不去’更新’ (UPDATE)吧. 我很有可能会用以下的方法: CREATE TABLE new_table as select from old...
  • ZengMuAnSha
  • ZengMuAnSha
  • 2010年05月31日 17:03
  • 6550


FREQUENTLY ASKED QUESTIONS -------------------------- NOTE: ----- All questions are related to...
  • changyanmanman
  • changyanmanman
  • 2014年04月04日 14:31
  • 1797


  • bisal
  • bisal
  • 2017年08月01日 21:53
  • 266


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

Efficient SQL - 转自AskTom

This was probably the hardest part of the book to write - this chapter.  That is not because the ma...
  • wozeze1
  • wozeze1
  • 2009年09月22日 14:13
  • 382


  • zgqtxwd
  • zgqtxwd
  • 2008年04月27日 06:26
  • 132

$( "*", document.body)的含义
  • lvjin110
  • lvjin110
  • 2014年05月05日 22:46
  • 608

关于Trigger的使用 - 转自AskTom

-- Thanks for the question regarding "Trigger on a table Fire at commit.", version 9.2.0 Submitted o...
  • wozeze1
  • wozeze1
  • 2009年09月22日 14:24
  • 501


Java关键字的大致含义 关键字 含义 abstract 表明类或者成员方法具有抽象属性 assert 用来进行程...
  • Justonlly
  • Justonlly
  • 2015年10月26日 11:06
  • 1358


一、200状态码:    成功2××: 成功处理了请求的状态码。    1、200 :服务器已成功处理了请求并提供了请求的网页。    2、204: 服务器成功处理了请求,但没有返回任何内容。 ...
  • waterDjj
  • waterDjj
  • 2016年09月09日 15:18
  • 3301