Saturday, March 04, 2017

RMAN Active Duplicate Script

Source: PRD1
Target: TST1

1. Add Tnsnames entries of PRD1 in TST1
2. Add Tnsnames entries of TST1 in PRD1
3. Make sure both the listeners are up on Source and Target
4. Create orapwd file in TST1

orapwd file=$ORACLE_HOME/dbs/TST1 password=manager entries=10

select * from v$pwfile_users;

5. Keep these paramters in TST1 pfile

*.db_file_name_convert='/data/app/PRD1/db/apps_st/data','/data/app/TST1/db/apps_st/data','/index/app/PRD1/db/apps_st/data','/index/app/TST1/db/apps_st/data'
*.log_file_name_convert='/redo/app/PRD1/db/apps_st/data','/redo/app/TST1/db/apps_st/data'

6. Connect to TST1
   startup nomount

vi TST1_active_dup_db.sh

$ORACLE_HOME/bin/rman nocatalog log=TST1_active_dup_db.log <<EOF
connect target sys/manager@PRD1
connect auxiliary sys/manager@TST1
duplicate target database to TST1 from active database nofilenamecheck;
EOF

nohup sh TST1_active_dup_db.sh &

No comments:

Enabling SSL or TLS in Oracle E-Business Suite Release 12.2

Enabling TLS in Oracle Apps R12.2 Here  we would be looking at the detailed steps for Enabling TLS in Oracle Apps R12.2 Introduction: ...