-- 角本 windows

--**************************************************************
-- fileName: cold_backup
--
-- 2007-03-06 by HuiYi.Zhang
--
--**************************************************************
-- Set SQL*Plus variables to manipulate output
set feedback off heading off verify off trimspool off
set pagesize 0 linesize 200
-- Set SQL*Plus user variables used in this script
define dir='D:backupcold'
define fil='C:WINDOWSTempora_cold_backup.sql'
prompt ... spooling to &fil
-- Create Backup command
spool &fil
  select 'host copy ' || name ||' &dir' from v$datafile;
  select 'host copy ' || member || ' &dir' from v$logfile;
  select 'host copy ' || name || ' &dir' from v$controlfile;
spool off;
-- Shutdown Database
shutdown immediate;
@ &fil
startup;


-- 角本 Linux

#!/bin/ksh

ORACLE_SID=huiyi
export ORACLE_SID

ORACLE_HOME=/opt/oracle/product/9.2
export ORACLE_HOME

ORACLE_BASE=/opt/oracle
export ORACLE_BASE

#NLS_LANG="SIMPLIFIED CHINESE_CHINA.ZHS16GBK"; export NLS_LANG
NLS_LANG="AMERICAN_AMERICA.ZHS16GBK"
export NLS_LANG

NLS_DATE_FORMAT='YYYY/MM/DD'
export NLS_DATE_FORMAT

echo "**************************************"
echo "* cold_backup.sh                      "
echo "**************************************"

$ORACLE_HOME/bin/sqlplus -s "/ as sysdba" << !

set feedback off heading off verify off trimspool off
set pagesize 0 linesize 200
-- Set SQL*Plus user variables used in this script
define dir='/backup/cold'
define fil='/tmp/cold_backup.sql'
prompt ... spooling to &fil
-- Create Backup command
spool &fil
  select 'host cp ' || name ||' &dir' from v$datafile;
  select 'host cp ' || member || ' &dir' from v$logfile;
  select 'host cp ' || name || ' &dir' from v$controlfile;
spool off;
-- Shutdown Database
shutdown immediate;
@ &fil
startup;

exit
!