Oracle Database: ACTIVE Database DUPLICATION using RMAN

Related Video:
Oracle RAC Part 2: Clone VM, configure hostname and network settings
https://youtu.be/nTKXj_4A8l4
#rman #duplication #oracle #clone
Follow me:
----------
LinkedIn: https://www.linkedin.com/in/atsohmofor/
Twitter: https://twitter.com/Bindag OR @Bindag
email: [email protected]
Telegram: NI TSOH
YouTube: https://www.youtube.com/channel/UCx06dllvcDWc5yyFVqVdFPA 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;
}