Discussion :

[mboubidi]

Bonjour,
j'ai crée une BD Standby 9i mais au moment de l'application des archivelogs j'ai remarquer les erreurs suivantes sur les alertes:

Primary:

Error 1010 detaching RFS from standby instance at host 'SBPOS'
*** 2010-04-02 15:38:30.700 43890 kcrr.c
Making upidhs request to NetServer 0 (hst 0x80000001005869d0)
NetServer pid:29831
*** 2010-04-02 15:38:30.700 44114 kcrr.c
upidhs done status 1010
*** 2010-04-02 15:38:30.700
LGWR: Error 1010 disconnecting from destination LOG_ARCHIVE_DEST_2 standby host 'SBPOS'
*** 2010-04-02 15:38:30.700
LGWR: Destination LOG_ARCHIVE_DEST_2 not using standby redo logfiles; cannot reconnect
Archive destination LOG_ARCHIVE_DEST_2 made inactive: File close error
*** 2010-04-02 15:38:30.700
LGWR: Error 1010 closing archivelog file 'SBPOS'
*** 2010-04-02 15:38:30.700
kcrrfail: dest:2 err:1010 force:0
ORA-01010: invalid OCI operation

Standby:

RFS: Possible network disconnect with primary database
Fri Apr 2 14:59:55 2010
Restarting dead background process QMN0
QMN0 started with pid=14
Fri Apr 2 15:04:22 2010
RFS: Possible network disconnect with primary database
Fri Apr 2 15:05:10 2010
Restarting dead background process QMN0
QMN0 started with pid=14
Fri Apr 2 15:10:25 2010
Restarting dead background process QMN0
QMN0 started with pid=15
Fri Apr 2 15:10:31 2010
RFS: Possible network disconnect with primary database

est ce que vous pouvez m'aider afin de réglé ce problème.
je vous remercie pour votre support.

salutations.

[mboubidi]

j'ai aussi cette erreur sur lastandby quand je redémarre la primary:

RFS: Possible network disconnect with primary database
Closing latent archivelog for thread 1 sequence 19
EOF located at block 133 low SCN 0:259830 next SCN 0:259932
Latent archivelog '/posa_arch_log/REPO/archive/SBPOS_1_19.log'
If you wish to failover to this standby database, you should use the
following command to manually register the archivelog for recovery:
ALTER DATABASE REGISTER LOGFILE '/posa_arch_log/REPO/archive/SBPOS_1_19.log';
Fri Apr 2 15:40:00 2010
RFS: Possible network disconnect with primary database

[mboubidi]

Bonjour,
le problème est réglé, au moment du reboot de la BD il demande un ancien fichier manquant,
PS: heureusement qu'on a RMAN

Merci beaucoup.