19c Physical Standby Database Switch over to Primary Database

At Primary: - 1.. Check for name, db_unique_name and primary check for database_role 1.1 Similarly check for current archive log status or no of archived log sequence. select SEQUENCE#,archived FROM V$ARCHIVED_LOG; or select max(SEQUENCE#),archived FROM V$ARCHIVED_LOG group by archived; or alter session set  nls_date_format='DD-MON-YYYY HH24:MI:SS'; select sequence#, first_time, next_time, archived FROM v$archived_log ORDER BY sequence#; …

Upgrade to Oracle 19c GRID Infrastructure from 12c GRID Bingo !!!!

1.. login to GRID Primary node as GRID Owner 2.. Navigate to 19c_GRID_HOME and execute gridSetup.sh if you have already applied RUP patches. For me i have already applied RUP 19.14.X cd /u101/app/19.3.0/grid/grid_home [oragrid@node1 grid_home]$ [oragrid@node1 grid_home]$ unset ORACLE_BASE [oragrid@node1 grid_home]$ [oragrid@node1 grid_home]$ unset ORACLE_HOME [oragrid@node1 grid_home]$ [oragrid@node1 grid_home]$ unset ORACLE_SID [oragrid@node1 grid_home]$ ./gridSetup.sh 3.. …

When the software home is already registered in the central inventory

Cause :- Before executing gridsetup.sh , the Dry-Run Upgrade  was performed by executing the command: gridSetup.sh -dryRunForUpgrade And The gridSetup.sh -dryRunForUpgrade command updates the Oracle Inventory (oraInventory) with the new Oracle Grid Infrastructure home. Login as grid user :- [oragrid@node1 grid_home]$ /u101/app/19.3.0/grid/grid_home/oui/bin/runInstaller -silent -waitforcompletion -detachHome ORACLE_HOME='/u101/app/19.3.0/grid/grid_home' -local Starting Oracle Universal Installer... Checking swap space: must …

19c Converting Physical Standby Database to the Snapshot Standby Database !!!!

A snapshot standby database is a fully update-able standby database that is created by converting a physical standby database into a snapshot standby database. A snapshot Standby is open in the read-write mode and hence it is possible to process transactions independently of the primary database. At the same time, it maintains protection by continuing …

Create Physical Standby Database 19c with Container using Backup and Restore !!!!

1.. Preparing the Production system for Physical Standby Creation 1.1 At Primary enable Forced Logging and Archive log Mode select name, force_logging,log_mode from v$database; 1.2 At Primary set Primary Database Initialization Parameters log_archive_dest_1: Archives redo data generated on primary database to the local file system alter system set log_archive_dest_1='location=/oem/BACKUP/archive VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=CDBPROD' scope=spfile; 1.3 log_archive_dest_2: Transmits …