Derek,
I´m restoring from disk.
I've already done this procedure several times before.
But this is the first time I try to use such an old backup.
I bet the problem is related to the use of control file instead of a recovery catalog.
Claudio.
-----Mensagem original-----
De: Nkansah Derek [mailto:oracledba-ezmlmshield-x63629118.[Email address protected]
Enviada em: terça-feira, 5 de setembro de 2006 09:08
Para: LazyDBA Discussion
Assunto: RE: Help on duplicate database
Claudio,
Where is the restore from?? Disk or tape?? You may have to allocate a channel, even if this is to disk.
I can't also see the connection to the auxiliary database. That must be done before the duplication can take place.
-----Original Message-----
From: Cláudio Palha [mailto:oracledba-ezmlmshield-x6191057.[Email address protected]
Sent: 01 September 2006 19:47
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
This e-mail (and any attachments) contains information, which is confidential and intended solely for the attention and use of the named addressee(s). If you are not the intended recipient you must not copy, distribute or use it for any purpose or disclose the contents to any person. If you have received this e-mail in error, please notify us immediately at [Email address protected] The information contained in this e-mail (and any attachments) is supplied in good faith, but the sender shall not be under any liability in damages or otherwise for any reliance that may be placed upon it by the recipient. Any comments or opinions expressed are those of the originator not of NTT Europe Ltd unless otherwise expressly stated.
---------------------------------------------------------------------
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