RE: RMAN Backup Question

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Daiminger, Helmut Sent: Monday, January 24, 2005 9:46 AM
To: oracle-l_at_freelists.org
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

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