RE: RMAN Backup Question
- From: "Marquez, Chris" <CMarquez@xxxxxxxx>
- To: <HELMUT.DAIMINGER@xxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 24 Jan 2005 14:32:41 -0500
Helmut,
>>did a restore of our production database to a different box.
>>But RMAN was using an older backup to do that.
What type of contolfile backup are you using?
What is the date of the contolfile you restored to the "different box".
What method did you use to restore the backup contolfile to the
"different box".
I assume you are NOT using a RMAN catalog?
So what I'm suggesting is that the current contolfile you restored to
the "different box"
is younger that the "Thursday (Jan 20)" backup and there for is not
"aware" of it.
(With RMAN) The contolfile should be the last AND final object you
backup to insure=20
that it contains the meta database about ALL previous backups.
And old contolfile can NEVER "know" about a NEW RMAN backup.
hth
Chris Marquez
Oracle DBA
HEYMONitor(tm) - heymonitor.com
"Oracle Monitoring & Alerting Solution"
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Daiminger, Helmut
Sent: Monday, January 24, 2005 9:46 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: RMAN Backup Question
Hi!
We recently did a restore of our production database to a different box.
But RMAN was using an older backup to do that.
The scenario was like this:
PRD Database:
- full db backup + archive logs taken from 20:00 - 23:00 on Wednesday
(Jan 19)
- full db backup + archive logs taken from 20:00 - 23:00 on Thursday
(Jan 20)
On Friday (Jan 21), we then did a "restore until time" to Thursday (Jan
20), 20:30 to a different box.
But RMAN was not using the backup from Thursday (Jan 20), but was using
the one from Wednesday and applying all the archived logs (which was
taking a long time).
The question is: why was RMAN not using the backup from Thursday? Is the
backup not consistent to the starting time at 20:00 (like it would be
with a consistent export)?
I can't find anything in Robert Freeman's book about that phenomenon.
This is 9.2 on HP-UX 11i.
Thanks,
Helmut
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
