duplicated archived redologs in Dataguard.
- From: "Howard Latham" <howard.latham@xxxxxxxxx>
- To: "ORACLE-L Freelists" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 4 Jun 2008 10:43:13 +0100
Anyone know why this is happening?
Query shows duplicate archived logs and therefore it looks
like some havent been applied - when they have really!
select name,sequence#, first_time,next_time,applied from v$archived_log
order by sequence#
NAME
SEQUENCE# FIRST_TIM NEXT_TIME APP
--------------------------------------------------------------------------------
---------- --------- --------- ---
/u04/backup/1_1464_643745266.dbf
1464 02-JUN-08 02-JUN-08 YES
/home/oracle/oracle/product/10.2.0/db_2/flash_recovery_area/TRIPLESPROD/archivel
1465 02-JUN-08 02-JUN-08 NO
og/2008_06_02/o1_mf_1_1465_448yf92c_.arc
/u04/backup/1_1465_643745266.dbf
1465 02-JUN-08 02-JUN-08 YES
/home/oracle/oracle/product/10.2.0/db_2/flash_recovery_area/TRIPLESPROD/archivel
1466 02-JUN-08 03-JUN-08 NO
og/2008_06_03/o1_mf_1_1466_448yw2ho_.arc
/u04/backup/1_1466_643745266.dbf
1466 02-JUN-08 03-JUN-08 YES
/home/oracle/oracle/product/10.2.0/db_2/flash_recovery_area/TRIPLESPROD/archivel
1467 03-JUN-08 03-JUN-08 NO
og/2008_06_03/o1_mf_1_1467_44b01n4c_.arc
/u04/backup/1_1467_643745266.dbf
1467 03-JUN-08 03-JUN-08 YES
/home/oracle/oracle/product/10.2.0/db_2/flash_recovery_area/TRIPLESPROD/archivel
1468 03-JUN-08 03-JUN-08 NO
og/2008_06_03/o1_mf_1_1468_44by5q87_.arc
/u04/backup/1_1468_643745266.dbf
1468 03-JUN-08 03-JUN-08 YES
/home/oracle/oracle/product/10.2.0/db_2/flash_recovery_area/TRIPLESPROD/archivel
1469 03-JUN-08 03-JUN-08 NO
og/2008_06_03/o1_mf_1_1469_44chg018_.arc
/u04/backup/1_1469_643745266.dbf
1469 03-JUN-08 03-JUN-08 YES
/home/oracle/oracle/product/10.2.0/db_2/flash_recovery_area/TRIPLESPROD/archivel
1470 03-JUN-08 04-JUN-08 NO
og/2008_06_03/o1_mf_1_1470_44cm6577_.arc
/u04/backup/1_1470_643745266.dbf
1470 03-JUN-08 04-JUN-08 YES
51 rows selected.
--
Howard A. Latham
Unclassifiable DBA
Other related posts:
