duplicated archived redologs in Dataguard.
Date: Wed, 4 Jun 2008 10:43:13 +0100
Message-ID: <713d96d10806040243o2e75d149p18a8dfa614534262@mail.gmail.com>
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 -- http://www.freelists.org/webpage/oracle-lReceived on Wed Jun 04 2008 - 04:43:13 CDT