Re: RMAN Confusion (Duplicate to past point in time)

Chris,

RMAN duplicate recreates the controlfile as part of the duplicate process.  This happens after the datafiles are copied to the target server/database.  

Are you getting a specific error from RMAN?  i ran into a similar situation recently where RMAN complained that it couldn't find any datafiles to restore and went back a few backups to do the restore.  I eventually ended up doing a log switch on the source database and then it would use the backup i was expecting it to use.

Hope this helps.
Haroon


________________________________
From: "Taylor, Chris David" <Chris.Taylor_at_ingrambarge.com>
To: Bradd Piontek <piontekdd_at_gmail.com>
Cc: Oracle Discussion List <ORACLE-L_at_freelists.org>
Sent: Monday, May 11, 2009 2:40:05 PM
Subject: RE: RMAN Confusion (Duplicate to past point in time)


Well, thats just it, I don't think its actually restoring 
the controlfile autobackup.  I don't specifically tell RMAN to restore it, 
which I think is part of the problem.
 
Joe mentioned the backups might be expired (which I think 
they are since I had to restore them from tape).
 
I seem to remember running into this before, but I cannot 
remember how to restore the controlfile autobackup when using a 
catalog/repository during a duplicate.
 
 
Chris 
Taylor
Sr. Oracle 
DBA
Ingram Barge Company
Nashville, TN 37205
Office: 615-517-3355
Cell: 615-354-4799
Email: chris.taylor_at_ingrambarge.com
 
CONFIDENTIALITY 
NOTICE: This 
e-mail and any attachments are confidential and may also be privileged. If you 
are not the named recipient, please notify the sender immediately and delete the 
contents of this message without disclosing the contents to anyone, using them 
for any purpose, or storing or copying the information on any 
medium.
 


________________________________
 From: Bradd Piontek [mailto:piontekdd_at_gmail.com] 
Sent: Monday, May 11, 2009 2:38 PM
To: Taylor, Chris 
David
Cc: Oracle Discussion List
Subject: Re: RMAN Confusion 
(Duplicate to past point in time)

Chris,  
 What does the log look like when you run the duplicate? In 
particular, which controlfile autobackup is getting restored during your 
duplicate? Make sure that the April 30th controlfile is being 
restored. 

Bradd Piontek
  "Next to doing a good job yourself, 
        the greatest joy is in having someone 
  
      else do a first-class job under your  
  
      direction."
 -- William Feather



On Mon, May 11, 2009 at 2:33 PM, Taylor, Chris David <Chris.Taylor_at_ingrambarge.com> wrote:

I have a need to create a test db clone  from May 1st 2009 at 7:30 AM.
 
I have the RMAN full backups from April  30th 8:16PM and May 1st 8:30 PM.
 
I am using an RMAN  catalog.
 
Here's my RMAN script:
 
run
{
allocate channel d1 type  disk;
allocate channel d2 type disk;
allocate channel d3 type  disk;
allocate channel d4 type disk;
allocate auxiliary channel a1 type  disk;
allocate auxiliary channel a2 type disk;
allocate auxiliary  channel a3 type disk;
allocate auxiliary channel a4 type disk;
set until  time="to_date('05/01/2009 07:40:00','MM/DD/YYYY  HH24:MI:SS')";
 
duplicate target database to  f9tst
logfile
GROUP  1
(
'G:\oracle\oradata\F9TST\onlinelog\redo01a.log',
'F:\oracle\oradata\F9TST\onlinelog\redo01b.log'
)  size 25M,
GROUP  2
(
'G:\oracle\oradata\F9TST\onlinelog\redo02a.log',
'F:\oracle\oradata\F9TST\onlinelog\redo02b.log'
)  size 25M;
}
 
Now RMAN is complaining that it cannot find  backups which I believe are more current than the ones I have. (Meaning they  were taken from May 2-10th...It seems that RMAN rolls back to previous backups  starting with the current one and maybe only tries 3 days worth  perhaps?)
 
I have the controlfile autobackups from  4/30 and 5/1 as well.
 
I need some suggestions here as I seem to  be missing something.
 
 
Chris  Taylor
Sr. Oracle  DBA
Ingram Barge Company
Nashville, TN 37205
Office: 615-517-3355
Cell: 615-354-4799
Email: chris.taylor_at_ingrambarge.com
 
CONFIDENTIALITY  NOTICE: This  e-mail and any attachments are confidential and may also be privileged. If you  are not the named recipient, please notify the sender immediately and delete  the contents of this message without disclosing the contents to anyone, using  them for any purpose, or storing or copying the information on any  medium.

--
http://www.freelists.org/webpage/oracle-l