Oracle Database: ACTIVE Database DUPLICATION using RMAN

Published: 01 February 2022
on channel: Ni TSOH

2,589

116

Related Video:
Oracle RAC Part 2: Clone VM, configure hostname and network settings
   • Oracle RAC Part 2 of 5: Clone VM, con...
#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;
}

On this page of the site you can watch the video online Oracle Database: ACTIVE Database DUPLICATION using RMAN with a duration of hours minute second in good quality, which was uploaded by the user Ni TSOH 01 February 2022, share the link with friends and acquaintances, this video has already been watched 2,589 times on youtube and it was liked by 116 viewers. Enjoy your viewing!