How to create duplicate database using RMAN backup ???

 

Create all folders:

mkdir -m2750 /folder/path/

mkdir -m2750 /folder/path/

mkdir -m2750 /folder/path/

mkdir -m2750 /folder/path/

mkdir -m2750 /folder/path/

init parameters:

*.audit_file_dest='/audit/file/path/'

*.audit_sys_operations=TRUE

*.audit_trail='DB_EXTENDED'

*.compatible='compatible_parameter_as_per_your_env'

*.control_files='/folder/path/goes/here/control01.ctl','/folder/path/goes/here/control02.ctl'

*.db_block_size=8192

*.db_domain=''

*.db_name='TGT_DB_NAME'

*.db_recovery_file_dest_size=214748364800

*.diagnostic_dest='folder/path'

*.global_names=FALSE

*.local_listener='listener_name'

*.log_archive_dest='/archived/redo/location'

*.log_archive_format='%%ORACLE_SID%%_ARC%s_%R.%T'

*.open_cursors=300

*.processes=2210

*.remote_login_passwordfile='EXCLUSIVE'

*.sga_max_size=3G

*.sga_target=2G

*.pga_aggregate_target=1G

*.undo_tablespace='UNDOTBS1'

db_file_name_convert=('/oradata01/source/path/','/folder/path/',

'/oratemp/source/path/','/oratemp/target/path/')

log_file_name_convert=('/oraredo1/source/path','/oraredo1/target/path',

'/oraredom/source/path/','/oraredo_m/target/path/',

'/oraredo2/source/path/','/oraredo2/target/path/')

#

################################################################################################################

#

# Use next step ONLY IF you are using TDE encryption

#

################################################################################################################

#

TDE Steps:

scp /source/path/ewallet* target_node:/target/path/ ==> From SOURCE server

DB Creation:

dba

startup nomount

ADMINISTER KEY MANAGEMENT SET KEYSTORE OPEN IDENTIFIED BY Defiance_#12;

select status from v$encryption_wallet;

ADMINISTER KEY MANAGEMENT CREATE LOCAL AUTO_LOGIN KEYSTORE

FROM KEYSTORE '/target/path' IDENTIFIED BY Defiance_#12;

select status from v$encryption_wallet;

#

################################################################################################################

#

# Actual restore and duplicate part starts now

#

################################################################################################################

#

RMAN :

rman target / catalog rman/${RMANPW}@${ORACLE_CATSID}

run

{

set until time "to_date('2020-10-19 05:00','YYYY-MM-DD HH24:MI')"; ==> Change the data and time as you want

allocate auxiliary channel c1 type disk;

allocate auxiliary channel c2 type disk;

allocate auxiliary channel c3 type disk;e

allocate auxiliary channel c4 type disk;

allocate auxiliary channel c5 type disk;

duplicate target database to 'target/path' Nofilenamecheck;

}