arcserveUDP & Oracle Database Best Practice
| arcserve setting | script |
|---|---|
| Before backup | pre_arcserve.bat |
| After Snap shot | post_arcserve.bat |
| after backup | end_arcserve.bat |
| 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]Start arcserveUDP_BackUp | arcserveUDPBackUp.ps1 | none | none |
| [arcserveUDP] | none | Before backup | none |
| [arcserveUDP]finish snapshot make end_snapshot.flg |
none | After Snap shot | end_snapshot.bat |
| Waiting for finishing VMwareSnapshot(existing 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 |
| [arcserveUDP]End arcserveUDP | none | After complete backup | end_arcserve.bat |
| finish arcserveUDP Delete BackupDB.flg&end_snapshot.flg |
none | after backup | end_arcserve.bat |
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