David,
An offline backup consisits the archived redo logs unless you choose
not to backup them (using the 'archivelog=none' in the EBU script). EBU
backs up the archived redo logs during both online and offline backups.
EBU identifies the archive redo logs by quering the target DB for
the current LOG_ARCHIVE_DEST location specified in initSID.ora.
Did you use the recover option with the EBU script ? the recover perform
a recover of the DB after the DB restore.
--
Regards
Malkit Hayun , UDI
Application Engineer
Office:972-3-9233440
Fax: 972-3-9233441
Mobile:972-52-834575
Email: malkit AT udi.co DOT il
----------------------------------------
David C. Greig wrote:
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.2Oracle
v7.3.3EBU
2.2.0.5ADSMConnect
Agent 2.1.0.7ADSM
Server 3.1.2.0Thanks,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
--------------FB6E882A67EC5AA7B45FB085--
=========================================================================
|