How To Get Time/Scn From Last Night Backup To Create Duplicate Database [ID 560328.1]

How To Get Time/Scn From Last Night Backup To Create Duplicate Database [ID 560328.1]
		Modified 02-APR-2008     Type HOWTO     Status MODERATED

In this Document
  Goal
  Solution

---

 

 

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.

 

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.3
Information in this document applies to any platform.

Goal

You want to use the RMAN duplicate command to create a duplicate database.  How do you obtain the correct SCN/time value to use in the SET UNTIL command?

Solution

The sql commands to accomplish this are as follows:

sql> select max(sequence#)
from v$log_history
where RESETLOGS_TIME =
(select max(resetlogs_time)
from v$log_history);


Use the results in your set until clause. For example

set until logseq = xxxxx;


You may also obtain the SCN from v$archived_log as follows:

sql> select first_change#, next_change# from v$archived_log where sequence#=<results from
query on v$log_history above>;


The stop value would be next_change# column.

---

 

Related Products Oracle Database Products > Oracle Database > Oracle Database > Oracle Server - Enterprise Edition