RMAN Duplication with set until time

All posts relating to Oracle database administration.

Moderator: Tim...

Senior Member
Posts: 141
Joined: Wed Mar 07, 2007 6:53 am
Location: Mumbai

RMAN Duplication with set until time

Postby Sagar » Thu Sep 26, 2013 6:26 am

HI Tim

I want to refresh Database using rman HOT BACKUP
below is the backup
Sep 26 20:15 Data_PROD.bak
Sep 26 20:36 Data_PROD.bak
Sep 26 20:56 Data_PROD.bak
Sep 26 21:11 Data_PROD.bak
Sep 26 21:33 Data_PROD.bak
Sep 26 21:33 CF_c-20130926-00_PROD.bak
Sep 26 21:36 Arch_15518_1_Archterbu_PROD.bak
Sep 26 21:37 Arch_15519_1_Archterbu_PROD.bak
Sep 26 21:37 Arch_15520_1_Archterbu_PROD.bak
Sep 26 21:40 Arch_15517_1_Archterbu_PROD.bak
Sep 26 21:40 Arch_15514_1_Archterbu_PROD.bak
Sep 26 21:40 Arch_15515_1_Archterbu_PROD.bak
Sep 26 21:40 Arch_15516_1_Archterbu_PROD.bak
Sep 26 21:40 CF_c-20130926-01_PROD.bak

Now when i do refresh with auxiliary
which would be the ideal time to be given in set until time so that target database is automatically opened.

DB is connected to catalog while backup and refresh also
connect target sys/****@targetDB auxiliary /
connect catalog ***/****@catalog
run {
allocate auxiliary channel ch1 type disk;
allocate auxiliary channel ch2 type disk;
set until time "to_date('26-SEP-2013 21:33:00','DD-MON-YYYY HH24:MI:SS') +(1/24/60)"; -- first control file backup

set until time "to_date('26-SEP-2013 21:39:00','DD-MON-YYYY HH24:MI:SS') -(1/24/60)"; -- last control file backup

duplicate target database to XXXX nofilenamecheck;
release channel ch1;
release channel ch2;


Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: RMAN Duplication with set until time

Postby Tim... » Thu Sep 26, 2013 6:04 pm


It's a hot backup, so you will be applying archived redo logs to make it consistent. Pick a point in time you want to recover to, or recovery to the current time if you have all the necessary archived redo logs. I can't look at the files and pick a time for you. :)


Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: https://oracle-base.com
My blog: https://oracle-base.com/blog

Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 3 guests