oracle的冷备脚本

#!/bin/sh

#
# 该脚本可以在linux下测试通过
#

sqlplus '/as sysdba' <Remark SQL *Plus variables.
Set feedback off
set heading off
set trimspool off
set verify off
Set pagesize 0 linesize 200
Remark set the directory and the script file name.
Define dir=/backup/cold_wholebackup
Define temp=/home/oracle/niyl/temp.sql
Define fil=/home/oracle/niyl/cold_wholebackup.sql

[@more@]

Remark spool the backup command to the file defind above.
Spool &temp
Select 'host cp '||name||' &dir' from v$datafile order by 1 ;
Select 'host cp '||member||' &dir' from v$logfile order by 1;
Select 'host cp '||name||' &dir' from v$controlfile order by 1;
Select 'host cp '||name||' &dir' from v$tempfile order by 1;
Spool off
Remark deal with the temp sql. remove select statement from the sql.
host grep ^host &temp > &fil
Remark shutdown database cleanly.
Shutdown immediate ;
Remark run the copy command from the backup script.
@&fil
Remark bakcup ended and startup the database.
Startup
exit
!

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10867315/viewspace-963991/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10867315/viewspace-963991/