We have streams process running which is regiestered in DBA_REGISTERED_ARCHIVED_LOGS but for some reason it's not showing in v$archived_log.
SQL> alter database register logical logfile '/a01/oradata/eeprd07/arch/eeprd07_1687_1_702582822.log' for 'EEPRD__06_CAP';
alter database register logical logfile '/a01/oradata/eeprd07/arch/eeprd07_1687_1_702582822.log' for 'EEPRD__06_CAP'
*
ERROR at line 1:
ORA-01289: cannot add duplicate logfile
SQL> alter database register '/a01/oradata/eeprd07/arch/eeprd07_1688_1_702582822.log'
2 /
alter database register '/a01/oradata/eeprd07/arch/eeprd07_1688_1_702582822.log'
*
ERROR at line 1:
ORA-01900: LOGFILE keyword expected
SQL> select applied_scn, first_scn, start_scn, required_checkpoint_scn from dba_capture;
APPLIED_SCN FIRST_SCN START_SCN REQUIRED_CHECKPOINT_SCN
----------- ---------- ---------- -----------------------
4182912515 4129888409 4129888409 4141079035
SQL> select count(*) from v$archived_log where first_change# >= 4141079035 and next_change# <= 4141079035;
COUNT(*)
----------
0
How can I add this file to v$archived_log? I have a copy of the all the files required but for some reason it's not showing in v$archived_logs but in dba_registered_archived_logs.
SQL> select name from v$archived_log where next_change# <= 4141078805
2 /
no rows selected
SQL> select count(*) from dba_registered_Archived_log where next_scn <= 4141078805
2 /
COUNT(*)
----------
68
Edited by: user11970617 on Sep 30, 2010 3:24 PM
Is rman catalog archivelog going to help? We use snapshots on the array instead of RMAN
Edited by: user11970617 on Sep 30, 2010 4:02 PM