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 […]
Category: DATAGUARD
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 […]
Standby-First Patch Apply on DataGuard with Rolling Patch on Oracle RAC 12c
I must thank my fellow DBA Franky Weber Faust for his publication in Portuguese OTN. Apply the PSU in Standby with RAC database using the standby-first patch apply method. In this article, I introduce how to apply the patch using the standby-first patch apply the method in a DataGuard environment with Oracle RAC 12c, where […]
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 […]