Describes how Oracle database logical and physical backups are.

Source: Internet
Author: User

Describes how Oracle database logical and physical backups are.

Answer: Oracle backups include logical and physical backups.

1). Logical backup

A logical backup of a database consists of reading a database recordset and writing a recordset to a file.

A. The output (export) output can be an entire database, a specified user, or a specified table.

B. The input (import) input reads the binary dump file created by the output and executes its commands.

2). Physical backup

A physical backup contains a copy of the file that makes up the database, regardless of its logical content.

Oracle supports two different types of physical file backups: Offline backups (offline Backup) and online backup.

A. Offline Backup: When the database is "offline" when the database is shut down properly, the following files are backed up:

All data files

All control files

All online logs

Init.ora (optional)

B Online Backup: Online backup can be used to back up any database that works in Archivelog mode. In this way, the online log is archived and a complete record of all jobs is established within the database. The online backup process has powerful features. First, a complete point-in-time (point-in-time) recovery is provided. Second, allow the database to remain open while the file system is being backed up.

Describes how Oracle database logical and physical backups are.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.