learn-oracle

Oracle DBA






Backup and Recovery Concepts


Oracle Jobs

Ask A Question

SQL Statement Tuning

Oracle 11g New Features

Oracle E Suite & Others

Oracle Data Guard

Oracle DBA FAQ



Basic Backup and Recovery Concepts

In general, backup and recovery refers to the various strategies and procedures involved in protecting your database against data loss and reconstructing the data should that loss occur.
Errors and Failures Requiring Recovery

Several problems can halt the normal operation of an Oracle database or affect database I/O operations. The following sections describe the most common types of problems.
Data Structures Used for Recovery

Several structures of an Oracle database safeguard data against possible failures. This section introduces each of these structures and its role in backup and recovery.
Database Archiving Modes

A database can operate in two distinct modes: NOARCHIVELOG mode (media recovery disabled) or ARCHIVELOG mode (media recovery enabled).
 
Whole Database and Partial Database Backups

A whole database backup includes backups of the current control file along with all datafiles. Whole database backups are the most common type of backup. Read on to know more about Backup and Recovery Concepts
Consistent and Inconsistent Backups

You can use RMAN or operating system commands to make an inconsistent backup or a consistent backup. An inconsistent backup is a backup of one or more database files that Oracle DBA make while the database is open or after the database has shut down abnormally.
Online, Offline, RMAN and User Managed Backups

You can back up all or specified datafiles of an online tablespace while the database is open, but only when the database runs in ARCHIVELOG mode.
Types of Oracle Recovery

Crash recovery is used to recover from a failure either when a single-instance database crashes or all instances of an Oracle Real Application Clusters database crashes. Click on the above link to read more and to become a Oracle DBA.
Redo Application During Recovery

Database buffers in the buffer cache in the SGA are written to disk only when necessary, using a least-recently-used (LRU) algorithm. Read more about backup and recovery concepts
Complete and incomplete recovery

Media recovery updates a backup to either to the current or to a specified noncurrent time. When performing media recovery, you can recover the whole database, a tablespace, or a datafile. In any case, you always use a restored backup to perform the recovery
RMAN and User-Managed Restore and Recovery

Oracle DBA can use the RMAN utility to restore and recover the database orRestore backups by means of operating system utilities, and then recover by executing the SQL*Plus RECOVER command .
Oracle Backup Strategies

Before you create an Oracle database, decide how to protect the database against potential media failures. If you do not develop a backup strategy before creating your database, then Oracle DBA may not be able to perform recovery if a disk failure damages the datafiles, online redo log files, or control files. Know more about Backup and Recovery
Restore and Recovery Strategies

Oracle provides a variety of procedures and tools to assist you with recovery.

More Tutorials on Oracle dba ...

Discuss Backup and Recovery Concepts



Liked it ? Want to share it ? Social Bookmarking

Add to: Mr. Wong Add to: BoniTrust Add to: Newsider Add to: Digg Add to: Del.icio.us Add to: Reddit Add to: Jumptags Add to: StumbleUpon Add to: Slashdot Add to: Netscape Add to: Furl Add to: Yahoo Add to: Spurl Add to: Google Add to: Blinklist Add to: Technorati Add to: Newsvine Information


Source : Website | Return to Learn Oracle

Want to share or request Oracle Tutorial articles to become a Oracle DBA. Direct your requests to webmaster@oracleonline.info





   Forum
Oracle Forum   
Google

Oracle DBA Tutorial
Introduction
Installation
Oracle Enterprise Manager
Configuring client/server network
Database Instance
Database Storage Structures
DBA Accounts
Managing Oracle Objects
Backup & Recovery Concepts
Database Monitoring