Component : Database Administration with Oracle - Oracle

Solution : https://service.sap.com/sap/support/notes/490976 (SAP Service marketplace login required)

Summary :
This SAP Note addresses issues with the `brarchive` tool where it unexpectedly reports no offline redo log files available for processing despite their existence. Potential causes highlighted include corrupted `arch.log`, incorrect archiving modes, programmatic errors, or issues with the `RESET LOGS` operation. Recommendations involve verifying log file entries, adjusting archiving settings through parameters, or ensuring directory setups are correct for logging. Troubleshooting includes modifying the `log_archive_format` to handle log numbers over 99999 correctly. Detailed steps are provided for resolving incorrect log file references and requisite archive configurations.

Key words :
processing  br017e offline redo log file <log>, found  br017w offline redo log file <log>, offline redo log files found, offline redo log file names, archiving previously written redo logs, log_archive_dest = /oracle/c11/saparch/c11arch, summary brarchive log arch<sid>, \oracle\c11\saparch\c11arch, lower log numbers exist, redo log numbers greater

Related Notes :

152515	BRARCHIVE cannot find any files for saving
132551	Overflow log sequence numbers on NT
10170	BRARCHIVE does not find archive logs to save