Oracle Data Backup

Oracle Data Backup problems are often encountered when learning Oracle. Here we will introduce the solutions to Oracle Data Backup problems. 06. After nearly half a year of secondment in the State Bureau, the company is mainly responsible for the technical testing of the system. After half a year of study and work, talk about Oracle data backup and recovery testing in system technical testing.

The main task of technical testing is to focus on the technical functions, technical performance, and security of the system, provide technical testing basis for the testing work, and cooperate with the business testing solution, in order to make the test work more comprehensive, more in-depth discovery or confirmation of System Application Software defects or errors, and propose amendments, so as to improve the application software business functions and technical performance, discover as many software problems as possible before going online and running, and ensure that the system application software meets the expected quality requirements. Oracle data backup and recovery testing is particularly important.

Oracle data backup and recovery

Oracle data backup is a process in which data is retained in some way for reuse in the event of system damage or other specific circumstances. The host operating system backup goal is to have the ability to quickly restore the entire system to meet the requirements of no data loss or loss, the fastest recovery speed, and the shortest service interruption time. Because the host operating system is generally less changed, and popular host systems generally provide comprehensive operating system backup solutions and methods, backup of the host operating system can be completed by using the existing functions of the host system, combined with the built-in tape drive device on the host, and multiple backup tapes are stored in different places. In addition, key data such as operating system configuration files should be backed up on a regular basis.

Application system backup and recovery

Application Software backup is to ensure rapid recovery when the application system is paralyzed. Application Software backup can be completed through the operating system and built-in tape drive device. However, considering that application software versions are updated and upgraded frequently, some program modules are often modified to varying degrees. The old software versions must be retained to ensure the security and high recoverability of the application software, therefore, a backup is required after each version update. At the same time, you can consider configuring the version management software to manage the application software.

Database backup and recovery

The historical database has a large amount of data and needs to be backed up directly to the tape library. However, the backup time will be long after the 0-level backup mode is adopted. Therefore, the Incremental backup mode is recommended, use RMAN technology to back up data to the in-band database.
Either of the following two types of Incremental Backup can be used or used in combination.

1. Incremental backup copies all data changed since the last full backup or Incremental backup. You must use a full backup tape, no matter how old it is) and all subsequent incremental backups to restore the server. Incremental Backup marks the file as backed up, and clears or resets the archive attributes.

2. Differential backup data changed since the last full backup. To restore the entire system, you need a full backup tape and the latest differential tape. Differential backup does not mark the file as backed up, that is, it does not clear the archive attribute ). Combined with ORACLE/RMAN, zero-level backup, Incremental backup, differential backup, and archive logs are used for full recovery and Incomplete recovery at the assumed time point to ensure the data integrity of the database. The following is a comprehensive test based on various backup and recovery methods. The preceding section describes Oracle data backup.

1. Analysis and Discussion on Oracle Database Restoration
2. Oracle remote disk image
3. New Oracle 11g function display
4. Detailed analysis of Oracle XML data
5. Oracle Data Guard