Call now: 252-767-6166  
Oracle Training Oracle Support Development Oracle Apps

 
 Home
 E-mail Us
 Oracle Articles
New Oracle Articles


 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog


 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Analysis
 Design
 Implementation
 Oracle Support


 SQL Tuning
 Security

 Oracle UNIX
 Oracle Linux
 Monitoring
 Remote s
upport
 Remote plans
 Remote
services
 Application Server

 Applications
 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S
upport  
 Development  

 Implementation


 Consulting Staff
 Consulting Prices
 Help Wanted!

 


 Oracle Posters
 Oracle Books

 Oracle Scripts
 Ion
 Excel-DB  

Don Burleson Blog 


 

 

 


 

 

 

 
 

Oracle Concepts - RMAN Online & Offline backups

Oracle Tips by Burleson Consulting

RMAN Offline Backup

Recall that an offline backup is a backup of the database while it is not running. Hence, to perform our backup we will shutdown the database from RMAN and then mount the database. We will perform the backup. Once the backup is complete we will restart the database again. Here is an example of this process:

RMAN>shutdown immediate

RMAN>startup mount

RMAN>backup database;

RMAN>sql ?alter database open?;

Once this process is complete, you have completed your first backup. Recall that we configured a redundancy of 2 for the backups. RMAN will reclaim the space from the flash recovery area automatically as required, removing all unneeded backups. Later in this chapter, we will demonstrate how to recover your database from this backup.

RMAN Online Backups

As the name implies, an online backup allows you to backup the database while users are working. Some newer DBAs are a little afraid of online backups, and that somehow they might not work. We assure you that I've yet to see a correctly done online backup fail to be recoverable. Most shops these days use online backups at least for their production systems. For a large number of shops online backups are the only backups they ever make.

In this section we will walk you through doing an online backup. First, you will need to put your database in ARCHIVELOG mode as discussed earlier in chapter three of this book.

Then you should configure your database and RMAN as we describe in the above section of this book titled ?Configure the Database and RMAN for our Backup?. Once that is done, you are ready to do an online backup with RMAN.

Online (Hot) Backup of Oracle with RMAN

Once you setup the database and RMAN to support hot backups, doing the backup is insanely easy. In fact, it takes fewer RMAN commands than an offline backup does, can you believe that? Here is the RMAN command that you will use to kick off a backup of your database:

RMAN>backup database plus archivelog delete input;

This command will backup your database. Along with the database backup, it will backup all the archived redo logs that have been generated by your database (see chapter 3 for a discussion on archived redo logs). These archived redo logs are very important to be able to recover your database so we back them up at the same time.

You can backup archived redo logs by themselves from time to time by issuing this command:

RMAN>backup archivelog all delete input;

Note in both examples the use of the delete input command. This will cause the source archive redo logs to be removed once they are backed up.  Don't worry, the delete input command will not try to delete your database or datafiles!  There are a number of other options that you may want to explore with regards to backup retention and archived redo log retention.

Also, see my notes on the different backup types and the differences between incremental cumulative and incremental differential backups.

 
 
 
Get the Complete
Oracle Backup & Recovery Details 

The landmark book "Oracle Backup & Recovery: Expert secrets for using RMAN and Data Pump " provides real world advice for resolving the most difficult Oracle performance and recovery issues. Buy it for 40% off directly from the publisher.
 


 

 

��  
 
 
Oracle Training at Sea
 
 
 
 
oracle dba poster
 

 
Follow us on Twitter 
 
Oracle performance tuning software 
 
Oracle Linux poster
 
 
 

 

Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  and include the URL for the page.


                    









Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


 

Copyright © 1996 -  2016

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.