To view how to configure Data Guard in OCI please check Configuring Data Guard in Oracle Cloud Infrastructure (OCI) Assumptions: Oracle Data Guard is configured in OCI and it is up, running and synchronized. You can check the dgmgrl configuration before starting switchover by login to the server using Public IP. You can see SKANTORC_iad19m […]
Articles Tagged: Oracle DataGuard
Configuring Fast-Start Fail Over
We have seen overview and prerequisites of fast-start failover in the previous post. Fast Start Failover in Data Guard Steps to configure fast start fail over . Step 1 : Connect to dgmgrl and check the configuration DGMGRL for Linux: Version 11.2.0.4.0 – 64bit Production Copyright (c) 2000, 2009, Oracle. All rights reserved. Welcome to […]
Convert Physical Standby To Snapshot Standby Database
What is snapshot standby: Snapshot standby is a feature in Oracle 11g that allows doing a read-write operation on the standby database. i. e we can convert the physical standby database to snapshot standby. On that, we can do all types of testing or can be used as a development database (which is an exact […]
How to apply PSU patch on standby database
To apply psu patch on physical standby database setup, 1st patch need to be applied on standby, and then on primary. Below are the steps. Download patch from oracle support. Check the database_role for both dbs PRIMARY> select database_role from v$database; DATABASE_ROLE —————- PRIMARY STANDBY> select database_role from v$database; SDATABASE_ROLE —————- PHYSICAL STANDBY 2.Run below […]
ORA-01274: cannot add data file
PROBLEM: After adding a datafile in primary database, recovery process in standby stopped with below error. — Primary database: SQL> alter tablespace prim add datafile size 1g; Tablespace altered. — Error in alert log of standby database File #5 added to control file as ‘UNNAMED00005’ because the parameter STANDBY_FILE_MANAGEMENT is set to MANUAL The file should be […]
Roll Forward Physical Standby Database using RMAN incremental backup
There would be scenarios where the standby database lags far behind from the primary database leading to Archive Gap. It could be due to one of the following reasons 1. Might be due to the network outage between the primary and the standby database leading to the archive gaps. Data guard would be able to detect […]