I have some concerns about restores using EBU from offline backups.  We're
running EBU and the ADSMConnect Agent to do offline backups of an Oracle
database.  In the EBU script, we're doing a "backup offline database".
However, it looks like, in the logs, that the online redologs are not being
backed up.  This is obviously a requirement of performing offline backups,
and I'm a little confused about this.

We've done some restore testing on this.  After an offline backup, we
removed both copies of the control and performed a restore and were able to
bring up the database.  We then remove several database files, including the
system tablespace, and performed a restore.  The database came up cleanly.
We left the database up for a while, then shut it down and ran another
restore.  When we tried to start it, we got an error about one of the
redologs being newer than the control file.  It appeared that EBU had not
restored the online redo's.

How are online redologs backed up via EBU?  This is particularly a concern
if we are doing complete restores from scratch.

Info:
AIX v4.2
Oracle v7.3.3
EBU 2.2.0.5
ADSMConnect Agent 2.1.0.7
ADSM Server 3.1.2.0

Thanks,
David


____________________________________________________
David C. Greig
IBM Certified Specialist - ADSM
Mainstar Software Corporation
Storage and Recovery Solutions
http://www.mainstar.com

PGP: http://dgreig.home.mindspring.com/pgp.html