Problem with DG configuration
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Problem with DG configuration

  1. #1
    Join Date
    May 2010
    Posts
    1

    Problem with DG configuration

    Hi,

    I have some problem with DG. After setting up the physical standby database, I got a proper output for the query V$ARCHIVED_LOG. But from next time onwards I am getting the error "ORA-01153: an incompatible media recovery is active" when i do the redo-apply.

    Both my primary and physical standby are on the same server. Below are the configuration details

    On primary:
    *.DB_UNIQUE_NAME='primary'
    *.LOG_ARCHIVE_CONFIG='DG_CONFIG=(primary,stdby)'
    *.log_archive_dest_1='LOCATION=/appdb/oradata/primary_archive
    VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
    DB_UNIQUE_NAME=primary'
    *.log_archive_dest_2='LOCATION=/appdb/oradata/stdby_archive
    VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
    DB_UNIQUE_NAME=stdby'

    On Physical standby:
    *.db_unique_name='stdby'
    *.fal_client='stdby'
    *.fal_server='primary'
    *.log_archive_config='dg_config=(primary,stdby)'
    *.log_archive_dest_1='LOCATION=/appdb/oradata/stdby_archive VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=stdby'
    *.log_archive_dest_2='SERVICE=primary VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=primary'

    Please Suggest me if there needs to be any changes in the configuration. Iam new to DG.

    Naresh.

  2. #2
    Join Date
    Dec 2002
    Posts
    60
    The managed recovery may be running, so you can't recover the database yourself. Check if RFS is running.

    select process, status from v$managed_standby;

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