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: [email protected] 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; }