????5???????

sys@SYBO2SZ> ho more /users/robin/dba_scripts/custom/sql/transfer_db_files.sql
Prompt
Prompt Step 1?? Coping file to destination from source
Prompt ============================================
Prompt
set linesize 200
set heading off verify off feedback off termout off pagesize 999
define src_dir='SYBO2SZ'
define tar_dir='SY5221BK'
spool /tmp/cp_files.sql
SELECT 'ho cp ' || name || ' ' || REPLACE (name?? '&src_dir'?? '&tar_dir')
FROM v$datafile
UNION ALL
SELECT 'ho cp ' || name || ' ' || REPLACE (name?? '&src_dir'?? '&tar_dir')
FROM v$tempfile
UNION ALL
SELECT 'ho cp ' || MEMBER || ' ' || REPLACE (MEMBER?? '&src_dir'?? '&tar_dir') FROM v$logfile;
spool off;

@/tmp/cp_files.sql

set termout on
Prompt
Prompt  Step 2?? updating files to control file
Prompt ============================================
Prompt
set termout off
spool /tmp/update_cntl.sql
SELECT    'alter database  rename file '''
|| name
|| '''  to '''
|| REPLACE (name?? '&src_dir'?? '&tar_dir')
|| ''''
|| ';'
FROM v$datafile
UNION ALL
SELECT    'alter database rename file '''
|| name
|| '''  to '''
|| REPLACE (name?? '&src_dir'?? '&tar_dir')
|| ''''
|| ';'
FROM v$tempfile
UNION ALL
SELECT    'alter database rename file '''
|| MEMBER
|| ''' to '''
|| REPLACE (MEMBER?? '&src_dir'?? '&tar_dir')
|| ''''
|| ';'
FROM v$logfile;
spool off;
set termout on;
@/tmp/update_cntl.sql
set heading on verify on feedback on termout on

????6?????

????a????????????????????????

????b??????????????????????cp?????????????????????????????mv??

????c????????????????????????Ρ???nomount?????????????????mount????????????????????????

????d????????????????ε?????????????ū?????????????????????????????

????e????????????λ??????????????dump???λ?????????????pfile???????ɡ??????????????spfile???

????f??????????????????????????????????????????src_dir??tar_dir

????g?????????????????????????????????open????open??У???????????????????е???????????????????????????

????h????????????????????????????nid????????????????????μ??????