APPLIES TO:

Oracle Database - Enterprise Edition - Version 10.2.0.3 and later
Information in this document applies to any platform.
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 = '<your target database db_unique_name'.


For 10gR2 recovery catalog schema and below:


update dbinc set high_al_recid = 0 where db_name = '<your target database db_name>';




A full database backup is recommended prior to perform this task.

APPLIES TO:

Oracle Database - Enterprise Edition - Version 10.2.0.3 and later
Information in this document applies to any platform.
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 = '<your target database db_unique_name'.


For 10gR2 recovery catalog schema and below:


update dbinc set high_al_recid = 0 where db_name = '<your target database db_name>';




A full database backup is recommended prior to perform this task.