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

Hi Listers,

We don't have the option of seperating the two systems into it's own
instance or into it's own database. They will be consolidated into one
database and one Informix instance. Although they will coexist in the same
database, the data for GL reside in its own tables, hence, I can seperate
them to a different dbspace that the Core system. However, it won't make
sense to do that if I won't be able to restore that dbspace to a point in
time, earlier that the Core system dbspace and not have to apply the logical
logs to synchronize the dbspaces. I'd appreciate some confirmation of the
onbar dbspace backup and restore concepts that I have described. I'm not
sure if that is how it actually works. Hopefully some of you have visited
these crossroads before and might be able to provide some insight on how you
proceeded.
Some alternatives or workarounds may exist.
Please let me know if you need further clarifications.

Thanks,

Denmark W.

Quote:
----- Original Message -----



Sent: Wednesday, December 06, 2000 3:24 PM
Subject: RE: onbar dbspace level restore problem ...

> We have been faced with a similar problem.  We have two vendor-supplied
> applications.  Each stores it data within its own database.
> However, both databases reside within the same Informix instance.

> We need the ability to restore one application's data without impacting
the
> other application.  So our solution is to move one of the applications
> to a separate Informix instance.  Will that solution work for you?

> Another approach is the point-in-time restore to a separate instance.
> Then you can transfer the affected tables to the original instance using
> export/import.  Personally, I find this approach too risky.  I would
rather
> stick with one set of Informix backup and restore utilities.

> I do understand that Informix is developing database and table level
> restore utilities.  After those utilities are released and tested,
> we may consider another approach.

> Rick

> -----Original Message-----

> Sent: Wednesday, December 06, 2000 11:10
> To: Informix Users Group
> Subject: 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.



Mon, 26 May 2003 22:49:20 GMT
 
 [ 1 post ] 

 Relevant Pages 

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

2. 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. FW: Level-0 restore

8. FW: Problem Creating a DBSpace

9. Informix OnBar archive level 1 problem

10. Problem with Onbar Level 0

11. Onbar Level 1,2 backup problem.

12. FW: FW: FW: FW: Explain (more is better?)


 
Powered by phpBB® Forum Software