Oracle 自動冷備份腳本
冷備份,就是關(guān)閉db,物理copy數(shù)據(jù)文件、日志文件、控制文件、歸檔文件。
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;
相關(guān)文章:
1. 數(shù)據(jù)庫Oracle9i的企業(yè)管理器簡介2. Oracle數(shù)據(jù)庫的兩種授權(quán)收費方式詳解3. 關(guān)于Oracle的Dual表4. Oracle的TNS-12502錯誤原因及解決方法5. 學(xué)好Oracle的六條總結(jié)6. Oracle 9i 數(shù)據(jù)庫WITH查詢語法小議7. ORACLE分區(qū)表轉(zhuǎn)換在線重定義DBMS_REDEFINITION8. Oracle試用到期如何刪除注冊表繼續(xù)試用30天9. Oracle數(shù)據(jù)字典詳解10. Oracle平臺下的數(shù)據(jù)分片技術(shù)解析

網(wǎng)公網(wǎng)安備