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


6. Connect to TST1
   startup nomount


$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;

nohup sh &

No comments:

Integrate Oracle ADF with Oracle E-Business Sutie 12.2 ASCP Instance

Integrate Oracle ADF with Oracle E-Business Suite 12.2 ASCP Instance for  SPWA - Supply Planning Work Area What is  Oracle ADF? Orac...