Skip to Content
0
Former Member
Jul 21, 2008 at 04:52 PM

Online backups on BIW systems, every update is logged?

40 Views

Some years ago I was at an SAP BIW installation, they performed Oracle online backups dayly.

For some reason, they had to restore and recover DB, and after using an online backup as a restore basis, some indexes were not usable, because they had been updated without archive log information.

Finally, the easiest way for the system administator was using an offline backup.

I got to know there were some updates (not critical) not being logged in the DB, so online backups, as well as standby DB would not be as useful as on OLTP systems.

Does somebody know if this is or this is not the same nowadays? Is everything logged on a BW system? Is that a tunable configuration for some indexes? Is an online backup really useful after restoring and recovering?

Thanks very much for your experience and answers !!

Eva