arcserveUDP & Oracle Database Best Practice

arcserveUDP & Oracle Database Best Practice

With job scheduler in arcserveUDP

arcserve setting	script
Run a command before a backup is started	pre_arcserve.bat
Run a command after a snapshot is taken	post_arcserve.bat
Run a command after a backup is completed	end_arcserve.bat

And mark [Run a command even when the job fails]

With job scheduler such as JP1 AJS , Systemwalker

Event	JobScheduler Setting	arcserve setting	arcserve exec script
Check BackUpDB.flg make BkupDB.flg	CheckFlag.ps1	none	none
Change To BackUp Mode	OracleDB2BackUpMode.ps1	none	none
[arcserveUDP]BackUp is started	arcserveUDPBackUp.ps1	none	none
[arcserveUDP]	none	Run a command before a backup is started	none
[arcserveUDP]snapshot is taken make end_snapshot.flg	none	Run a command after a snapshot is taken	end_snapshot.bat
Waiting for VMwareSnapshot taken(make end_snapshot.flg)	Waiting for end_snapshot.flg existing	none
Change To Normal Mode	OracleDB2NormalMode.ps1	none	none
Delete archive log	OracleDeleteArchive.log	none	none
Delete Old Log	FileMaintenance.ps1	none	none
[arcserveUDP]backup job is completed and arcserveUDP Delete BackupDB.flg&end_snapshot.flg	none	Run a command after a backup is completed	end_arcserve.bat
[backup job is crashed and .flg files remain]Waiting for .flg Deleted	Waiting for end_snapshot.flg is deleted in planed elapsed time	none	none
[Recovery]Change To Normal Mode	OracleDB2NormalMode.ps1	none	none
[Recovery]Delete BackupDB.flg&end_snapshot.flg	end_arcserve.bat	none	none

And mark [Run a command even when the job fails]

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