Oracle Database Backup Technology

1 Introduction

Oracle database is a large relational database that can store terabytes of data, so how to ensure the security of these data is particularly important, we have been using Oracle database since 1991, through the use of these years, we have developed a complete set of Oracle database backup system. Now we introduce our backup system to you for your reference.

2 determine the operation mode of the database according to the actual needs

There are two ways to run an ORACLE database: One is the Archiving method (Archivelog), and the purpose of archiving is to maximize the recovery of all committed objects when a database fails, and the second is not to archive the way (Noarchivelog), and restore the database to the nearest recycle point. Based on the high availability of the database and the amount of work that the user can afford to lose, we take our officially running database as an archive, and those that are being developed and debugged are not archived.

3 How to change the way the database runs

3. 1 How the database is to be run when the database is created

When you create a database, as part of creating a database, you determine how the database was initially archived. In general, it is Noarchivelog way. When the database is created, we need to change the database that needs to be run in the way of archiving to Archivelog.

3. 2 change not archived way for the way of archiving

Close the database and back up the existing data. Changing the way the database runs is an important change to the database, so you need to make a backup of the database to protect the problems that may arise.

Start Instance, Mount the database but do not open the database to change the way the file is archived

sqldba lmode=y （ svrmgrl ）
sqldba>connect internal
sqldba>startup mount
sqldba>alter database archivelog;

To enable automatic archiving

In the initialization file Init*.ora (typically placed under the lower directory DBS of the ORACLE root directory), add parameters:

Log_archive_start=true

Specify the Redo logon file name and location of the archive

Also, add the following parameter to the initialization file Init*.ora:

Log_archive_format=%s.arc

Log_archive_dest=/arch12/arch (Arch12 is the directory where log files are stored)

Close the database, restart the database, and archive the conversion complete.

4 Recycling System

4. 1 According to the operation of the database and the amount of work can be lost to determine the database recycling system for not archiving, we use the ORACLE database logical backup Export, the system is: one months for a full backup (X01.DMP), one-week cumulative backup (C*.DMP), One-day incremental backup (I*.DMP), with an incremental backup from Monday to Friday, a cumulative or full backup in Saturday, and automatically uploaded to another machine each time a backup is done. These backups are performed automatically, followed by the program text.

For archiving, we are using a Orcale physical backup: When the database is created, do a physical full backup, usually without shutting down the database, one weeks to the frequently changed data files online database data file physical backup; When the structure of the database changes, such as: Increase the tablespace, Add data files, such as allow shutdown, normal shutdown database, redo database full backup, otherwise, backup control files, backup data files as usual. The online log files are written on the array, without mirrors and backups.