Examples - Connect_CDC - connect_cdc_mimix_share - 6.x

For a list of all processed archive logs with the full path name, execute the following query:

select name from sys.<rpuser>_v_processed_logs

where <rpuser> is the metabase name, which results in a display similar to this:

NAME
C:\ORACLE9.2\ORADATA\ORCL\ARCHIVE\OMNI1_3649.ARC
C:\ORACLE9.2\ORADATA\ORCL\ARCHIVE\OMNI1_3650.ARC
C:\ORACLE9.2\ORADATA\ORCL\ARCHIVE\OMNI1_3651.ARC

To get the archive log sequence numbers execute the following query:

select sequence# from sys.<rpuser>_v_processed_logs

which results in the display:

SEQUENCE#
3649
3650
3651

For the minimum and maximum sequence numbers, execute the following query:

select min(sequence#) first, max(sequence#) last from <rpuser>_v_processed_logs

which results in the display similar to:

FIRST        LAST
3649         3651   

The values this query returns represent the range of archive log sequence numbers that are safe to be deleted. For example, with the results of the above query, the following Recovery Manager command can be used to delete archive logs.

BACKUP ARCHIVELOG FROM SEQUENCE 3649 UNTIL SEQUENCE 3651 DELETE INPUT;