Forgot your password?    
+ Reply to Thread
Results 1 to 1 of 1

Thread: Difference / Advantages of Oracle RMAN over User Managed Backups

  1. #1

    Difference / Advantages of Oracle RMAN over User Managed Backups

    RMAN User Managed Backups
    When backing up online files, RMAN rereads fractured data blocks to get a consistent read. You do not need to place online table spaces in backup mode when performing backups Requires placing online tablespaces in backup mode before backing them up, and then taking the tablespaces out of this mode after the backup is complete. Serious database performance and manageability problems can occur if you neglect to take tablespaces out of backup mode after an online backup is complete.
    Performs incremental backups, which back up only those data blocks that changed after a previous backup. You can recover the database using incremental backups, which means that you can recover a NOARCHIVELOG database. However, you can only take incremental backups of a NOARCHIVELOG database after a consistent shutdown. Backs up all blocks, not just the changed blocks. Does not allow you to recover a NOARCHIVELOG database.
    Checks for corrupt blocks when backing up or restoring. Can also compute checksums for each block during a backup. Many of the integrity checks that are normally performed when executing SQL are also performed when backing up or restoring. Does not provide error checking.
    Omits never-used blocks from datafile backups so that only data blocks that have been written to be included in a backup. Includes all data blocks, regardless of whether they contain data.
    Uses the repository to report on crucial information, including:
    • Database schema at a specified time
    • Which files need a backup
    • Which files have not had a backup in a specified number of days
    • Which backups can be deleted because they are redundant or cannot be used for recovery
    • Current RMAN persistent settings
    Does not include any reporting functionality.
    Stores RMAN scripts in the recovery catalog. Requires storage and maintenance of operating system-based scripts.
    Allows you to easily create a duplicate of the production database for testing purposes, or easily create or back up a standby database. Requires you to follow a complicated procedure when creating a test or standby database.
    Performs checks to determine whether backups on disk or in the media catalog are still available. Requires you to locate and test backups manually.
    Performs automatic parallelization of backup and restore operations. Requires you to parallelize manually by determining which files you need to back up and then issuing operating system commands in parallel.
    Tests whether files can be backed up or restored without actually performing the backup or restore. Requires you to actually restore backup files before you can perform a trial recovery of the backups.
    Performs archived log failover automatically. If RMAN discovers a corrupt or missing log during a backup, then it considers all logs and log copies listed in the repository as alternative candidates for the backup. Cannot failover to an alternative archived log if the backup encounters a problem.
    Last edited by Hemant; 02-10-2012 at 03:34 PM.

+ Reply to Thread

Similar Threads

  1. RMAN Backup , List ,Configure and Report Backups
    By Hemant in forum Backup, Restoration & Recovery, RMAN, Flashback, Datapump, Export, Import
    Replies: 4
    Last Post: 02-10-2012, 02:36 PM
  2. Enable block change tracking in Oracle for RMAN backups
    By Amit in forum Backup, Restoration & Recovery, RMAN, Flashback, Datapump, Export, Import
    Replies: 2
    Last Post: 02-03-2012, 02:04 PM
  3. Replies: 1
    Last Post: 01-01-2012, 03:50 PM
  4. Loss of system datafile in Database (User Managed Recovery)
    By ajaysingh in forum Backup, Restoration & Recovery, RMAN, Flashback, Datapump, Export, Import
    Replies: 0
    Last Post: 11-01-2011, 11:54 AM
  5. Loss of all controlfiles of the Database (User Managed Recovery)
    By ajaysingh in forum Backup, Restoration & Recovery, RMAN, Flashback, Datapump, Export, Import
    Replies: 0
    Last Post: 11-01-2011, 11:41 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

DBA Lounge (P) Ltd. deals in Oracle Technologies on Consulting, Resourcing, Corporate Training


Online and corporate training available on Oracle Database 11g, Oracle 11g Real Application Cluster (RAC), Oracle Applications 11i/R12, Oracle Fusion Middleware 11g, Oracle Identity Management-OIM, Oracle Internet Directory 11g-OID, Oracle Business Intelligence Enterprise Edition-OBIEE, Oracle Golden Gate, Oracle Access Management-OAM, Oracle Internet Directory-ODS, Oracle Identity Analytics Architecture-OIA Statistics