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
------=_NextPart_001_005D_01BE2517.3EBDBC50--
------=_NextPart_000_005C_01BE2517.3EBDBC50
|