Data Guard

Building a Physical Standby Database (01/14) – Install an empty database on standby

Posted on
Go Back to Overview Page – Building a Physical Standby Database (00/14) – An OverviewAssuming the db_name is already there for the running primary database, so you only need to name db_unique_name for the standby database before installation. In this case, we have names initially as following:# Initialization parameters on Primary DB…*.db_name=’compdb’*.db_unique_name=’primdb’…# Initialization parameters on […]
ASM

How to Clean ASM Candidate Disks

Posted on
OS administrator might claim the candidate disks prepared for you to install ASM are newly created and very clean. But if they are not, then, you will meet failure during installing ASM, and never know the reason.Maybe you can mount the ASM diskgroup through ASMCA if you decide to ignore the error, but you will still […]
Listener

How to Resolve ORA-12537:TNS:connection closed

Posted on
ORA-12537 Overview There’re several possible causes to raise ORA-12537: Incorrect File Permission White or Black List ORA-12537 Caused by Incorrect File Permission Incorrect file permission will prevent connections from being established. That is to say, potentially successful connections will be interrupted by ORA-12537 due to wrong file permissions, specifically, the execution permission. As a result, […]
RAC

How to Automatically Startup RAC Database after System Reboots

Posted on
After installing grid infrastructure, you will have Oracle Clusterware, also called Cluster Ready Service, CRS controls all Oracle cluster components as resources, and manages the dependencies among resources, so it can coordinate their start and stop priority. Restarting a database server will bring CRS up (ohasd), once CRS is up, CRS will arrange the resources […]
Data Guard

How to Resolve ORA-16649 after a Fast-Start Failover

Posted on
After a fast-start failover, the broker will try to reinstate the standby database (former primary database) for sustaining data guard architecture. While reinstating, the broker startup only one node of RAC to perform transportation service, which will remain the other node of RAC in mount state. Even when the primary role has been switched back, […]
Data Guard

How to Implement Fast-Start Failover 11g

Posted on
Before enabling fast-start failover in data guard broker, the only required precondition is enabling Flashback Database. But before enabling Flashback Database, you must enable Flash Recovery Area (FRA). The other configurations that are not required but they might make your fast-start failover go smoothly.Set FastStartFailoverTarget on a database which is the target database to be switched […]
Data Guard

How to Failover to a Standby Database Manually and Rebuild Data Guard – By Example

Posted on
Since a fast-start failover (automatic failover) could become a false failover when the observer or the standby database cannot connect to the primary database within a specific time, which may cost the database to lose some transactions followed by reinstating or recreating the standby database (the former primary database).Therefore, it could be a bad idea […]