Friday, 23 May 2014

Solved when apply tag and transport tag increases


If apply tag and transport tag increases then create standby redo logs in standby db

DGMGRL> show database verbose "PEMSAPMSstdb";

Database - PEMSAPMSstdb

  Role:            PHYSICAL STANDBY
  Intended State:  APPLY-ON
  Transport Lag:   16 hours 48 minutes 27 seconds
  Apply Lag:       16 hours 48 minutes 27 seconds
  Real Time Query: ON
  Instance(s):
    PEMSAPMSstdb


cancel the recovery first before adding

SQL> alter database recover managed standby database cancel ;

SQL> alter database add standby logfile '/backup/flash_recovery_area/TESTPMSSTDB/onlinelog/stdby_o1_mf_3_9qqbp03n_.log' size 209715200;                            
                                                                               
SQL> alter database add standby logfile '/backup/flash_recovery_area/TESTPMSSTDB/onlinelog/stdby_o1_mf_2_9qqbot0k_.log' size 209715200;                            
                                                                               
SQL> alter database add standby logfile '/backup/flash_recovery_area/TESTPMSSTDB/onlinelog/stdby_o1_mf_1_9qqbomkn_.log' size 209715200;

No comments:

Post a Comment