Logical Backup of Oracle Database

Oracle databases have two types of backup methods. The first class is a physical backup, this method realizes the complete recovery of the database, but the database must run in the return mode (the business database runs in the non-return mode), and it needs a great external storage device, such as a tape library; the second type of backup is a logical backup, and the business database uses this method, This method does not require the database to run in the return mode, not only the backup is simple, but also can not need external storage devices.

Database Logical Backup method

Logical backups of Oracle databases are grouped into three modes: Table backup, user backup, and full backup.

Table mode

Backs up the objects (tables) specified in a user mode. Business databases typically take this form of backup.

If you are backing up to a local file, use the following command:

Exp ICDMAIN/ICD rows=y indexes=n compress=n buffer=65536

feedback=100000 volsize=0

File=exp_icdmain_csd_yyyymmdd.dmp

Log=exp_icdmain_csd_yyyymmdd.log

Tables=icdmain.commoninformation,icdmain.serviceinfo,icdmain.dealinfo

If you are backing up to a tape device directly, use the following command:

Exp ICDMAIN/ICD rows=y indexes=n compress=n buffer=65536

feedback=100000 volsize=0

File=/dev/rmt0

Log=exp_icdmain_csd_yyyymmdd.log

Tables=icdmain.commoninformation,icdmain.serviceinfo,icdmain.dealinfo

Note: In the case of disk space permitting, you should back up to the local server before copying to tape. For speed reasons, try not to back up to tape devices directly.

User mode

Backs up all objects in a user mode. Business databases typically take this form of backup.

If you are backing up to a local file, use the following command:

Exp ICDMAIN/ICD owner=icdmain rows=y indexes=n compress=n buffer=65536

feedback=100000 volsize=0

File=exp_icdmain_yyyymmdd.dmp

Log=exp_icdmain_yyyymmdd.log

If you are backing up to a tape device directly, use the following command:

Exp ICDMAIN/ICD owner=icdmain rows=y indexes=n compress=n buffer=65536

feedback=100000 volsize=0

File=/dev/rmt0

Log=exp_icdmain_yyyymmdd.log

Note: If there is space on the disk, it is recommended that you back up to disk and then copy to tape. If the amount of database data is small, this approach can be used to back up.