Backup and Recovery is the single most important task of a DBA. No matter how efficiently you do all the other tasks like installation, configuration, performance tuning etc. if your data is not safe then they are of no use. While backing up Oracle database first thing you need to know is what to backup.
There are four types of files that are needed to backup.
The first type of files is your relative operating system files. You need to consult your operating system documentation for important files of your operating system. These files do not change over the normal operation of database so you don't have to backup them regularly. Normally a backup after all the upgrades and patches installed is sufficient.
The second type of files is Oracle product binary files. Like the first category of files they also do not change regularly so you don't have to backup them continuously. A backup after the entire configuration is normally good enough.
The third type of files is your database data files and control files. These are the files that are of most importance and you had to backup them regularly because they frequently change in normal day to day operations. You must schedule a backup for these files on daily basis depending on your system’s requirements.
The last type of files consists of files recording changes to your database namely redo logs. Well in certain situations you need their backup otherwise it really does not matter whether you have backup them or not. Redo logs do not mean the archived redo logs which are essential for the database recovery. Archived redo logs are normally backed up with data and control files. Without archived redo logs your data is safe but may be of no use if it requires recovery.
There are four types of files that are needed to backup.
The first type of files is your relative operating system files. You need to consult your operating system documentation for important files of your operating system. These files do not change over the normal operation of database so you don't have to backup them regularly. Normally a backup after all the upgrades and patches installed is sufficient.
The second type of files is Oracle product binary files. Like the first category of files they also do not change regularly so you don't have to backup them continuously. A backup after the entire configuration is normally good enough.
The third type of files is your database data files and control files. These are the files that are of most importance and you had to backup them regularly because they frequently change in normal day to day operations. You must schedule a backup for these files on daily basis depending on your system’s requirements.
The last type of files consists of files recording changes to your database namely redo logs. Well in certain situations you need their backup otherwise it really does not matter whether you have backup them or not. Redo logs do not mean the archived redo logs which are essential for the database recovery. Archived redo logs are normally backed up with data and control files. Without archived redo logs your data is safe but may be of no use if it requires recovery.
No comments:
Post a Comment