arcserveUDP & Oracle Database Best Practice

arcserveUDP & Oracle Database Best Practice

With job scheduler in arcserveUDP , use these scripts

arcserve setting	script
Before backup	pre_arcserve.bat
After Snap shot	post_arcserve.bat
after backup	end_arcserve.bat

With job scheduler such as JP1 AJS , Systemwalker , use these scripts

Event	JobScheduler Setting	arcserve setting	arcserve exec script
Check BackUp Flag	CheckFlag.ps1	none	none
Change To BackUp Mode	OracleDB2BackUpMode.ps1	none	none
Start arcserve UDP BackUp	arcserveUDPBackUp.ps1	none	none
in arcserve UDP	none	Before backup	none
finish snapshot make end_snapshot.flg	none	After Snap shot	end_snapshot.bat
Waiting for end_snapshot.flg	Job Scheduler's task	none
Change To Normal Mode	OracleDB2NormalMode.ps1	none	none
Delete archive log	OracleDeleteArchive.log	none	none
Delete Old Log	FileMaintenance.ps1	none	none
finish arcserveUDP	none	after backup	end_arcserve.bat

Sample file path

D:\Scripts\Infra\shell\ps1 and bat files

D:\Scripts\Infra\lock\Flag files

D:\Scripts\Infra\config\command.txt and loopwrapper.txt

D:\Scripts\Infra\SQL\SQLs.ps1 and DeleteArchivelog.rman

D:\Scripts\Infra\Logs\SQL.log and RMAN.log
D:\Scripts\Infra\Bk_Logs\old log file