onbar dbspace level restore problem ... 
Author Message
 onbar dbspace level restore problem ...

Hi Listers,

Please give me your comments and recommendations on the following
problem:
We are running IDS 7.30.UC3 on Solaris 7. The banking, client / server
application has data in informix tables and in VSAM (MFCobol) files on disk.
The application which will be integrated is now seperated into two main
parts:
The Core system and the GL system. The application uses some tasks and
processes called the Message Manager, that performs all requests from
clients.
The problem we have is with deciding what backup and restore strategy to use
since we need to have a seperate strategy for GL and for the Core system.
The bank runs a batch process each day for the Core system and another batch
process for the GL system at different times. The GL batch usually runs
first.
However, when the GL batch is running, transactions are being committed to
the core system as well.

I know I can put all tables related to GL in their own dbspace and use onbar
to backup the GL dbspace before the GL batch process runs.
However, I'm concerned that in the event I have to restore the GL system to
a point in time , usually to the point before the GL batch process started,
using the onbar level 0 backup of the GL dbspace, we might not be able to
restore to that specific point in time because of the following onbar
requirement.
Onbar requires that all logical logs created after the level 0 dbspace
backup must be applied before the dbspace is synchronized with the other
dbspaces.
This is a catch-22 isn't it? Wouldn't rolling forward the logical logs
restore the same things I don't want to apply? I know I can tell onbar to
restore to a specific point in time, but I don't know what logical logs
would be rolled forward in order to synchronize the newly restored dbspace.
I would appreciate some clarifications on this matter as it affects our
development and implementation efforts in releasing a new system.
I am a Sytem Admin/DBA at a financial institution in Belize.

Grateful for your help.
Regards,

Denmark W.



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Fw: onbar dbspace level restore problem ...

2. Fw: onbar dbspace level restore problem ...

3. onbar dbspace restore problem

4. onbar - restoring old dbspaces into a current system

5. Clarification on Level-1 ONBAR restore...

6. ONBAR Level 1 restore..............

7. Informix OnBar archive level 1 problem

8. Problem with Onbar Level 0

9. Onbar Level 1,2 backup problem.

10. Single Database Restore / Single DBSPACE RESTORE

11. Onbar Restore Error - Can't Restore Reserved Pages

12. Problems ontape restore of a single dbspace


 
Powered by phpBB® Forum Software