Discussion :

[dari68]

Après la création d'une dataguard sur la même machine (distrib 10.2.0.4),
les archives ne sont pas transferées sur la standby, voici ma config:

Sur la primaire:

SQL> sho parameter fal

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
fal_client string PRIMAIRE
fal_server string STANDBY
SQL>

SQL> sho parameter archive_dest

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest string
log_archive_dest_1 string LOCATION=/oradata/base/backup/
PRIMAIRE/arch VALID_FOR=(ALL_LOG
FILES,ALL_ROLES) db_unique_nam
e=PRIMAIRE

log_archive_dest_2 string SERVICE=PRIMAIRE VALID_FOR=(ON
LINE_LOGFILES,PRIMARY_ROLE) LGW

log_archive_dest_state_1 string enable

log_archive_dest_state_2 string enable


standby_archive_dest string /oradata/base/backup/PRIMAIRE/ar
ch
=============================
Sur la standby:

SQL> sho parameter fal

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
fal_client string STANDBY
fal_server string PRIMAIRE
SQL>
SQL> sho parameter archive_dest

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest string
log_archive_dest_1 string LOCATION=/oradata/base/backup/
STANDBY/arch/
VALID_FOR=(ALL_LOGFILES,ALL_RO
LES) db_unique_name=STANDBY

log_archive_dest_2 string SERVICE=PRIMAIRE LGWR ASYNC
VALID_FOR=(ONLINE_LOGFILES,PRI
MARY_ROLE)
DB_UNIQUE_NAME=PRIMAIRE



log_archive_dest_state_1 string enable

log_archive_dest_state_2 string enable



standby_archive_dest string /oradata/base/backup/STANDBY/arch

SQL>

Les 2 services: STANDBY et PRIMAIRE sont OK (connexion via tns ok).

Merci.

[scheu]

quels sont les erreurs dans les fichiers alert.log de tes 2 bases ?

[dari68]

Bonjour,

Completed: ALTER DATABASE MOUNT
Wed Dec 24 09:34:04 2008
ALTER DATABASE OPEN
Wed Dec 24 09:34:04 2008
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=15, OS id=2949260
Wed Dec 24 09:34:04 2008
ARC0: Archival started
ARC1: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC1 started with pid=16, OS id=2728018
LNS1 started with pid=17, OS id=2109518
Wed Dec 24 09:34:07 2008
Thread 1 advanced to log sequence 590 (thread open)
Wed Dec 24 09:34:07 2008
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
Wed Dec 24 09:34:07 2008
ARC0: Becoming the heartbeat ARCH
Wed Dec 24 09:34:07 2008
Thread 1 opened at log sequence 590
Current log# 2 seq# 590 mem# 0: /oradata/base/PRIMAIRE/redo02.log
Successful open of redo thread 1
Wed Dec 24 09:34:07 2008
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Wed Dec 24 09:34:07 2008
******************************************************************
LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_2
******************************************************************
Wed Dec 24 09:34:07 2008
SMON: enabling cache recovery
Wed Dec 24 09:34:07 2008
Errors in file /oradata/base/admin/PRIMAIRE/bdump/PRIMAIRE_arc0_2949260.trc:
ORA-16057: DGID from server not in Data Guard configuration
Wed Dec 24 09:34:07 2008
FAL[server, ARC0]: Error 16057 creating remote archivelog file 'PRIMAIREBK'
FAL[server, ARC0]: FAL archive failed, see trace file.
Wed Dec 24 09:34:07 2008
Errors in file /oradata/base/admin/PRIMAIRE/bdump/PRIMAIRE_arc0_2949260.trc:
ORA-16055: FAL request rejected
ARCH: FAL archive failed. Archiver continuing
Wed Dec 24 09:34:07 2008
ORACLE Instance PRIMAIRE - Archival Error. Archiver continuing.
Wed Dec 24 09:34:07 2008
LGWR: Error 16057 creating archivelog file 'PRIMAIREBK'
Wed Dec 24 09:34:07 2008
Errors in file /oradata/base/admin/PRIMAIRE/bdump/PRIMAIRE_lns1_2109518.trc:
ORA-16057: DGID from server not in Data Guard configuration
stdin

LNS: Failed to archive log 2 thread 1 sequence 590 (16057)
Wed Dec 24 09:34:07 2008
Successfully onlined Undo Tablespace 1.
Wed Dec 24 09:34:07 2008
SMON: enabling tx recovery
Wed Dec 24 09:34:07 2008
Database Characterset is WE8ISO8859P15
Opening with internal Resource Manager plan
where NUMA PG = 1, CPUs = 4
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=18, OS id=3076184
Wed Dec 24 09:34:09 2008
Completed: ALTER DATABASE OPEN
Wed Dec 24 09:34:09 2008
Errors in file /oradata/base/admin/PRIMAIRE/bdump/PRIMAIRE_mmon_2990094.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 209715200 bytes is 99.30% used, and has 1458176 remaining bytes a
vailable.
Wed Dec 24 09:34:09 2008
************************************************************************
You have following choices to free up space from flash recovery area:
1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
then consider changing RMAN ARCHIVELOG DELETION POLICY.
2. Back up files to tertiary device such as tape using RMAN

