{"rsdb":{"rid":"158018","subhead":"","postdate":"0","aid":"118478","fid":"57","uid":"1","topic":"1","content":"

\u4e8e\u662f\u767e\u5ea6\u627e\u5230\u4e00\u7bc7\u6587\u7ae0http:\/\/3y.uu456.com\/bp_3i90z4529l10ttd0odyk_1.html \u5927\u4f53\u610f\u601d\u662fMAN\u5220\u9664\u5f52\u6863\u65e5\u5fd7\u7684\u4f9d\u636e\u662fcontrolfile\u4e2d\u8bb0\u5f55\u7684\u5f52\u6863\u65e5\u5fd7\uff0c\u800c\u4e0d\u662f\u4f60\u78c1\u76d8\u4e0a\u5b9e\u9645\u5b58\u5728\u7684\u5f52\u6863\u65e5\u5fd7
\uff0c\u5982\u679c\u4f60\u7684\u5f52\u6863\u65e5\u5fd7\u5df2\u7ecf\u4e0d\u5728controlfile\u4e2d\u5c31\u65e0\u6cd5\u88abRMAN\u8bc6\u522b\u5230\uff0c\u4e5f\u5c31\u65e0\u6cd5\u88ab\u5220\u9664\u3002\u800c\u81f4\u4e8e\u5f52\u6863\u4fe1\u606f\u4f55\u65f6\u5728\u63a7\u5236\u6587\u4ef6\u4e2d\u88ab\u8986\u76d6\uff0c\u8fd9\u7531\u4e00\u4e2a\u53c2\u6570control_file_record_keep_time\u6765\u63a7\u5236\u3002
\u67e5\u770b\u6570\u636e\u5e93\u4e2d\u7684\u53c2\u6570\u662f\u9ed8\u8ba4\u76847\u5929
SYS@db> show parameter CONTROL_FILE_RECORD_KEEP_TIME
 
NAME                                TYPE                            VALUE
------------------------------------ -------------------------------- ------------------------------
control_file_record_keep_time        integer                          7
\u96be\u9053\u662f\u5728\u63a7\u5236\u6587\u4ef6\u4e2d\u5f52\u6863\u65e5\u5fd7\u7684\u8bb0\u5f55\u6761\u6570\u53ea\u80fd\u4fdd\u75597\u5929\u7684\u4e48\uff1f\u4e8e\u662f\u5230MOS\u53bb\u627e\u76f8\u5173\u6587\u6863\u627e\u5230\u4e00\u7bc7Why Are Controlfile Entries For Archived Logs Not Overwritten After CONTROL_FILE_RECORD_KEEP_TIME? (\u6587\u6863 ID 1056085.1)\uff0c\u6587\u6863\u4ecb\u7ecdCONTROL_FILE_RECORD_KEEP_TIME\u53c2\u6570\u5e76\u4e0d\u662f\u5f3a\u5236\u5728\u63a7\u5236\u6587\u4ef6\u4e2d\u4fdd\u7559\u591a\u5c11\u5929\u7684\u5f52\u6863\u65e5\u5fd7\u6761\u76ee\uff0c\u800c\u662f\u7531V$CONTROLFILE_RECORD_SECTION\u89c6\u56fe\u4e2d\u7684ARCHIVED LOG\u6761\u76ee\u53bb\u63a7\u5236\u7684\uff0c\u5f53RECORDS_TOTAL=RECORDS_USED\u65f6\u65e7\u7684\u5f52\u6863\u65e5\u5fd7\u5c31\u4f1a\u88ab\u8986\u76d6\u6389\u3002
\u4e8e\u662f\u67e5\u6570\u636e\u5e93\u4e2d\u7684V$CONTROLFILE_RECORD_SECTION\u89c6\u56fe\uff0c\u770b\u5230ARCHIVED LOG\u884c\u7684records_total=224\u610f\u5473\u7740\u63a7\u5236\u6587\u4ef6\u4e2d\u53ea\u80fd\u4fdd\u7559224\u6761\u5f52\u6863\u65e5\u5fd7\u6587\u4ef6\u4fe1\u606f\u3002
SYS@dbs> select * from v$controlfile_record_section where type='ARCHIVED LOG';
 
TYPE                        RECORD_SIZE RECORDS_TOTAL RECORDS_USED FIRST_INDEX LAST_INDEX LAST_RECID
---------------------------- ----------- ------------- ------------ ----------- ---------- ----------
ARCHIVED LOG                        584          224          224          88        87      1235
\u67e5\u8be2v$archived_log\u89c6\u56fe\uff0c\u603b\u6570\u4e3a224\u6761
SYS@dbs> select count(*) from v$archived_log;
 
  COUNT(*)
----------
      224
\u8fd9\u65f6\u5e94\u8be5\u53ef\u4ee5\u63a8\u65ad\u51fa\u7531\u4e8e\u63a7\u5236\u6587\u4ef6\u4e2d\u53ea\u80fd\u4fdd\u7559224\u6761\u5f52\u6863\u65e5\u5fd7\u6570\u636e\uff0c\u6240\u4ee5\u4ee5\u524d\u7684\u5f52\u6863\u4fe1\u606f\u5df2\u7ecf\u88ab\u63a7\u5236\u6587\u4ef6\u5237\u51fa\uff0cRMAN\u65e0\u6cd5\u8bc6\u522b\u5230\u8fd9\u4e9b\u5f52\u6863\u6587\u4ef6\uff0c\u6240\u4ee5\u5c31\u65e0\u6cd5\u5220\u9664\u8fd9\u4e9b\u5f52\u6863\u65e5\u5fd7\u3002
\u90a3\u4e48\u73b0\u5728\u5982\u679c\u4f7f\u7528RMAN\u5220\u9664\u8fd9\u4e9b\u65e7\u7684\u5f52\u6863\u65e5\u5fd7\u5462\uff1f\u6211\u60f3\u5230\u4f7f\u7528catalog start with \u547d\u4ee4\u91cd\u65b0\u6ce8\u518c\u8fd9\u4e9b\u6587\u4ef6\u5230\u63a7\u5236\u6587\u4ef6\u4e2d
RMAN> catalog start with '\/opt\/oracle\/archive\/db';
......
File Name: \/opt\/oracle\/archive\/db\/1_1005_91233774.dbf
File Name: \/opt\/oracle\/archive\/db\/1_1006_91233774.dbf
File Name: \/opt\/oracle\/archive\/db\/1_1007_91233774.dbf
 
Do you really want to catalog the above files (enter YES or NO)? yes
cataloging files...
cataloging done
......
RMAN> list archivelog all;
.....
1236    1    301    A 22-OCT-16
        Name: \/opt\/oracle\/archive\/db\/1_301_91233774.dbf
 
1237    1    302    A 22-OCT-16
        Name: \/opt\/oracle\/archive\/db\/1_302_91233774.dbf
......
\u65e7\u7684\u5f52\u6863\u65e5\u5fd7\u6587\u4ef6\u5df2\u7ecf\u6ce8\u518c\u5230\u63a7\u5236\u6587\u4ef6\u4e2d\u4e86\uff0c\u518d\u4f7f\u7528RMAN\u8fdb\u884c\u5220\u9664\u5c31\u53ef\u4ee5\u4e86
delete archivelog until logseq 1007;
\u518d\u6b21\u67e5\u8be2v$controlfile_record_section\u89c6\u56fe\uff0crecords_total\u4e5f\u88ab\u201c\u6491\u201d\u5927\u4e86
SYS@db> select * from v$controlfile_record_section where type='ARCHIVED LOG';
 
TYPE                        RECORD_SIZE RECORDS_TOTAL RECORDS_USED FIRST_INDEX LAST_INDEX LAST_RECID
---------------------------- ----------- ------------- ------------ ----------- ---------- ----------
ARCHIVED LOG       ","orderid":"0","title":"RMAN\u5220\u9664\u5f52\u6863\u65e5\u5fd7\u4e0d\u91ca\u653e\u95ee\u9898\u89e3\u51b3(\u4e00)","smalltitle":"","mid":"0","fname":"\u6570\u636e\u5e93\u7f16\u7a0b","special_id":"0","bak_id":"0","info":"0","hits":"1204","pages":"2","comments":"0","posttime":"2017-07-14 10:22:55","list":"1499998975","username":"admin","author":"","copyfrom":"","copyfromurl":"","titlecolor":"","fonttype":"0","titleicon":"0","picurl":"https:\/\/www.cppentry.com\/upload_files\/","ispic":"0","yz":"1","yzer":"","yztime":"0","levels":"0","levelstime":"0","keywords":"RMAN<\/A> \u5220\u9664<\/A> \u5f52\u6863<\/A> \u65e5\u5fd7<\/A> \u91ca\u653e<\/A> \u95ee\u9898<\/A> \u89e3\u51b3<\/A>","jumpurl":"","iframeurl":"","style":"","template":"a:3:{s:4:\"head\";s:0:\"\";s:4:\"foot\";s:0:\"\";s:8:\"bencandy\";s:0:\"\";}","target":"0","ip":"218.17.197.194","lastfid":"0","money":"0","buyuser":"","passwd":"","allowdown":"","allowview":"","editer":"","edittime":"0","begintime":"0","endtime":"0","description":"RMAN\u5220\u9664\u5f52\u6863\u65e5\u5fd7\u4e0d\u91ca\u653e\u95ee\u9898\u89e3\u51b3","lastview":"1711714548","digg_num":"6359","digg_time":"0","forbidcomment":"0","ifvote":"0","heart":"","htmlname":"","city_id":"0"},"page":"1"}