Using Volume shadow copy service to perform Oracle Database cold backup (Windows 2003,2008 servers only)In this article we will show how you can use advantages of Microsoft's Volume Shadow Copy service (VSS) to backup Oracle Database. This method is useful for all versions of Oracle DataBases running on Windows 2003 server and later platforms.
The backup can be done as follows:
- Shutdown Oracle server for a short time;
- Create read-only snapshot of a volume with Oracle DataBase files;
- StartUp Oracle server;
- Start backup process of Oracle DataBase files from the shadow copy. The shadow copy will include Oracle DataBase files in closed state, because the DataBase was shutted down at the time of snapshot creation;
- Delete shadow copy when the backup will be created.
All five steps can be fully automated for executing as a single unattended backup job using d_back as backup tool. Take a look at the screenshots of the backup profile:
Directory D:\ORADATA contains all Oracle DataBase files, including control files and redo log files. This directory must be included into backup profile with all it subdirectories. Pay Attention on Path properties: to activate VSS feature you must check option Backup Files that are in Use or Locked.