This note outlines the steps to create an Oracle 19c Container Database via DBCA and then use the RMAN DUPLICATE command to create an Oracle 19c physical standby Container Database. Download the note ….
This note describes the procedure of creating an Oracle 220.127.116.11 Data Guard Physical Standby database with a two-node Real Application Cluster (RAC) Primary and Standby database on an Oracle Exadata X5-2 eight rack. The procedure will use RMAN for the creation of the Physical Standby database and will use the DUPLICATE FROM ACTIVE DATABASE method […]
This note describes the procedure used to perform a rolling database upgrade from 18.104.22.168 to Oracle 12c Release 1 using a Data Guard physical standby database and transient logical standby database. The average time to perform a database upgrade would be in the region of one to two hours and for many organizations even that […]
In some establishments, Dataguard switchovers are manual – Please perform these pre-requisite checks before undertaking a switchover to primary. 1. ON STANDBY SITE: SQL> select database_role from v$database; DATABASE_ROLE —————- PHYSICAL STANDBY…………….PROCEED. If you receive a reply like the one below, then do not proceed- you are most probably firing the sql command in the […]