Hi, All.

I need to create a clone of one of my databases using a backup from almost 4 months ago.
I created a auxiliary instance and made all the necessary configurations (I've already done it before a couple of times).
But when I issued the following command:

RMAN> RUN {
2> DUPLICATE TARGET DATABASE TO XYZOLD
3> UNTIL TIME "TO_DATE('05/05/2006 20:45:00','DD/MM/YYYY HH24:MI:SS')"
4> LOGFILE
5> GROUP 1 ( 'D:\oracle\oradata\XYZOLD\redo01.log' ) SIZE 100M REUSE,
6> GROUP 2 ( 'D:\oracle\oradata\XYZOLD\redo02.log' ) SIZE 100M REUSE,
7> GROUP 3 ( 'D:\oracle\oradata\XYZOLD\redo03.log' ) SIZE 100M REUSE;
8> }

This was the result:

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 09/01/2006 13:33:21
RMAN-03015: error occurred in stored script Memory Script
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore

After some research I figured out RMAN isn't locating the necessary backups. But I'm sure the files in the correct location.
I wonder it was because I'm using control file to keep backup log and it doesn't have information about backups older than 30 days.
I know I always can do a disaster recovery on another server, but I really want to know if there is a way to accomplish it in the same server using duplicate command.

Any feedback will be greatly appreciated.

Cláudio Palha


Oracle LazyDBA home page