Alejandro Vargas' Blog

  • June 5, 2008

Oracle Recovery Manager ( RMAN) Hands On Practice

Alejandro Vargas
Technical Leader, ACS Global Delivery, Infrastructure & BigData

Oracle Recovery Manager, RMAN, is at the same time simple and complex, it's sintax can be as direct as 'backup database' to make a whole database backup, and as complex as it can be to make possible the most sophisticated and complex backup and recovery tasks.

This post covers a series of tests I did prepare to show how Rman works, the tar of the scripts contained on the guide can be downloaded here.

This RMAN Hands-On guide, once you have configured the environment, can be followed in about 3 hours, it covers the basics of Backup, Restore and Recovery of Oracle Databases using RMAN.

This hands on practice is organized into 4 chapters

  • BACKUP  

Each chapter contains a set of scripts that can be executed in order to implement the practice, it teaches the following points:

  • Build and administer an Rman Catalog
  • Use different techniques for backing up a Database
  • And the most important: How to restore and recover the database in different crisis scenarios

Join the discussion

Comments ( 6 )
  • Pasko Sunday, June 8, 2008
    Hi Alejandro,
    This is a Great Article!
    Thanks very much for your great rman Article.
    I am also using rman for our RAC Database.We are not using catalog database at the moment.
    I have a few questions:
    1.Can we use the Oracle XE as rman catalog DB?
    and if we use a separate Catalog DB, do we have to license this Database?
    2.When i want to make a rman consistent backup on RAC environment,i will have to first do a shutdown immediate, startup mount and then perform rman cold backup.
    Do we have to shutdown and startup mount all RAC instances to do this or we can just do this on one RAC instance while keeping the other instance(s) online?
    Do we have to change cluster_database=false before doing this?
    3.We are using ASM + RMAN + FRA for our Databases.We are also backing up to tape using Networker software.
    I have rman default device type set to disk,
    but we also have tape channels configured.
    When i perform a crosscheck command , will this command be done for both disk and tape channels or will rman only crosscheck for files on disk?
    What will be the behavior when i do a delete obsolete/expired command while having default device type disk, but at the same time having configured tape channels.
    4.The rman commands:
    4.1 backup recovery area and
    4.2 backup recovery files
    command 4.1 backs up all recovery files + backupsets from FRA to tape.
    On what occasion do we have to use command 4.2?
    Do we use command 4.2 if one has not configured FRA?
    Best Regards,
  • Rick Wednesday, June 11, 2008
    Hi Alejandro,
    Have read your hands on with interest. I'm missing a part in the migration of datafiles to ASM. The tool used is RMAN. All files work freat except for the control files, as we have a standby which will migrate later in time I cannot afford to do a "alter database open resetlogs". How can I put the controlfiles in ASM without doing a resetlogs??
  • Cliff Wakefield Sunday, June 15, 2008
    The link for the tar ball of scripts seems to be missing.
  • Ofir Manor Thursday, June 19, 2008
    Hi Alejandro,
    thanks for the amazing detailed presentation!
  • Asif Momen Friday, July 18, 2008
    Nice compilation.
  • Mubarak Ali Saturday, March 28, 2009
    Unfortunatly i deleted some archivelog in production 2 weeks back, then i found rman backup not successfull because of deleted archive, then i found deleted archived log from phycsical standby server & copied those to production archivelog location scn from 26420 to 27115.
    this week i took rman backup, it was completed but those copied archived not backedup atleast one. i checked tru a view v$archived_log column status,archived,backup_count result
    A yes 0
    i crosschecked the archivelog, to delete unwanted archived & deleted using delete noprompt obsolete
    what is the work around to take backup those archive or no need to backup those archive (i took full backup only those archive only not backedup, so i could not delete those from archive location using absolete option)
    i m having daily Hotbacku & full dump backup also (20 GB )size of database.
    plase reply me.
    thanks in advance.
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.