Discussion :

[ducho]

Bonjour,

Sur une base de test sous oracle 11gR2, le répertoire
oracle\diag\rdbms\test11g\test11g\sweep
est plein de fichier avec l'extension .swp .

les premiers fichiers datent du 14/02/2011 .

Cette base ne répondait plus depuis cette date .

Au redémarrage du serveur et donc de la base, tous les fichiers
ont disparu , messages dans l'alertlog :

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
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
 
Sweep [inc][5983]: completed
Sweep [inc][5982]: completed
Sweep [inc][5981]: completed
Sweep [inc][5980]: completed
Sweep [inc][5979]: completed
Sweep [inc][5978]: completed
Sweep [inc][5977]: completed
Sweep [inc][5976]: completed
Sweep [inc][5975]: completed
Sweep [inc][5974]: completed
Sweep [inc][5973]: completed
Sweep [inc][5972]: completed
Sweep [inc][5971]: completed
Successfully onlined Undo Tablespace 2.
Sweep [inc][5970]: completed
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
Tue Feb 22 16:23:37 2011
SMON: enabling tx recovery
Database Characterset is WE8MSWIN1252
Sweep [inc][5969]: completed
Sweep [inc][5968]: completed
Sweep [inc][5967]: completed
Sweep [inc][5966]: completed
No Resource Manager plan active
Sweep [inc][5965]: completed
Sweep [inc][5964]: completed
Sweep [inc][5963]: completed
Sweep [inc][5962]: completed
Sweep [inc][5961]: completed
Sweep [inc][5960]: completed
Sweep [inc][5959]: completed
Sweep [inc][5958]: completed
Sweep [inc][5957]: completed
Sweep [inc][5956]: completed
Sweep [inc][5955]: completed
Tue Feb 22 16:23:38 2011
replication_dependency_tracking turned off (no async multimaster replication found)
Sweep [inc][5954]: completed
Sweep [inc][5953]: completed
Sweep [inc][5952]: completed
Sweep [inc][5951]: completed
Sweep [inc][5950]: completed
Sweep [inc][5949]: completed
Sweep [inc][5948]: completed
Sweep [inc][5947]: completed
Sweep [inc][5946]: completed
Sweep [inc][5945]: completed
Sweep [inc][5944]: completed
Sweep [inc][5943]: completed
Sweep [inc][5942]: completed
Sweep [inc][5941]: completed
Sweep [inc][5940]: completed
Sweep [inc][5939]: completed
Starting background process QMNC
Tue Feb 22 16:23:40 2011
QMNC started with pid=24, OS id=1940 
Sweep [inc][5938]: completed
Sweep [inc][5937]: completed
Sweep [inc][5936]: completed
Sweep [inc][5935]: completed
Sweep [inc][5934]: completed
Sweep [inc][5933]: completed
Sweep [inc][5932]: completed
Sweep [inc][5931]: completed
Sweep [inc][5930]: completed
Sweep [inc][5929]: completed
Sweep [inc][5928]: completed
Sweep [inc][5927]: completed
Sweep [inc][5926]: completed
Sweep [inc][5925]: completed
Sweep [inc][5924]: completed
Sweep [inc][5923]: completed
Sweep [inc][5922]: completed
Sweep [inc][5921]: completed
Sweep [inc][5920]: completed
Sweep [inc][5919]: completed
Sweep [inc][5918]: completed
Completed: alter database open
Sweep [inc][5917]: completed
Sweep [inc][5916]: completed
Sweep [inc][5915]: completed
Sweep [inc][5914]: completed
Sweep [inc][5913]: completed

je n'ai pas encore trouvé pourquoi la base était plantée .

ma question porte plutôt sur ces messages :

qu' est-ce qu' ils signifient ?
A quoi correspondent ces fichiers dans le dossier sweep?
(apparement, en fonctionnement normal, ce dossier sweep est vide)

J'ai parcouru la doc sans résultat .

cordialement

[Z3phur]

Bonsoir,

apparement les fichiers .swp sont des fichier d'erreur d'oracle, voici ce que j'ai trouvé, je sais c'est maigre mais c'est déjà un début.

http://www.oracle.com/pls/db111/sear...=sweep&partno=