RE: RMAN Confusion (Duplicate to past point in time)
- From: "Taylor, Chris David" <Chris.Taylor@xxxxxxxxxxxxxxx>
- To: <TESTAJ3@xxxxxxxxxxxxxx>
- Date: Mon, 11 May 2009 14:38:25 -0500
I'm using the repository and I would think they probably are expired.
(I had to restore the backups from tape)
Chris Taylor
Sr. Oracle DBA
Ingram Barge Company
Nashville, TN 37205
Office: 615-517-3355
Cell: 615-354-4799
Email: chris.taylor@xxxxxxxxxxxxxxx
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: TESTAJ3@xxxxxxxxxxxxxx [mailto:TESTAJ3@xxxxxxxxxxxxxx]
Sent: Monday, May 11, 2009 2:37 PM
To: Taylor, Chris David
Cc: Oracle Discussion List; oracle-l-bounce@xxxxxxxxxxxxx
Subject: Re: RMAN Confusion (Duplicate to past point in time)
repository or control file for backup metadata?
if repository, you've done the crosscheck backup and verify they are not
expired?
just some rambling thoughts.
joe
_______________________________________
Joe Testa, Oracle Certified Professional
Senior Consultant
Data Engineering and Administration
Nationwide Investments
(Work) 614-677-1668
(Cell) 614-312-6715
Interested in helping out your marriage?
Ask me about "Weekend to Remember"
Dec 11-13, 2009 here in Columbus.
From: "Taylor, Chris David" <Chris.Taylor@xxxxxxxxxxxxxxx>
To: "Oracle Discussion List" <ORACLE-L@xxxxxxxxxxxxx>
Date: 05/11/2009 03:35 PM
Subject: RMAN Confusion (Duplicate to past point in time)
Sent by: oracle-l-bounce@xxxxxxxxxxxxx
________________________________
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@xxxxxxxxxxxxxxx
<mailto:chris.taylor@xxxxxxxxxxxxxxx>
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.
Other related posts:
