Uh-huh, in 10g you can specify backuppiece. Probably time to read through the whole RMAN doc or open an SR. Hopefully someone else will have the answer for you. Good luck.

-----Original Message-----
From: Cláudio Palha [mailto:oracledba-ezmlmshield-x6191057.[Email address protected]
Sent: Friday, September 01, 2006 12:47 PM
To: LazyDBA Discussion
Subject: RES: Help on duplicate database

Hi, Jed.

Thanks for your suggestion.

I thought using it but as you can see at the following link, CATALOG can´t be used to recatalog backup pieces or backup sets.

http://download-east.oracle.com/docs/cd/B10501_01/server.920/a96565/rcmsynta11.htm

Cláudio

-----Mensagem original-----
De: Walker Jed S [mailto:oracledba-ezmlmshield-x67444147.[Email address protected]
Enviada em: sexta-feira, 1 de setembro de 2006 14:58
Para: LazyDBA Discussion
Assunto: RE: Help on duplicate database

If you're using the controlfile for your catalog, then you might need to use the "catalog" command to re-catalog the backup files that it lost track of due to control_file_record_keep_time

-----Original Message-----
From: Cláudio Palha [mailto:oracledba-ezmlmshield-x89685293.[Email address protected]
Sent: Friday, September 01, 2006 11:24 AM
To: LazyDBA Discussion
Subject: Help on duplicate database

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



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page