1. 首页
  2. IT资讯

rman 删除v$archive_log视图里的记录(Removing entries in v$archived_log)

请参考MOS ID 845361.1 : Removing entries in v$archived_log referencing a particluar DEST_ID Goal

This note provides instructions on how to clear the section in the controlfile which contains data referencing v$archived_log. For example v$archived_log may contain data from dest_id = 1 & dest_id=2. This note will guide you through the process of only keeping entries from one distinct location Solution

It is possible to clear different section of the controlfile. Section 11 refers to the v$archived_log entries. SQL>execute sys.dbms_backup_restore.resetCfileSection( 11); This will clear all files in v$archived_log; Then using RMAN we can catalog the DEST=1 file back in. Assume that all archivelogs reside in /recovery_area/archives/ RMAN> catalog start with ‘/recovery_area/archives/’; —最好加上末尾的’/’ This will update the controlfile with these entries only. NOTE: If you clear a controlfile section using undocumented event, then you also need to update high_al_recid in the node table for that database to 0 in recovery catalog.For 11g recovery catalog schema and above:update node set high_al_recid = 0 where db_unique_name = ‘ 布吉卡

oracle block_size 为非标准块的时候
« 上一篇 2020年4月16日 am11:23
2012-06-03 20:40 catalog start with rman备份集直接导入控制文件中
下一篇 » 2020年4月16日 am11:23

相关推荐

联系我们

13687733322

在线咨询:点击这里给我发消息

邮件:1877088071@qq.com

工作时间:周一至周五,9:30-18:30,节假日休息

QR code