run {
duplicate target database for standby from active database
spfile
set audit_file_dest='/U01/app/oracle/admin/statdb2/adump'
set DB_FILE_NAME_CONVERT='+DATA/statdb2/datafile','/U01/app/oracle/oradata/statdb2','+DATA/statdb2/tempfile/','/U01/app/oracle/oradata/statdb2'
set control_files='/U01/app/oracle/oradata/statdb2/control01.ctl','/U01/app/oracle/oradata/statdb2/control02.ctl'
set db_create_file_dest='/U01/app/oracle/oradata/statdb2'
set db_create_online_log_dest_1='/U01/app/oracle/oradata/statdb2'
set db_create_online_log_dest_2='/U01/app/oracle/oradata/statdb2'
set db_recovery_file_dest='/U01/app/oracle/fast_recovery_area'
set remote_listener=''
set db_unique_name='sstatdb2'
set diagnostic_dest='/U01/app/oracle'
set remote_login_passwordfile='EXCLUSIVE'
set utl_file_dir='/U01/app/oracle/admin/statdb2/utl_file'
set LOG_FILE_NAME_CONVERT='+DATA/statdb2/onlinelog','/U01/app/oracle/oradata/statdb2'
nofilenamecheck ;
}
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/26390465/viewspace-1793118/
,如需转载,请注明出处,否则将追究法律责任。