Is the Redo File Missing?

ORA-00447: fatal error in background process
ORA-00308: cannot open archived log
'/app/oracle/DNYTST10/flash_recovery_area/archivelog/
2004_08_28/o1_mf_1_320_0m05kq4w_.arc'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
ORA-06512: at "SYS.DBMS_CAPTURE_ADM_INTERNAL", line 630
ORA-06512: at "SYS.DBMS_CAPTURE_PROCESS", line 390
ORA-06512: at line 1

The solution is to restore the archive file required and restart the Capture process.

The need for restoration is the reason that the archive log files should be left on disk until the Capture process is finished with the logs. To determine the archive log that contains the required checkpoint SCN, the following query can be used.  In this example, xxxx is the checkpoint SCN that is needed.

SELECT             name FROM             v$archived_log
where xxxx BETWEEN first_change# AND next_change#;

There may come a time when the need to re-adjust the SCN value for the Capture process will arise. For example, the following procedure sets the start and first SCN values for the Capture process so that it will skip the missing log file: