Home » Oracle » Oracle Database » Introduction to Oracle database Backup

Introduction to Oracle database Backup

Here in this section, We are giving the Introduction to Oracle database backup

What is Oracle Database backup?

  • A backup is a snapshot of a data file, tablespace, or database at a certain time.
  • This copy can include important parts of a database such as the control file, redo logs and datafiles
  • A backup protects data from application error and acts as a safeguard against unexpected data loss, by providing a way to restore original data


There are two types in which Oracle database can be backed up
1)Physical backups are copies of physical database files
2) logical backups contain data that is exported using SQL commands and stored in a binary file. They are used to supplement physical backups.


Key structure for physical backups


The Key data structures of backup and recovery must be identified :
Datafiles

Every Oracle database has one or more physical datafiles that belong to logical structures called tablespaces

Control Files

The control file contains important structural information about the database like database name, timestamp of database creation, names and locations of database’s datafiles and online and archived redo log files. It also contains checkpoint information and optionally RMAN metadata

Online Redo log files

Every Oracle database contains a set of two or more online redo log files. oracle assigns every redo log file a log sequence number to uniquely identify it. Oracle uses the redo log to record all changes made to the database. Oracle records every change in a redo record, an entry in the redo buffer describing what has changed

Archived Redo log files

Archived log files are redo logs that Oracle has filled with redo entries, rendered inactive, and copied to one or more log archive destinations. Oracle can be run in either of two modes:

See also  ORA-00904: invalid identifier in Oracle

Automatic Managed undo

Every Oracle database must have a method of maintaining information that is used to roll back or undo, changes to the database. Such information consists of records of the actions of transactions, primarily before they are committed

Hope you like this brief Introduction to Oracle database Backup

Related Articles

backup controlfile in RMAN : Check out this post on how to backup controlfile in RMAN, How to backup controlfile to trace, and How to enable auto backup of controlfile
check rman backup status: Check out How to check RMAN backup status in sql, what is the status of the backup and input_type of the backup
RMAN List backup : RMAN List backup commands are used to list the backup taken using RMAN,Date and Time and many other details are included
RMAN Backup commands :Check out the RMAN Backup commands in this post. This is going to be very helpful for the person who is involved in backup and recovery

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top