1 Reply Latest reply: Jun 30, 2012 4:39 PM by tychos RSS

    Oracle 9i restore to point in time

    de*446350*is
      We are performing everyday full backups (plus archivelogs) using rman on our Oracle9i RAC database (in archivelog mode). The backup takes around 3 hours to complete. After we start the backup we wait for about 1 hour and then start transacting on the database through our application. Is it possible to take that backup and restore on a different database to the point in time when the backup started (or at any time within the first 1 hour window) assuming we take a backup of the controlfile at some point before or after the backup?

      Edited by: de**** on Jun 30, 2012 2:01 AM
        • 1. Re: Oracle 9i restore to point in time
          tychos
          Hi de****,
          Is it possible to take that backup and restore on a different database to the point in time when the backup started
          You will need the previous backup plus all archivelogs to restore/recover to that point in time (PIT).
          The easiest would be to do an rman duplicate and take a PIT at the moment the hotbackup does the second archivelog backup run started.
          There are plenty of examples in this forum on how to do a duplicate.
          Regards,
          Tycho