Thursday, 15 April 2021

11g onward duplicate database from backup without target connection

run

{

duplicate database to "DEV"   

spfile 

set db_file_name_convert='+EBS/ADPF/DATAFILE','/u01/app/oracle/oradata'    

set log_file_name_convert='+EBS/adpf/logfile','/u01/app/oracle/oradata'                      

SET CLUSTER_DATABASE='FALSE'                                                                  

set UNDO_TABLESPACE='undotbs1'

set control_files='/u01/app/oracle/oradata/cntrl01.dbf','/u01/app/oracle/oradata/cntrl02.dbf','/u01/app/oracle/oradata/cntrl03.dbf' 

backup location  '/BIDEVDISK/clone_15042021/data/'

nofilenamecheck ;

}


No comments:

Post a Comment

Number of Visitors