Discussion :

[ilalaina]

Bonjour à tous.

Je viens de recréer ma base par export/import afin de défragmenter les données.
(Oracle 8i)
J'ai une base primaire et une base de données de secours Standby (standbydb2)

Ensuite, j'ai une transaction qui commence par :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

set transaction use rollback segment RBS9

Ensuite la base plante et ci-dessous les erreurs dans alrt.log:

Mon May 25 19:45:00 2009
Thread 1 advanced to log sequence 41634
Current log# 2 seq# 41634 mem# 0: D:\ORACLE\ORADATA\ORACLE\REDO02.LOG
Mon May 25 19:45:00 2009
ARC2: Beginning to archive log# 1 seq# 41633
ARC2: Error 12571 creating standby archivelog file at host 'standbydb2'
ARC2: Error 12571 creating archivelog file 'standbydb2'
ARC2: Failed to archive log# 1 seq# 41633
ARCH: Archival stopped, error occurred. Will continue retrying
ARCH:
ORA-16038: le journal 1 séquence 41633 ne peut pas être archivé
ORA-00000: Exécution normale, réussie
ORA-00312: journal en ligne 1 thread 1 : 'D:\ORACLE\ORADATA\ORACLE\REDO01.LOG'
Mon May 25 19:45:01 2009
Thread 1 advanced to log sequence 41635
Current log# 3 seq# 41635 mem# 0: D:\ORACLE\ORADATA\ORACLE\REDO03.LOG
Mon May 25 19:45:02 2009
ARC0: Beginning to archive log# 1 seq# 41633
ARC0: Archiving not possible: No available destinations
ARC0: Failed to archive log# 1 seq# 41633
ARCH: Archival stopped, error occurred. Will continue retrying
ARCH:
ORA-16014: le journal 1 sequence 41633 n'est pas archive car il n'y a pas de destination disponible
ORA-00312: journal en ligne 1 thread 1 : 'D:\ORACLE\ORADATA\ORACLE\REDO01.LOG'
Mon May 25 19:45:02 2009
Thread 1 cannot allocate new log, sequence 41636
Checkpoint not complete
Current log# 3 seq# 41635 mem# 0: D:\ORACLE\ORADATA\ORACLE\REDO03.LOG
Thread 1 cannot allocate new log, sequence 41636
All online logs needed archiving
Mon May 25 19:45:04 2009
ARC1: Beginning to archive log# 1 seq# 41633
Mon May 25 19:45:04 2009
Current log# 3 seq# 41635 mem# 0: D:\ORACLE\ORADATA\ORACLE\REDO03.LOG
Mon May 25 19:45:04 2009
ARC1: Archiving not possible: No available destinations
ARC1: Failed to archive log# 1 seq# 41633
Mon May 25 19:45:05 2009
ARC2: Beginning to archive log# 1 seq# 41633
ARC2: Archiving not possible: No available destinations
ARC2: Failed to archive log# 1 seq# 41633
Mon May 25 19:45:06 2009
ARC0: Beginning to archive log# 1 seq# 41633
ARC0: Archiving not possible: No available destinations
ARC0: Failed to archive log# 1 seq# 41633
Mon May 25 19:45:07 2009
ARC1: Beginning to archive log# 1 seq# 41633
ARC1: Archiving not possible: No available destinations
ARC1: Failed to archive log# 1 seq# 41633
Mon May 25 19:45:08 2009
ARC2: Beginning to archive log# 1 seq# 41633
ARC2: Archiving not possible: No available destinations
ARC2: Failed to archive log# 1 seq# 41633
Mon May 25 19:45:09 2009
ARC0: Beginning to archive log# 1 seq# 41633
ARC0: Archiving not possible: No available destinations
ARC0: Failed to archive log# 1 seq# 41633
Mon May 25 19:45:09 2009
ARC1: Beginning to archive log# 1 seq# 41633
ARC1: Archiving not possible: No available destinations
ARC1: Failed to archive log# 1 seq# 41633
Mon May 25 19:45:10 2009
ARC2: Beginning to archive log# 1 seq# 41633
ARC2: Archiving not possible: No available destinations
ARC2: Failed to archive log# 1 seq# 41633
Mon May 25 19:45:10 2009


.............


Mon May 25 19:51:11 2009
ARC0: Beginning to archive log# 3 seq# 41638
ARC0: Failed to archive log# 3 seq# 41638
Mon May 25 19:51:12 2009
ARC2: Completed archiving log# 3 seq# 41638
Mon May 25 19:52:00 2009
Thread 1 advanced to log sequence 41640
Current log# 2 seq# 41640 mem# 0: D:\ORACLE\ORADATA\ORACLE\REDO02.LOG
Mon May 25 19:52:00 2009
ARC2: Beginning to archive log# 1 seq# 41639
ARC2: Completed archiving log# 1 seq# 41639
Mon May 25 19:55:21 2009
Shutting down instance (immediate)
License high water mark = 136
Mon May 25 19:55:47 2009
Starting ORACLE instance (normal)
Mon May 25 19:56:27 2009
Errors in file D:\oracle\admin\oracle\udump\ORA01480.TRC:

et le fichier D:\oracle\admin\oracle\udump\ORA01480.TRC: est en pièce jointe.

Pourriez-vous me venir en aide si vous aviez déjà rencontré le même problème?

Merci d'avance.