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. 整理Oracle數(shù)據(jù)庫碎片2. 學(xué)好Oracle的六條總結(jié)3. 快速刪除ORACLE重復(fù)記錄4. Oracle災(zāi)難防護(hù)的關(guān)鍵技術(shù)5. 數(shù)據(jù)庫Oracle9i的企業(yè)管理器簡介6. oracle觸發(fā)器介紹7. FORM程序中Oracle與Access表的導(dǎo)入和導(dǎo)出8. 訪問Oracle數(shù)據(jù)庫時如何限制繞過漏洞9. Oracle數(shù)據(jù)庫的兩種授權(quán)收費(fèi)方式詳解10. 配置支持MTS下分布事務(wù)的Oracle

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