This content has been marked as final. Show 3 replies
set until time "to_date('2012-12-25:00:00:00', 'yyyy-mm-dd:hh24:mi:ss')";
SELECT scn, time, database_incarnation#, guarantee_flashback_database from1 person found this helpful
1 person found this helpful
899329 wrote:You can check using below query, Once you restored and recovered you have to open resetlogs so resetlogs time can give you the answer.
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.
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>