DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: another RMAN restore question

Hybrid View

  1. #1
    Join Date
    Jan 2001
    Posts
    157

    Unhappy

    so what if I resynced my recovery catalog at
    10:00AM and there has been high transaction after that.
    I'm automatically archiving. And the database crashes at 2:00PM
    Would I be able to recover everything uptill the time
    the database crashed or I would only be able
    to recover up to the last time the recovery catalog was
    resynced?

    run {
    allocate channel ch1 type disk;
    backup database
    format '/oracle/storage/backup%U';
    sql 'ALTER SYSTEM ARCHIVE LOG CURRENT';
    sql 'ALTER SYSTEM ARCHIVE LOG ALL';
    }


  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    If you don't specify the until option rman would recover your database to the point of failure, this includes that of applying the archive logs from the backupset and also the ones from the disk.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Nov 2001
    Posts
    335
    To answer your question :

    I will be able to recover as long as you have all archived logs available between 10 a.m. and 2 p.m in addition to whatever archives are required to bring database up to 10 a.m.

    Am I coming across with my point?
    One, who thinks that the other one who thinks that know and does not know, does not know either!

  4. #4
    Join Date
    Jan 2001
    Posts
    157
    Thanks to all of you. Your help has been very helpful

  5. #5
    Join Date
    Oct 2001
    Location
    Pelham, AL
    Posts
    40
    A better way to handle this is to setup a cron job that will resync the catalog frequently - I do mine every hour.

Posting Permissions

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


Click Here to Expand Forum to Full Width