冷备脚本
set feedback off
set heading off
set verify off
set trimspool off
set echo off
set time off
set timing off
set pagesize
set linesize
define dir=/backup/cold/mike;
define diroutmike=/u/scripts/coldscr/mikecoldoutsql;
spool &diroutmike
select !cp ||name|| &dir from v$datafile order by file#;
select !cp ||name|| &dir from v$controlfile;
spool off;
shutdown immediate;
@&diroutmike
startup;
以上脚本放在/u/scripts/coldscr/mikecoldsql
在数据库运行时可以运行此脚本来冷备
热备脚本
set feedback off
set pagesize
set heading off
set verify off
set linesize
set trimspool on
set echo off
set time off
set timing off
undefine mikedir
undefine mikescp
define mikedir=/backup/hot
define mikescp=/u/scripts/hotscr/mikehotoutsql
declare
cursor cur_tablespace is select tablespace_name from dba_tablespaces where status <> READ ONLY a
nd contents not like %TEMP%;
cursor cur_datafile(tn varchar) is select file_name from dba_data_files where tablespace_name=tn;
begin
for ct in cur_tablespace loop
dbms_outputput_line(alter tablespace ||cttablespace_name|| begin backup;);
for cd in cur_datafile(cttablespace_name) loop
dbms_outputput_line(! cp ||cdfile_name|| &mikedir);
end loop;
dbms_outputput_line(alter tablespace ||cttablespace_name|| end backup;);
end loop;
end;
/
以上脚本放在/u/scripts/hotscr/mikehotsql
在数据库运行时可以运行此脚本来热备
