Bonjour à tous,

J'ai installé un Data Guard Oracle 11G Entreprise Edition sous Red-Hat 5.
Tout fonctionne correctement.

Je veux mettre en place le "ACTIVE" Data Guard.

Lorsque je tape les commandes :
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
alter database recover managed standby database cancel;
alter database open read only;
alter database recover managed standby database using current logfile disconnect;
J'obtiens ceci dans mon fichier d'alertes :
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
Fri Jun 05 08:24:17 2009
alter database recover managed standby database cancel
Fri Jun 05 08:24:17 2009
MRP0: Background Media Recovery cancelled with status 16037
Errors in file /u01/app/oracle/diag/rdbms/stbbpls/BPLS/trace/BPLS_mrp0_5305.trc:
ORA-16037: user requested cancel of managed recovery operation
Managed Standby Recovery not using Real Time Apply
Shutting down recovery slaves due to error 16037
Recovery interrupted!
Recovered data files to a consistent state at change 1765252
Waiting for MRP0 pid 5305 to terminate
Errors in file /u01/app/oracle/diag/rdbms/stbbpls/BPLS/trace/BPLS_mrp0_5305.trc:
ORA-16037: user requested cancel of managed recovery operation
MRP0: Background Media Recovery process shutdown (BPLS)
Managed Standby Recovery Canceled (BPLS)
Completed: alter database recover managed standby database cancel
alter database open read only
ORA-1531 signalled during: alter database open read only...
Fri Jun 05 08:31:50 2009
alter database recover managed standby database using current logfile disconnect
Attempt to start background Managed Standby Recovery process (BPLS)
Fri Jun 05 08:31:50 2009
MRP0 started with pid=19, OS id=29943
MRP0: Background Managed Standby Recovery process started (BPLS)
Fast Parallel Media Recovery enabled
Managed Standby Recovery starting Real Time Apply
 parallel recovery started with 3 processes
Waiting for all non-current ORLs to be archived...
Media Recovery Waiting for thread 1 sequence 65 (in transit)
Recovery of Online Redo Log: Thread 1 Group 5 Seq 65 Reading mem 0
  Mem# 0: /oradata/BPLS/stbredo02.log
Completed: alter database recover managed standby database using current logfile disconnect
Le "ACTIVE" Data Guard fonctionne, mais je ne comprend pas pourquoi le ORA-1531.

Merci pour les réponses.