Re: Backup Issue

Howard Jones wrote: > Hello, > > OS = HPUX11 > IDS = 9.21.FC4 > > The nightly backup (onbar -b -L 0) on one of our supported systems is taking > in excess of 3 hours to complete. This is due to the user having archived > data (arcdbs ) within the live instance. The customer has recently asked if > there is any way to exclude the arcdbs dbspace from the nightly backup to > improve backup and recovery times....I have replayed saying this is not a > valid option(?) (I am pretty sure I am correct on this)....so the customer > has requested a further solution. > > What would your solutions be to this problem.....I was thinking of having a > separate database for the archived data within the live instance then back > it up once a month etc... or maybe have a completely separate instance to > accommodate the arcdbs. You could store the archive tables in a different database server instance, and leave synonyms in their place, which point to the new location. As you are using OnBar, you could backup different dbspaces at different times. I presume you are also backing up your logical logs. If you can locate your archive data in a different dbspace, you can backup that dbspace less frequently than your other dbspaces. You can also use incremental archive levels, which will only backup data that has changed since the previous backup. However, you will still need to archive everything at regular intervals. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /| | Mydas Solutions Ltd http://MydasSolutions.com |///// / //| | +-----------------------------------+//// / ///| | |We value your comments, which have |/// / ////| | |been recorded and automatically |// / /////| | |emailed back to us for our records.|/ ////////| +----------------------+-----------------------------------+-----------+ sending to informix-list