StarQuest Technical Documents
SQDR Plus: Managing Oracle Log Files
Last Update: 3 June 2015
Product: SQDR Plus
Version: 4.50 and later
Article ID: SQV00PL021
Abstract
SQDR Plus uses Oracle LogMiner to extract incremental changes from redo log files. If a log file is deleted prematurely (before it has been examined by SQDR Plus), all incremental subscriptions will be flagged as requiring new baselines.
This technical document describes how an Oracle administrator can determine which log files can be removed without affecting SQDR Plus incremental replications.
Solution
The following SQL statement returns a list of log files that can be deleted safely:
select AL.SEQUENCE#,AL."NAME" from V$ARCHIVED_LOG AL, SQDR.SQ_READERS R where AL."NAME" IS NOT NULL and AL."NEXT_CHANGE#" <= R.SCN
DISCLAIMER
The information in technical documents comes without any warranty or applicability for a specific purpose. The author(s) or distributor(s) will not accept responsibility for any damage incurred directly or indirectly through use of the information contained in these documents. The instructions may need to be modified to be appropriate for the hardware and software that has been installed and configured within a particular organization. The information in technical documents should be considered only as an example and may include information from various sources, including IBM, Microsoft, and other organizations.