-
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.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|