Oracle
  Home arrow Oracle arrow Page 2 - Availability and Recovery
Dev Shed Forums 
Administration  
AJAX  
Apache  
BrainDump  
DHTML  
Flash  
Java  
JavaScript  
Multimedia  
MySQL  
Oracle  
Perl  
PHP  
Practices  
Python  
Reviews  
Security  
Style-Sheets  
Web Services  
XML  
Zend  
Zope  
Forums Sitemap 
IBM® developerWorks 
Sun Developer Network 
Dedicated Servers 
E-Commerce Hosting 
Linux Web Hosting 
Managed Hosting 
Small Business Hosting 
Actuate Whitepapers 
VeriSign Whitepapers 
VPS Hosting 
Weekly Newsletter

 
Developer Updates  
Free Website Content 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us Get Paid 
Request Media Kit
Contact Us 
Site Map 
Privacy Policy 
Support 
 USERNAME
 
 PASSWORD
 
 
  >>> SIGN UP!  
  Lost Password? 
ORACLE

Availability and Recovery
By: McGraw-Hill/Osborne
  • Search For More Articles!
  • Disclaimer
  • Author Terms
  • Rating: 4 stars4 stars4 stars4 stars4 stars / 15
    2004-09-01

    Table of Contents:
  • Availability and Recovery
  • New and Changed Oracle Database 10g Database Backup Commands
  • RMAN Improvements
  • Setting Up the Flash Recovery Area
  • Using Backup Copies and Fast Recovery
  • Changes to Incremental Backups
  • Compressing RMAN Backups
  • New Flashback Features
  • Using Flashback Database
  • Flashback Database Views
  • Configuring Guaranteed Undo Retention
  • New Transaction Recovery Monitoring Features
  • The valid_for Attribute
  • New Standby Database Parameters
  • New SQL Apply Support for Data Types

  • Rate this Article: Poor Best 
      ADD THIS ARTICLE TO:
      Del.ici.ous Digg
      Blink Simpy
      Google Spurl
      Y! MyWeb Furl
    Email Me Similar Content When Posted
    Add Developer Shed Article Feed To Your Site
    Email Article To Friend
    Print Version Of Article
    PDF Version Of Article
     
     
    ADVERTISEMENT

    Stay one step ahead of the competition. Evaluate and give feedback on some of the hottest web development tools on the market today. Make your opinion heard! Click Here

    Availability and Recovery - New and Changed Oracle Database 10g Database Backup Commands


    (Page 2 of 15 )

    Oracle Database 10g offers a new way to start database backups, with the alter database begin backup command. Also, Oracle Database 10g offers new functionality with the alter database end backup command. Let’s look at each of these features in a bit more detail next.

    The New alter database begin backup Command

    Are you tired of issuing alter tablespace begin backup over and over? Now, putting the entire set of database tablespaces in hot backup mode is as simple as issuing the alter database begin backup command, as shown in this example:

    SQL> alter database begin backup;

    Jonathan Says…

    Of course, the traditional advice is to never put your entire database into hot backup mode at once—so you have to ask yourself why Oracle has now made it very easy to do exactly that. Moreover, why do you need this command at all, when RMAN doesn’t require the database to be in hot backup mode at all?

    As ever, Oracle is giving you lots of options, and you have to decide which one is relevant to your system. If your backup strategy ignores Oracle features and uses a simple “split mirror” approach, you are the one customer who should really be pleased with this new command.

    If there are already tablespaces in hot backup mode, then the Oracle database will raise an error (ORA-01146). Also, the following conditions cause an error to be returned by the alter database begin backup command:
    • One or more datafiles are offline or missing

    • An RMAN backup is ongoing

    Once you have issued the alter database begin backup command successfully, you can proceed to back up your Oracle database. As is the case when you put individual tablespaces in hot backup mode, you will be unable to perform a normal or immediate shutdown on the database after issuing this command. However, you can issue shutdown abort to terminate the instance if that is required (although one would hope this would never be required).

    If the instance crashes or you use the shutdown abort command, you need to take the database out of hot backup mode by using the alter database end backup command … and that is a nice segue to the next topic!

    Changes to the alter database end backup Command

    The alter database end backup command has been around since Oracle9i Database, and its functionality is enhanced in Oracle Database 10g. Previously, the alter database end backup command could be used only when the database was mounted. In Oracle Database 10g, you can use this command to end backups with the database mounted or the database open—your choice! Here is an example of the use of this command:

    SQL> alter database end backup;

    NOTE -- A warning will be issued if any datafiles/tablespaces are not in hot backup mode, but the command will complete successfully.

    This chapter is from Oracle Database 10g New Features, by Robert Freeman (McGraw-Hill/Osborne, 2004, ISBN: 0072229470). Check it out at your favorite bookstore today. Buy this book now.

    More Oracle Articles
    More By McGraw-Hill/Osborne


       · Why pollute DevShed?
     

       

    ORACLE ARTICLES

    - Tuning PL/SQL Code
    - Debugging PL/SQL Code
    - Testing PL/SQL Code
    - Working With PL/SQL Code
    - Conditional Compilation for Oracle Database ...
    - Compile-Time Warnings for Oracle DB 10g
    - Compiling PL/SQL Code for an Oracle Database
    - Troubleshooting PL/SQL Code
    - Managing PL/SQL Code
    - Data Manipulation and More for HTML DB Appli...
    - Oracle Database Fundamentals
    - Adding Processes to HTML DB Applications
    - Adding Computations, Processes, and Validati...
    - Sub-templates and More with Oracle HTML DB
    - Focusing on Templates in Oracle HTML DB





    © 2003-2008 by Developer Shed. All rights reserved. DS Cluster 2 hosted by Hostway