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...
#rman #duplication #oracle #clone
Follow me:
----------
LinkedIn: / atsohmofor
Twitter: / bindag OR @Bindag
email: [e-mail]
Telegram: NI TSOH
RUclips: / @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;
}

[@abhijitlande1028]

Great Very good explanation.

[@PavanKumar-ec4ct]

Got clarity about nofilename check command in this video thanks a lot

[@bobsukki]

Glad it helped 👍🏽

[@austinimegwu932]

Very Good presentation.

[@bobsukki]

I appreciate your feedback!

[@SANDATA764]

Respected Sir
Your steps are very clear
Thanks

[@bobsukki]

Thank you Salad, I am glad you found it helpful!

[@SANDATA764]

@@bobsukki respected sir
I can't wait your upcoming videos

[@huynhtruong5072]

Your video helps me a lot. Thank you so much. Respected Sir

[@akinsmedia77]

I enjoyed this video. valued added, you made my day

[@bobsukki]

Glad you enjoyed it!

[@barhlam1356]

Great lecture as usual

[@bobsukki]

Glad you enjoyed it

[@ManojYadav-lw8tu]

Very good explanation.

[@bobsukki]

Thank you Manoj 🙏🏽

[@asifomer4349]

plz share the video of stand by db

[@bobsukki]

Here you go... ruclips.net/video/e3r97b5C2A4/видео.html

[@SilvermanWKWK]

Can you help me i already following ur step but when i try to connect to rman auxiliary "dbstby" my tns couldnt connect the server and i see listener status on standby its blocked

[@bobsukki]

Sorry I am getting to you late... Do you still have this issue going on?