This document covers the DataGuard and DG broker setup.
Disclaimer!!
This blog reflect our own views and do not necessarily represent the views of our current or previous employers.
The contents of this blog are from our experience, you may use at your own risk, however you are strongly advised to cross reference with Product documentation and test before deploying to production environments.
Recent Comments
- Prabhav Pushkar on MGMTDB: Grid Infrastructure Management Repository
- Azure BLOB Storage As Remote Backend for Terraform State File - AskDba.org Weblog on Azure Infrastructure Automation With Terraform: Configuration
- tolu on 11g: Multiple failed login attempt can block New Application connections
- venkatesh on Retrieving Database SID,Port information from Grid Control repository
- Patrick on Solving ORA-1031 while connecting as “/ as sysdba” :
Trending
- Resolving Shutdown Immediate Hang Situations
- Identifying PostgreSQL Bloat and fixing it without downtime
- Simplified Approach to Resolve ORA-4031
- LGWR terminating instance due to error 338
- Allocation Unit and Extents In ASM
- How To Recover From Corrupted OCR Disk
- Querying RDS PostgreSQL logs using Amazon Athena
Subscribe to Blog via Email
Join 188 other subscribers
Dear All,
I have Oracle 11.2.0 database installed on RHEL5 with 1 phy standby Database…Now I want to remove that Stdby DB , So please provide me the procedure & steps.
Ashish,
You can remove log_archive_config and log_archive_dest* (except log_archive_dest_1 i.e local archiving). This should remove config from primary side. Next you can drop the standby database. There is not much steps for this.
Regards
Amit
Thanks Amit,
IS it require to remove FAL_Serevr/Client and standby_file_managemnt=auto and log files?
You can remove FAL_SERVER and FAL_CLIENT though they dont work without log_archive_config. standby_file_management is again applicable only when db is running in standby mode.
Dear Amit,
I have 1 DG at 11.2 g setup where we have two standby DB one on cloud with primary and one on local. Now i am find that my prod database table are updated but it’s not updated on local Stdby (log seq are updated.).. how to update table on local stdby DB?
Plz guide me.
Regards,
Ashish