Describes how Oracle database logical and physical backups are.

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.