Tech by KJ

My Environment for this practice:      Primary Environment Standby Environment DB_NAME PRODTEST DB_NAME PRODTEST DB_UNIQUE_NAME PRODTEST DB_UNIQUE_NAME STBTEST IP 10.14.1.162 IP 10.14.2.251 DATABASE VERSION 19.3.0.0.0 DATABASE VERSION 19.3.0.0.0 OS OLE 8 OS OLE 8 Step 01 - Make sure the primary database is running in archive log mode. [oracle@testserver-k ~]$ sqlplus / as sysdba SQL> archive log list; Database log mode              Archive Mode Automatic archival             Enabled Archive destination            USE_DB_RECOVERY_FILE_DEST Oldest online log sequence     7 Next log sequence to archive   9 Current log sequence           9 # In this case the database is already running in archive log mode. But if it is not in archive log mode follow the below steps to alter it to archive log mode. SQL> shu immediate S...

This guide covers the essential steps for taking RMAN backups and performing restorations, including handling archivelog modes and restoring to different locations. Part 1: Taking an RMAN Backup 1. Preparation First, create a directory to store the backups and generate a parameter file (pfile) from your current server parameter file (spfile). Create the backup directory: mkdir /u01/RMAN_BACKUP Create the pfile backup: Connect to SQL*Plus and create the pfile in your new directory. sqlplus / as sysdba CREATE pfile='/u01/RMAN_BACKUP/init<db_name>.ora' FROM spfile; 2. Configure Archivelog Mode To take a full online backup while the database is running, the database must be in Archivelog Mode. Note: If you cannot change the mode, you can take an offline backup by mounting the database (where logs stop generating) and backing up just the database. However, the steps below assume we are switching to archivelog mode to capture both the database and archive logs. Steps to enable ...

Below is the specs of the source and target I used for this demonstration: Source: OL 7.9 / DB 11.2.0.2 / GoldenGate 12.3 / Classic Extract Target: OL 8 / DB 19c / GoldenGate 19.1 / Integrated Replicat (The reason I used GoldenGate 12.3 in the source server is since GoldenGate 19c does not support Oracle Database 11.2.0.2 The source DB server use the classic extract method to extract the trail files since integrated extract method is not supported.) Ports to be opened: 7809               Source --> Target -- Manager Port 7810-7820     Source --> Target -- Collector Ports 1521               Source --> Target -- Listener Port (Strictly not necessary but better to have opened) 22                    Bidirectional -- SSH Port Make sure the tns entries are clearly specified in the tnsnames.ora file. Phase 0: OS Setup & Installation ...