需要的修改下用用吧!
UNIX的版本过段时间放到我的BLOG上(
http://blog.itpub.net/ocp8i )
(OS:2k)
fullbackup.bat
RMAN TARGET sys/oracle@allen CATALOG rman/rman@allen CMDFILE fullALLEN.rcv LOG fullALLEN.log
RMAN TARGET sys/oracle@allen CATALOG rman/rman@allen CMDFILE archbackup.rcv LOG Archbackup.log
RMAN TARGET sys/oracle@allen CATALOG rman/rman@allen CMDFILE ctlALLEN.rcv LOG ctlALLEN.log
copy D:\tools\oracle\ora92\database\spfileallen.ora D:\backup\spfileallen.ora.bak;
fullALLEN.rcv
run {
allocate channel fd1 type disk;
sql 'alter database backup controlfile to trace';
backup
full
tag full_allen_db
filesperset 1
format 'D:\backup\db_allen_full_%t_%s_%p'
(database include current controlfile);
release channel fd1;
}
archbackup.rcv
run {
allocate channel ad1 type disk;
sql 'alter system archive log current';
backup
format 'D:\backup\arch_allen_%s_%p'
(archivelog all delete input);
release channel ad1;
}
ctlALLEN.rcv
run {
allocate channel cd1 type disk;
copy current controlfile to 'D:\backup\control01.bak';
release channel cd1;
}
coldback.bat
sqlplus /nolog @C:\coldbackup/cold_create.sql
sqlplus /nolog @C:\shutdown/shutdown.sql
C:\coldbackup\COLDg_exec_allen.bat
cold_create.sql
connect /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
spool COLDg_exec_allen.bat
-- Create Script to backup actual files to a directory
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:\tools\oracle\ora92\database'||'\spfile'||'allen'||'.ora '||' D:\coldbackup' || '\' ||'spfile'||'allen'||'.ora.bak' c1
from dual;
spool off
exit
shutdown.sql
connect /as sysdba
shutdown immediate
exit