2. Back up files to tertiary device such as tape using RMAN
BACKUP RECOVERY AREA command.
3. Add disk space and increase db_recovery_file_dest_size parameter to
reflect the new space.
4. Delete unnecessary files using RMAN DELETE command. If an operating
system command was used to delete files, then use RMAN CROSSCHECK and
DELETE EXPIRED commands.
************************************************************************
Wed Dec 24 09:34:20 2008
ALTER SYSTEM ARCHIVE LOG
Wed Dec 24 09:34:20 2008
Thread 1 advanced to log sequence 591 (LGWR switch)
Current log# 3 seq# 591 mem# 0: /oradata/base/PRIMAIRE/redo03.log
Wed Dec 24 09:34:20 2008
ARCH: Archivelog destination LOG_ARCHIVE_DEST_2 disabled: destination Data Guard configuration error
stcdev1 @oracle:/oradata/base/admin/PRIMAIRE/bdump
>

Merci.

[dari68]

En redefinissant la même config, le probleme est resolu.

Joyeuses fêtes à tous.

[dari68]

Bonjour,

Completed: ALTER DATABASE MOUNT
Wed Dec 24 09:34:04 2008
ALTER DATABASE OPEN
Wed Dec 24 09:34:04 2008
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=15, OS id=2949260
Wed Dec 24 09:34:04 2008
ARC0: Archival started
ARC1: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC1 started with pid=16, OS id=2728018
LNS1 started with pid=17, OS id=2109518
Wed Dec 24 09:34:07 2008
Thread 1 advanced to log sequence 590 (thread open)
Wed Dec 24 09:34:07 2008
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
Wed Dec 24 09:34:07 2008
ARC0: Becoming the heartbeat ARCH
Wed Dec 24 09:34:07 2008
Thread 1 opened at log sequence 590
Current log# 2 seq# 590 mem# 0: /oradata/base/PRIMAIRE/redo02.log
Successful open of redo thread 1
Wed Dec 24 09:34:07 2008
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Wed Dec 24 09:34:07 2008
******************************************************************
LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_2
******************************************************************
Wed Dec 24 09:34:07 2008
SMON: enabling cache recovery
Wed Dec 24 09:34:07 2008
Errors in file /oradata/base/admin/PRIMAIRE/bdump/PRIMAIRE_arc0_2949260.trc:
ORA-16057: DGID from server not in Data Guard configuration
Wed Dec 24 09:34:07 2008
FAL[server, ARC0]: Error 16057 creating remote archivelog file 'PRIMAIREBK'
FAL[server, ARC0]: FAL archive failed, see trace file.
Wed Dec 24 09:34:07 2008
Errors in file /oradata/base/admin/PRIMAIRE/bdump/PRIMAIRE_arc0_2949260.trc:
ORA-16055: FAL request rejected
ARCH: FAL archive failed. Archiver continuing
Wed Dec 24 09:34:07 2008
ORACLE Instance PRIMAIRE - Archival Error. Archiver continuing.
Wed Dec 24 09:34:07 2008
LGWR: Error 16057 creating archivelog file 'PRIMAIREBK'
Wed Dec 24 09:34:07 2008
Errors in file /oradata/base/admin/PRIMAIRE/bdump/PRIMAIRE_lns1_2109518.trc:
ORA-16057: DGID from server not in Data Guard configuration
stdin

LNS: Failed to archive log 2 thread 1 sequence 590 (16057)
Wed Dec 24 09:34:07 2008
Successfully onlined Undo Tablespace 1.
Wed Dec 24 09:34:07 2008
SMON: enabling tx recovery
Wed Dec 24 09:34:07 2008
Database Characterset is WE8ISO8859P15
Opening with internal Resource Manager plan
where NUMA PG = 1, CPUs = 4
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=18, OS id=3076184
Wed Dec 24 09:34:09 2008
Completed: ALTER DATABASE OPEN
Wed Dec 24 09:34:09 2008
Errors in file /oradata/base/admin/PRIMAIRE/bdump/PRIMAIRE_mmon_2990094.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 209715200 bytes is 99.30% used, and has 1458176 remaining bytes a
vailable.
Wed Dec 24 09:34:09 2008
************************************************************************
You have following choices to free up space from flash recovery area:
1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
then consider changing RMAN ARCHIVELOG DELETION POLICY.
2. Back up files to tertiary device such as tape using RMAN

2. Back up files to tertiary device such as tape using RMAN
BACKUP RECOVERY AREA command.
3. Add disk space and increase db_recovery_file_dest_size parameter to
reflect the new space.
4. Delete unnecessary files using RMAN DELETE command. If an operating
system command was used to delete files, then use RMAN CROSSCHECK and
DELETE EXPIRED commands.
************************************************************************
Wed Dec 24 09:34:20 2008
ALTER SYSTEM ARCHIVE LOG
Wed Dec 24 09:34:20 2008
Thread 1 advanced to log sequence 591 (LGWR switch)
Current log# 3 seq# 591 mem# 0: /oradata/base/PRIMAIRE/redo03.log
Wed Dec 24 09:34:20 2008
ARCH: Archivelog destination LOG_ARCHIVE_DEST_2 disabled: destination Data Guard configuration error

>

Merci.