boa tarde, 
 tive um probrlema com um standby dataguard, 
 copiei os datafiles do produção para o standby e crio o standby controlfile 
novamente, 
 porem quando mando sincronizar recebo as seguintes mensagens no alert.log
 

 embora a sequencia scn fique a mesma do produção. 
 

 SQL> select max(Sequence#) from v$log_history;           
 

 MAX(SEQUENCE#)
 --------------
 34577
 

 alert.log: 
 

 Managed Standby Recovery not using Real Time Apply
 Parallel Media Recovery started with 2 slaves
 Waiting for all non-current ORLs to be archived...
 All non-current ORLs have been archived.
 Clearing online redo logfile 1 /u01/DATAFILE/wint/redo01.log
 Clearing online log 1 of thread 1 sequence number 34601
 Errors in file /u01/app/oracle/diag/rdbms/wint2/wint/trace/wint_mrp0_1349.trc:
 ORA-19527: physical standby redo log must be renamed
 ORA-00312: online log 1 thread 1: '/u01/DATAFILE/wint/redo01.log'
 Clearing online redo logfile 1 complete
 Media Recovery Waiting for thread 1 sequence 33746
 Fetching gap sequence in thread 1, gap sequence 33746-33845
 Completed: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM 
SESSION
 Sun Jul 19 11:44:20 2015
 FAL[client]: Failed to request gap sequence
  GAP - thread 1 sequence 33746-33845
  DBID 1488913721 branch 838657595
 FAL[client]: All defined FAL servers have been attempted.
 GAP - thread 1 sequence 33746-33845
  DBID 1488913721 branch 838657595
 FAL[client]: All defined FAL servers have been attempted.
 -------------------------------------------------------------
 Check that the CONTROL_FILE_RECORD_KEEP_TIME initialization
 parameter is defined to a value that is sufficiently large
 enough to maintain adequate log switch information to resolve
 archivelog gaps.
 

 
 o standyby copias os archives para a pasta de destino nele, mas nao aplica. 
 

 

Responder a