RMAN hangs on duplicate database
I was trying to validate the backup so I simulate the process of cloning the database.original SID is EMRAC
new SID is HYPDEV
Here is what I do.
1. copy the backup files to the target server.
2. in target server, export ORACLE_SID=HYPDEV
3. prepare initHYPDEV.ora as follow
db_name=HYPDEV
db_unique_name=HYPDEV
control_files='/opt/oracle/product/11.2.0/hypdevdb/control01.ctl','/opt/oracle/product/11.2.0/hypdevdb/control02.ctl'
audit_file_dest='/opt/oracle/product/11.2.0/hypdevdb/adump'
compatible='11.2.0.0.0'
db_recovery_file_dest='/nagios_archive/hypdevdb/fra'
#db_recovery_file_dest='+FRA1'
new SID is HYPDEV
Here is what I do.
1. copy the backup files to the target server.
2. in target server, export ORACLE_SID=HYPDEV
3. prepare initHYPDEV.ora as follow
db_name=HYPDEV
db_unique_name=HYPDEV
control_files='/opt/oracle/product/11.2.0/hypdevdb/control01.ctl','/opt/oracle/product/11.2.0/hypdevdb/control02.ctl'
audit_file_dest='/opt/oracle/product/11.2.0/hypdevdb/adump'
compatible='11.2.0.0.0'
db_recovery_file_dest='/nagios_archive/hypdevdb/fra'
#db_recovery_file_dest='+FRA1'
0