Bonjour à tous,

voilà depuis quelque jours, le fichier alert de la SDB m'envoie des erreurs telles quelles :
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
 
Media Recovery Log F:\ORACLE\ORADATA\PROD\ARCHIVE\ARCH001_51628.ARC
Media Recovery Waiting for thread 1 seq# 51629
Tue Sep 19 17:34:55 2006
Media Recovery failed with error 3113
ORA-283 signalled during: ALTER DATABASE RECOVER   managed standby database
...
Tue Sep 19 18:29:47 2006
ALTER DATABASE RECOVER   managed standby database cancel
 
Tue Sep 19 18:29:47 2006
Sustained Standby Recovery Cancelled
Completed: ALTER DATABASE RECOVER   managed standby database 
Tue Sep 19 18:30:27 2006
ALTER DATABASE RECOVER   standby database
 
Tue Sep 19 18:30:27 2006
Media Recovery Start
Media Recovery Log 
ORA-279 signalled during: ALTER DATABASE RECOVER   standby database
  ...
Tue Sep 19 18:30:32 2006
ALTER DATABASE RECOVER    CONTINUE DEFAULT  
Media Recovery Log F:\ORACLE\ORADATA\PROD\ARCHIVE\ARCH001_51629.ARC
ORA-279 signalled during: ALTER DATABASE RECOVER    CONTINUE DEFAULT  ...
Tue Sep 19 18:30:48 2006
ALTER DATABASE RECOVER    CONTINUE DEFAULT  
Tue Sep 19 18:30:48 2006
Media Recovery Log F:\ORACLE\ORADATA\PROD\ARCHIVE\ARCH001_51630.ARC
ORA-279 signalled during: ALTER DATABASE RECOVER    CONTINUE DEFAULT  ...
Tue Sep 19 18:30:58 2006
ALTER DATABASE RECOVER    CONTINUE DEFAULT  
Media Recovery Log F:\ORACLE\ORADATA\PROD\ARCHIVE\ARCH001_51631.ARC
ORA-279 signalled during: ALTER DATABASE RECOVER    CONTINUE DEFAULT  ...
Tue Sep 19 18:31:06 2006
ALTER DATABASE RECOVER    CONTINUE DEFAULT  
Media Recovery Log F:\ORACLE\ORADATA\PROD\ARCHIVE\ARCH001_51632.ARC
ORA-308 signalled during: ALTER DATABASE RECOVER    CONTINUE DEFAULT  ...
Tue Sep 19 18:31:06 2006
ALTER DATABASE RECOVER CANCEL
Media Recovery Cancelled
Completed: ALTER DATABASE RECOVER CANCEL
Tue Sep 19 18:31:54 2006
ALTER DATABASE RECOVER   managed standby database
 
Tue Sep 19 18:31:54 2006
Media Recovery Start: Managed Standby Recovery
Media Recovery Log 
Media Recovery Waiting for thread 1 seq# 51632
Tue Sep 19 18:33:09 2006
Media Recovery Log F:\ORACLE\ORADATA\PROD\ARCHIVE\ARCH001_51632.ARC
Media Recovery Waiting for thread 1 seq# 51633
Tue Sep 19 18:33:41 2006
Media Recovery Log F:\ORACLE\ORADATA\PROD\ARCHIVE\ARCH001_51633.ARC
Media Recovery Waiting for thread 1 seq# 51634
Tue Sep 19 18:34:11 2006
Media Recovery Log F:\ORACLE\ORADATA\PROD\ARCHIVE\ARCH001_51634.ARC
Media Recovery Waiting for thread 1 seq# 51635
Tue Sep 19 18:51:14 2006
Media Recovery failed with error 3113
ORA-283 signalled during: ALTER DATABASE RECOVER   managed standby database
...
Lorsque je met fin au recover managed, je joue les fichiers archives en recover manuel ==> aucun soucis, et je remet le recover en managed. A ce moment, je force des switch logfile sur base source, et les archives sont bien appliqués. Mais au bout d'une vingtaine de minutes les erreurs reviennent.

Les explications des erreurs au niveau d'Oracle sont vagues.

D'où cela peut-il venir ???

Merci pour vos réponses.