Oracle 自動冷備份腳本

冷備份，就是關閉db，物理copy數據文件、日志文件、控制文件、歸檔文件。

rem ***** COLDBACKUP ORACLE DATABASE ON WINDOWS NT *****

set ShutDownFile=C:ShutDown.SQLecho connect internal/oracle > %ShutDownFile%echo shutdown immediate >> %ShutDownFile%echo startup >> %ShutDownFile%echo shutdown normal >> %ShutDownFile%echo exit >> %ShutDownFile%

rem ***** SHUTDOWN THE DATABASE *******set oracle_sid=dbprimsvrmgrl @%ShutDownFile%

net stop OracleStart%oracle_sid%net stop OracleService%oracle_sid%

rem ***** SET BACKUP FILES DIRECTORY *****e:md oradbcd oradbmd backupscd backups

rem *****cold backup for "dbprim" database on 2009-3-17 10:56:40 ... *****

rem ***** COPY FILES *****rem Redo logs

copy C:ORACLE-DATAREDO03.LOGcopy C:ORACLE-DATAREDO02.LOGcopy C:ORACLE-DATAREDO01.LOG

rem Datafile

copy C:ORACLE-DATADBPRIMSYSTEM01.DBFcopy C:ORACLE-DATADBPRIMUNDOTBS01.DBFcopy C:ORACLE-DATADBPRIMSYSAUX01.DBFcopy C:ORACLE-DATADBPRIMUSERS01.DBFcopy C:ORACLE-DATADBPRIMEXAMPLE01.DBFcopy C:ORACLE-DATADBPRIMORATBS.DBF

6 rows selected

rem Control files

copy C:ORACLE-DATADBPRIMCONTROL01.CTLcopy C:ORACLE-DATADBPRIMCONTROL02.CTLcopy C:ORACLE-DATADBPRIMCONTROL03.CTL

rem *********START UP DATABASE AND SERVICES********net start OracleService%oracle_sid%net start OracleStart%oracle_sid%

set StartFile=C:start.SQLecho connect internal/oracle > %StartFile%echo startup >> %StartFile%echo exit >> %StartFile%

set oracle_sid=dbprimsvrmgrl @%StartFile%

del /Q %ShutDownFile%del /Q %StartFile%exit;