Base Standby : Max(sequence#) trop différents
Bonjour à tous.
J'ai un souci avec ma base Standby. Je fais :
Code:
select max(sequence#) from v$archived_log
Ca donne 3293 sur la base primaire, et 2025 sur la base standby. Trop de différence évidemment.
Voici un extrait des alrt.log :
Sur la base primaire :
Citation:
Sun Apr 20 16:27:38 2008
starting up 1 shared server(s) ...
starting up 2 dispatcher(s) for network address '(ADDRESS=(PROTOCOL=TCP)(HOST=db5.ais-mada.lan)(PORT=1521))'...
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=21
ARC0: Archival started
Sun Apr 20 16:27:39 2008
ARCH: STARTING ARCH PROCESSES COMPLETE
Sun Apr 20 16:27:40 2008
alter database mount
Sun Apr 20 16:27:44 2008
Successful mount of redo thread 1, with mount id 1525635904.
Sun Apr 20 16:27:44 2008
Database mounted in Exclusive Mode.
Completed: alter database mount
Sun Apr 20 16:27:44 2008
alter database open
Sun Apr 20 16:27:48 2008
Thread 1 opened at log sequence 2025
Current log# 4 seq# 2025 mem# 0: E:\ORACLE\ORADATA\ORACLE\REDO04.LOG
Current log# 4 seq# 2025 mem# 1: F:\ORACLE\ORADATA\ORACLE\REDO04.LOG
Successful open of redo thread 1.
Sun Apr 20 16:27:49 2008
SMON: enabling cache recovery
SMON: enabling tx recovery
Sun Apr 20 16:28:06 2008
Completed: alter database open
Sun Apr 20 16:29:30 2008
Thread 1 advanced to log sequence 2026
Current log# 6 seq# 2026 mem# 0: E:\ORACLE\ORADATA\ORACLE\REDO06.LOG
Current log# 6 seq# 2026 mem# 1: F:\ORACLE\ORADATA\ORACLE\REDO06.LOG
Sun Apr 20 16:29:30 2008
ARC0: Beginning to archive log# 4 seq# 2025
ARC0: Completed archiving log# 4 seq# 2025
Et sur la Standby :
Citation:
Sun Apr 20 16:26:39 2008
alter database mount standby database
Sun Apr 20 16:26:46 2008
Successful mount of redo thread 1, with mount id 1525629958.
Sun Apr 20 16:26:46 2008
Standby Database mounted.
Completed: alter database mount standby database
Sun Apr 20 16:26:46 2008
ALTER DATABASE RECOVER managed standby database
Media Recovery Start: Managed Standby Recovery
Media Recovery Log
Media Recovery Waiting for thread 1 seq# 2025
Sun Apr 20 16:29:38 2008
Media Recovery Log F:\ORACLE\ORADATA\ORACLE\STDBY_ARCHIVE\ARC02025.001
Media Recovery Waiting for thread 1 seq# 2026
Je ne comprends pas pourquoi le log de la base primaire indique Current log# 6 seq# 2026 mem# alors que max(sequence#) donne 3293.
Quelqu'un pourrait-il m'aider?
Merci d'avance.