Hi
I'm trying to setup an physical Standby Database as documented in Oracle® Data Guard, Concepts and Administration
Database is oracle 11.2.0.1.0 .
to copy the database
on Primary Database by rman:
backup database plus archivelog
backup current controlfile for standby
on Standby Database by rman:
connect auxiliary /
connect target sys/xxxxxx@DG (DG ist primary)
run
{
allocate channel c1 device type disk;
allocate auxiliary channel c2 device type disk;
duplicate target database for standby nofilenamecheck dorecover;
}
after restore and mount all redofile are missing on standby database.
The altert file reads:
All non-current ORLs have been archived.
DDE rules only execution for: ORA 313
----- START Event Driven Actions Dump ----
---- END Event Driven Actions Dump ----
----- START DDE Actions Dump -----
Executing SYNC actions
----- START DDE Action: 'DB_STRUCTURE_INTEGRITY_CHECK' (Async) -----
DDE Action 'DB_STRUCTURE_INTEGRITY_CHECK' was flood controlled
----- END DDE Action: 'DB_STRUCTURE_INTEGRITY_CHECK' (FLOOD CONTROLLED, 117255190 csec) -----
Executing ASYNC actions
----- END DDE Actions Dump (total 0 csec) -----
ORA-00313: Member von Log-Gruppe 1 (Thread 1) konnten nicht geöffnet werden
DDE: Problem Key 'ORA 313' was flood controlled (0x1) (no incident)
ORA-00313: Member von Log-Gruppe 2 (Thread 1) konnten nicht geöffnet werden
ORA-00313: Member von Log-Gruppe 2 (Thread 1) konnten nicht geöffnet werden
DDE: Problem Key 'ORA 313' was flood controlled (0x1) (no incident)
ORA-00313: Member von Log-Gruppe 3 (Thread 1) konnten nicht geöffnet werden
ORA-00313: Member von Log-Gruppe 3 (Thread 1) konnten nicht geöffnet werden
[oracle@LinuxDGN02 trace]$ tail -f alert_STAND.log
Waiting for all non-current ORLs to be archived...
All non-current ORLs have been archived.
Errors in file /u01/app/oracle/diag/rdbms/stand/STAND/trace/STAND_mrp0_5491.trc:
ORA-00313: Member von Log-Gruppe 1 (Thread 1) konnten nicht geöffnet werden
Errors in file /u01/app/oracle/diag/rdbms/stand/STAND/trace/STAND_mrp0_5491.trc:
ORA-00313: Member von Log-Gruppe 2 (Thread 1) konnten nicht geöffnet werden
Errors in file /u01/app/oracle/diag/rdbms/stand/STAND/trace/STAND_mrp0_5491.trc:
ORA-00313: Member von Log-Gruppe 3 (Thread 1) konnten nicht geöffnet werden
Media Recovery Waiting for thread 1 sequence 18
Completed: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT
If I issue an alter system switch logfile on primary, nothing happens in target system.
init on standby (DG primary, STAND standby)
*.db_name='DG'
*.db_unique_name='STAND'
*.log_archive_config='DG_CONFIG=(DG,STAND)'
*.fal_server='DG'
*.log_archive_config='DG_CONFIG=(DG,STAND)'
*.log_archive_dest_1='LOCATION=/DATA01/DB/flash/ VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=STAND'
*.log_archive_dest_2='SERVICE=DG ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=DG'
init on primary (DG primary, STAND standby)
*.db_name='DG'
*.db_unique_name='DG'
*.log_archive_config='DG_CONFIG=(DG,STAND)'
*.log_archive_dest_1='LOCATION=/DATA01/DB/flash/archiv/ VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=DG'
*.log_archive_dest_2='SERVICE=STAND ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=STAND'
*.log_archive_dest_state_2='ENABLE'
Any ideas?
Thanks
Christian