That’s Me

Gavin Soorma
  • Oracle Certified Professional
    • 7.3, 8i, 9i,10g, 11g
  • 11i Apps DBA OCP
    •
  • 10g RAC OCE
    •
  • Certified GoldenGate Implementation Specialist
    •
  • 10g OCM
    •
  • 11g OCM
    •

    Feedback

    2,409,840 hits

    Thanks A MILLION for your support!

    Please send me your valuable feedback and suggestions

    Recovery Scenarios

  • NOARCHIVELOG Database Recovery
  • RMAN Restore on another machine with different file system- same database name
    		•
  • RMAN duplicate database on the same host
    		•
  • Loss Of All Files – Disaster Recovery
    		•
  • Incomplete Recovery (until point in time)
    		•
  • Incomplete Recovery (until log sequence)
    		•
  • Loss of all online redo log files
    		•
  • Loss of all controlfiles
    		•
  • Recovery when no backup exists of a datafile
  • Corrupted Block Recovery
  • Loss of Non SYSTEM datafile
    		•
  • Tablespace Recovery
    		•
  • Tesing the full restore and recovery of a database backup on another test or scratch server
    		•
  • Refreshing a Test or Development Database from a Production Database RMAN backup

  • Recovery through RESETLOGS and reset of incarnation

  • Performing a database clone using a Data Guard physical standby database
    		•

    2 comments to Recovery Scenarios

    • gurwinder singh
      February 25, 2010 at 5:50 pm

      V.V good help

      Thanks
      Gurwinder singh
      Cell no -> 09871042700

    • Ata
      March 22, 2010 at 4:36 pm

      Gavin,

      Good exercises…but few things to update.

      1. Without having allocate channels, host cpu & disk I/O will consumes alot. As I tried to had “top” & “glance” in parallel, and i could notice it’s consuming alot when trying to restore < 100 GB of database on HP-UX ia64 which has 16 GB of ram. Well, we could release those soon after completion

      2. Also in case of back-dated restoration where by you need to restore the control files from backup piece tags; at that stage , database will not be in a mounted state. In such cases, when you login to rman, we might have to get dbid from "rc_database" and have to set dbid prior to restoration.

      Thanks for sharing good workshop exercises…and request if you could thru light on advance RMAN concepts.

      Rgrds
      ATA

    Leave a Reply

      

      

      

    You can use these HTML tags

    <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>