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:
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