oracle 冷备份脚本

只备份了控制文件和数据文件

脚本cold_backup.sql

--define backup_path=&1
define backup_path=/oracle/oradata/DG/backup/cold_backup


set head off
set feedback off
set verify off
spool /tmp/cold.sql
select '!  cp '||name ||'  &backup_path' from v$controlfile;
select '!  cp '||name ||'  &backup_path' from v$datafile;
spool off
set head on
set feedback on
set verify on


undefine backup_path


shutdown immediate;
@/tmp/cold
startup;