Standby Database - redo apply
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Standby Database - redo apply

  1. #1
    Join Date
    Apr 2001
    Location
    Vadodara, India
    Posts
    249

    Standby Database - redo apply

    Dear All,

    I have configured oracle physical standby database for Quality server for testing

    I have done one transaction on primary server. I have saved the transaction. On another screen I have ready with
    command "ALTER DATABASE RECOMVER MANAGED STANDBY DATABASE CANCEL".

    As soon as I received a document number generated by transaction complition on primary server. I execute the command on next screen realted to cancel managed recover. I have checked in relavant table but transaction is no applied on standby database.

    In tesing of some cases it is saved in standby DB.

    What to do for real time apply.

    I have created standby redolog files on standby database. Standby database is in managed recovery mode.

    Part of the initilization parameter relavant to standby configuration are as below:

    *********************************
    Primary :

    --------------------------------------------------------------------------------
    log_archive_dest_state_1=enable
    log_archive_dest_1='LOCATION=/softdump/oraarch/'
    log_archive_dest_state_2=ENABLE
    LOG_ARCHIVE_DEST_2='SERVICE=QASST LGWR SYNC AFFIRM'
    SERVICE_NAMES=QASPR
    FAL_SERVER=QASPR
    FAL_CLIENT=QASST

    ***********************************************

    *********************************
    Standby :



    --------------------------------------------------------------------------------
    log_archive_dest='/oracle/PRD/sapdata4/QAS/stby'
    STANDBY_ARCHIVE_DEST='/oracle/PRD/oraarch'
    FAL_SERVER=QASPR
    FAL_CLIENT=QASST
    STANDBY_FILE_MANAGEMENT=auto
    *********************************

    Regards,

    Nirav

  2. #2
    Join Date
    Oct 2008
    Posts
    15
    what is command you are using to start media recovery?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width