上周去處理生產(chǎn)部門的一個(gè)問(wèn)題，數(shù)據(jù)庫(kù)運(yùn)行在歸檔模式下，但現(xiàn)在維護(hù)還沒(méi)移交到信息單位，導(dǎo)致歸檔文件占用大量磁盤空間，數(shù)據(jù)庫(kù)掛起。把歸檔文件移走就OK了。針對(duì)目前情況，管理上的問(wèn)題我是無(wú)能為力，只好做了個(gè)冷備腳本，讓操作人員定期冷備，再清理歸檔文件。
connect sys/@ as sysdba
Rem 冷備份腳本
Rem 信息中心 2005
set feedback off heading off verify off trimspool off
set pagesize 0 linesize 200
define dir='S:\cold_bat'
define cmdfile='S:\cold_bat\cold_backup_command.sql'
prompt *** spooling to &cmdfile
spool &cmdfile
select 'host copy ' || name || ' &dir' from v$datafile order by 1;
select 'host copy ' || member || ' &dir' from v$logfile order by 1;
select 'host copy ' || name || ' &dir' from v$controlfile order by 1;
select 'host copy ' || name || ' &dir' from v$tempfile order by 1;
spool off;
shutdown immediate;
@&cmdfile
startup;
set feedback on heading on verify on trimspool on pagesize 14
exit