sinner008 发表于 2012-5-28 22:43:50

11g ASM 下归档删除没有生效问题

咨询个问题:
我这边遇到个情况,RMAN中删除了30天之前的归档,crosscheck已经看不到了,但在asm中还能看到30天之前的归档文件,我的环境是11.2 RAC +ASM,11g中control_file_record_keep_time默认参数为30,现在我怀疑和这个参数有关,这个参数会导致30天之前的归档文件信息在控制文件中删除掉吗?  但是在设置为7天的时候,也可以看到超过7天以上的归档日志信息,请问这个是怎么回事?

CONTROL_FILE_RECORD_KEEP_TIME
CONTROL_FILE_RECORD_KEEP_TIME specifies the minimum number of days before a reusable record in the control file can be reused. In the event a new record needs to be added to a reusable section and the oldest record has not aged enough, the record section expands. If this parameter is set to 0, then reusable sections never expand, and records are reused as needed.

zengmuansha 发表于 2013-10-31 22:05:56

使用RMAN 技术
rman target /
crosscheck expired;
delete nopormed archivelog untime 'sysdate-2';
页: [1]
查看完整版本: 11g ASM 下归档删除没有生效问题