Oracle Database: ACTIVE Database DUPLICATION using RMAN

Related Video:
Oracle RAC Part 2: Clone VM, configure hostname and network settings
   • Oracle RAC Part 2 of 5: Clone VM, configur...  
#rman #duplication #oracle #clone
Follow me:
----------
LinkedIn:   / atsohmofor  
Twitter:   / bindag   OR @Bindag
email: bobsukki@gmail.com
Telegram: NI TSOH
YouTube:    / @bobsukki   OR NI TSOH

Oracle Database: ACTIVE Database DUPLICATION using RMAN
===================================================
Step 1: Create or copy password file for the auxiliary instance from source database server

Step 2: Configure tnsnames.ora for both servers

Step 3: Configure listener.ora, add SID entry for primtst database

Ensure listeners on both servers have been started and verify connectivity (tnsping)

Step 4: Edit initprimtst.ora

*.db_name='primtst'

Step 5: Create required directory for audit logs

[oracle@testsrv dbs]$ mkdir -p /u01/app/oracle/admin/primtst/adump

Step 6: set the right env variables

$ export ORACLE_SID=primtst
$ export ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1
$ sqlplus / as sysdba

Step 7: Startup auxiliary instance in NOMOUNT mode

startup nomount pfile='/u01/app/oracle/product/19.0.0/dbhome_1/dbs/initprimtst.ora'

Step 8: Prepare RMAN for duplication

$ rman target sys/oracle@PRIMDB auxiliary sys/oracle@PRIMTST

Step 9 Duplicate the database [Duplicating to a Host with the Same Directory Structure (Active)]

RMAN
run {
DUPLICATE TARGET DATABASE TO primtst FROM ACTIVE DATABASE
SPFILE
parameter_value_convert 'primdb','primtst'
NOFILENAMECHECK;
}