automatic cold backup script

最新推荐文章于 2024-09-08 16:41:16 发布

转载最新推荐文章于 2024-09-08 16:41:16 发布 · 96 阅读

博客介绍了Oracle数据库冷备份相关脚本内容。包含backup.bat文件执行内容，以及cold_create.sql、shutdown.sql文件的具体代码，还提到最后需执行COLDg.bat。这些脚本用于将数据库实际文件备份到指定目录。

很多東西不會的時候很難,會了的時候很簡單.

[@more@]

1.backup.bat檔的內容然後執行.

sqlplus /nolog @d:coldbackupcold_create.sql
sqlplus /nolog @d:coldbackupshutdown.sql
d:coldbackupCOLDg.bat
2. cold_create.sql的內容

connect sys/test as sysdba

set feedback off
set heading off
set pagesize 0
set linesize 128
set verify off
set termout oN
set echo off
set trim on
set trims on
-- &2 is ORACLE_SID
spool COLDg.bat
-- Create Script to backup actual files to a directory
-- where &1 is COLDBACK_PATH
select
'copy '||file_name||' d:coldbackup' ||substr(file_name,instr(rtrim(file_name),'',-1,1)+1,length(rtrim(file_name)))||'.bak' c1
FROM dba_data_files;
select
'copy '||name||' d:coldbackup' ||
substr(name,instr(rtrim(name),'',-1,1)+1,length(rtrim(name)))||'.bak' c1
from v$controlfile;
select
'copy '||member||'d:coldbackup' ||
substr(member,instr(rtrim(member),'',-1,1)+1,length(rtrim(member)))||'.bak' c1
from v$logfile;
select
'copy '||'D:oracleora92database'||'init'||'inittest'||'.ora '||' d:coldbackup' || '' ||'init'||'inittest'||'.ora.bak' c1
from dual;
spool off
exit