3 Replies Latest reply: Jan 2, 2013 3:51 AM by CKPT RSS

    find restore point

    902332
      Hi all,

      As per our requirement we restore the database up to 25th Dec 2012 at 07:00am with rman backups.

      how we can confirm that the database is restored is up to this point of time only. is there any query or procedure.

      Please help to find this.

      thanks..
        • 1. Re: find restore point
          Osama_Mustafa
          use
           set until time "to_date('2012-12-25:00:00:00', 'yyyy-mm-dd:hh24:mi:ss')";
          • 2. Re: find restore point
            hitgon
            SELECT scn, time, database_incarnation#, guarantee_flashback_database from
            v$restore_point;
            • 3. Re: find restore point
              CKPT
              899329 wrote:
              Hi all,

              As per our requirement we restore the database up to 25th Dec 2012 at 07:00am with rman backups.

              how we can confirm that the database is restored is up to this point of time only. is there any query or procedure.

              Please help to find this.

              thanks..
              You can check using below query, Once you restored and recovered you have to open resetlogs so resetlogs time can give you the answer.
              SQL>  select resetlogs_change#,to_char(resetlogs_time, 'DD-MON-YYYY HH24:MI:SS') Last_resetlog_time from v$database_incarnation;
              
              RESETLOGS_CHANGE# LAST_RESETLOG_TIME
              ----------------- --------------------
                              1 11-SEP-2008 22:57:51
                         88033 23-MAY-2011 10:12:42
              
              SQL>