1) begin.sql 작성
connect / as sysdba
alter tablespace SYSTEM begin backup;
alter tablespace SYSAUX begin backup;
alter tablespace UNDOTBS1 begin backup;
alter tablespace USERS begin backup;
alter tablespace DATA1 begin backup;
alter tablespace INDEX1 begin backup;
exit
2) end.sql 작성
connect / as sysdba
alter tablespace SYSTEM end backup;
alter tablespace SYSAUX end backup;
alter tablespace UNDOTBS1 end backup;
alter tablespace USERS end backup;
alter tablespace DATA1 end backup;
alter tablespace INDEX1 end backup;
alter database backup controlfile to 'C:\oradata_backup\control_bak.ctl' reuse;
exit
3) backup.bat 작성
date /t > c:\oradata_backup\backup.log
time /t >> c:\oradata_backup\backup.log
call D:\oracle\app\product\11g\BIN\sqlplus.exe /nolog @c:\backup\begin.sql
xcopy D:\oradata\GLSDB\* C:\oradata_backup /s /e /y
xcopy D:\arch\* C:\oradata_backup\arch /s /e /y
call D:\oracle\app\product\11g\BIN\sqlplus.exe /nolog @c:\backup\end.sql
del C:\oradata_backup\exp_full_oradata.*
D:\oracle\app\product\11g\BIN\exp.exe system/password file=C:\oradata_backup\exp_full_oradata.dmp
log=C:\oradata_backup\exp_full_oradata.log full=y
date /t >> c:\oradata_backup\backup.log
time /t >> c:\oradata_backup\backup.log
4) windows 작업스케쥴러에 등록
backup.bat
5) 백업 확인