Backup & Restore confusion

Hi, I'm a bit confused about backup and restore using ontape. Why do I need to take a logical log backup with ontape -a (log # 15) after a ontape -s -L 0? The full Level 0 archive says it contains the log # 15but during restore I have to apply the logical backup also containing the log # 15!?!? If I do not apply it the dbspace is partial restored and the database is not accessable. I have to run ontape -r -D <dbspace> and include the logical log : informix# ontape -s -L 0 Please mount tape 1 on /opt/informix/data/backup_device and press Return to continue ... 100 percent done. Please label this tape as number 1 in the arc tape sequence. This tape contains the following logical logs: 15 Program over. informix # ontape -a Performing automatic backup of logical logs. Please mount tape 1 on /opt/informix/data/log_backup_device and press Return to continue ... Do you want to back up the current logical log? (y/n) y Please label this tape as number 1 in the log tape sequence. This tape contains the following logical logs: 15 Program over. -POW

On Mar 5, 7:48 pm, faber...@yahoo.no wrote: > Hi, > > I'm a bit confused about backup and restore using ontape. Why do I > need to take a logical log backup with ontape -a (log # 15) after a > ontape -s -L 0? The full Level 0 archive says it contains the log # 15> but during restore I have to apply the logical backup also containing > the log # 15!?!? If I do not apply it the dbspace is partial restored > and the database is not accessable. I have to run ontape -r -D > <dbspace> and include the logical log : > > informix# ontape -s -L 0> > Please mount tape 1 on /opt/informix/data/backup_device and press > Return to continue ... > 100 percent done. > > Please label this tape as number 1 in the arc tape sequence. > This tape contains the following logical logs: > >  15 > > Program over. > informix # ontape -a > > Performing automatic backup of logical logs. > > Please mount tape 1 on /opt/informix/data/log_backup_device and press > Return to continue ... > > Do you want to back up the current logical log? (y/n) y > > Please label this tape as number 1 in the log tape sequence. > > This tape contains the following logical logs: >     15 > > Program over. > > -POW Well, the level 0 archive contains SOME of the logical log 15. So, you could just restore to the archive checkpoint taken at the beginning of the level 0 archive, by saying "N" when you get to "Do you want to restore logical logs?" If you want to restore to the end of logical log 15, then you can say "Y" to "Do you want to restore logical logs?" then it will go to the end of logical log 15. (Log 15 sounds like a "new" instance, presumably a test instance?)

Execute form console: $ ontape -- bye -----Mensaje original----- De: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] En nombre de TheBigPotatoe@Nothere.Co.Uk Enviado el: Jueves, 05 de Marzo de 2009 3:15 p.m. Para: informix-list@iiug.org Asunto: Re: Backup & Restore confusion On Mar 5, 7:48 pm, faber...@yahoo.no wrote: > Hi, > > I'm a bit confused about backup and restore using ontape. Why do I > need to take a logical log backup with ontape -a (log # 15) after a > ontape -s -L 0? The full Level 0 archive says it contains the log # 15 > but during restore I have to apply the logical backup also containing > the log # 15!?!? If I do not apply it the dbspace is partial restored > and the database is not accessable. I have to run ontape -r -D > <dbspace> and include the logical log : > > informix# ontape -s -L 0 > > Please mount tape 1 on /opt/informix/data/backup_device and press > Return to continue ... > 100 percent done. > > Please label this tape as number 1 in the arc tape sequence. > This tape contains the following logical logs: > > 15 > > Program over. > informix # ontape -a > > Performing automatic backup of logical logs. > > Please mount tape 1 on /opt/informix/data/log_backup_device and press > Return to continue ... > > Do you want to back up the current logical log? (y/n) y > > Please label this tape as number 1 in the log tape sequence. > > This tape contains the following logical logs: > 15 > > Program over. > > -POW Well, the level 0 archive contains SOME of the logical log 15. So, you could just restore to the archive checkpoint taken at the beginning of the level 0 archive, by saying "N" when you get to "Do you want to restore logical logs?" If you want to restore to the end of logical log 15, then you can say "Y" to "Do you want to restore logical logs?" then it will go to the end of logical log 15. (Log 15 sounds like a "new" instance, presumably a test instance?) _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list

> -----Original Message----- > From: informix-list-bounces@iiug.org [mailto:informix-list- > bounces@iiug.org] On Behalf Of TheBigPotatoe@Nothere.Co.Uk > Sent: Thursday, March 05, 2009 2:15 PM > To: informix-list@iiug.org > Subject: Re: Backup & Restore confusion > > On Mar 5, 7:48 pm, faber...@yahoo.no wrote: > > Hi, > > > > I'm a bit confused about backup and restore using ontape. Why do I > > need to take a logical log backup with ontape -a (log # 15) after a > > ontape -s -L 0? The full Level 0 archive says it contains the log # 15> > but during restore I have to apply the logical backup also containing > > the log # 15!?!? If I do not apply it the dbspace is partial restored > > and the database is not accessable. I have to run ontape -r -D > > <dbspace> and include the logical log : > > > > informix# ontape -s -L 0> > > > Please mount tape 1 on /opt/informix/data/backup_device and press > > Return to continue ... > > 100 percent done. > > > > Please label this tape as number 1 in the arc tape sequence. > > This tape contains the following logical logs: > > > >  15 > > > > Program over. > > informix # ontape -a > > > > Performing automatic backup of logical logs. > > > > Please mount tape 1 on /opt/informix/data/log_backup_device and press > > Return to continue ... > > > > Do you want to back up the current logical log? (y/n) y > > > > Please label this tape as number 1 in the log tape sequence. > > > > This tape contains the following logical logs: > >     15 > > > > Program over. > > > > -POW > > Well, the level 0 archive contains SOME of the logical log 15. > > So, you could just restore to the archive checkpoint taken at the > beginning of the level 0 archive, by saying "N" when you get to "Do > you want to restore logical logs?" > > If you want to restore to the end of logical log 15, then you can say > "Y" to "Do you want to restore logical logs?" then it will go to the > end of logical log 15. > > (Log 15 sounds like a "new" instance, presumably a test instance?) If the spaces you're restoring don't include whichever dbspace contains your logs, it will most likely force you to restore log tapes. If this is a test instance, why not leave the -D off and restore all of the dbspaces? That would leave the server consistent ready for an onmode -m to bring it online. --EEM > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list

On 5 Mar, 21:15, TheBigPota...@Nothere.Co.Uk wrote: > On Mar 5, 7:48 pm, faber...@yahoo.no wrote: > > > > > > > Hi, > > > I'm a bit confused about backup and restore using ontape. Why do I > > need to take a logical log backup with ontape -a (log # 15) after a > > ontape -s -L 0? The full Level 0 archive says it contains the log # 15> > but during restore I have to apply the logical backup also containing > > the log # 15!?!? If I do not apply it the dbspace is partial restored > > and the database is not accessable. I have to run ontape -r -D > > <dbspace> and include the logical log : > > > informix# ontape -s -L 0> > > Please mount tape 1 on /opt/informix/data/backup_device and press > > Return to continue ... > > 100 percent done. > > > Please label this tape as number 1 in the arc tape sequence. > > This tape contains the following logical logs: > > >  15 > > > Program over. > > informix # ontape -a > > > Performing automatic backup of logical logs. > > > Please mount tape 1 on /opt/informix/data/log_backup_device and press > > Return to continue ... > > > Do you want to back up the current logical log? (y/n) y > > > Please label this tape as number 1 in the log tape sequence. > > > This tape contains the following logical logs: > >     15 > > > Program over. > > > -POW > > Well, the level 0 archive contains SOME of the logical log 15. > > So, you could just restore to the archive checkpoint taken at the > beginning of the level 0 archive, by saying "N" when you get to "Do > you want to restore logical logs?" > > If you want to restore to the end of logical log 15, then you can say > "Y" to "Do you want to restore logical logs?" then it will go to the > end of logical log 15. > > (Log 15 sounds like a "new" instance, presumably a test instance?)– Skjul sitert tekst – > > – Vis sitert tekst – Thanks for the answer, but still a bit confused. I ran a scenario where I droped a table and restrored it: create table ... ontape -s -L 0 ontape -a drop table ... ontape -r -D stores_demo including answering restoring logical tapes. In this scenario I had to add the logical tapes (log # 15) during restore or else the dbspace was in partial status and the database not accessable. I belive I can live with this even if I would felt much better understand this even more). So, I should always follow a Level 0 backup with a ontape -a to bring the dbspace online during restore? I'm also a bit confused with level 1 and 2. I have read the dokumentation, but this is still not quit clear for me. I'm have worked mainly with Sybase ASE (besides Informix, Oracle for 2 years and a little MSSQL some years ago) where I use for backing up 'dump database' and 'dump transaction' and for restore 'load database' and 'load transaction'. Am I right if I say that level 1 and 2 backups/ archive can be compared to Sybase dump TRAN (incremental backup. Changes since the latest dum DATABASE/full backup)? If so, what is then logical log backups (ontape -a)? Hmmmm ....

OK, the level zero archive contains the last logical log as of the moment that the archive started. When you restore you want to restore to the moment of a crash (or at least as close as the last archived logical log) so you have to restore logical logs starting with the last log that was active at the time of the archive so you can pick up activity since the backup was taken. So you always have to backup your logical logs so you can restore the server state to as close to the crash as possible. Now, if there was a problem in the logical logs, like someone dropped an important table 5 minutes after the archive, then obviously you don't want to restore the logical logs. In that case you CAN restore ONLY the archive and not the logs or you can restore the logs up to a point but not beyond that. The trick to getting the server to work after such a partial restore is to complete the server's logical recovery before you shutdown the engine. To do that you have to bring the engine to full online mode with onmode -m and wait for the onstat - header line or the message log (onstat -m) to report that the engine is On-Line before shutting down. That final recovery will mark all of the chunks and dbspaces as online. If you shutdown without completing recovery the engine will not start because the chunks and dbspaces will be marked as inconsistent on the reserved pages on disk. It is possible to bring the engine online after such a gaff - IBM has a tool to do it as do I - but that would be a last resort patch because any partial transactions still open at the time that the archive was started will not have been rolled back and so the databases may be inconsistent internally. Better to do it right the first time or just run the restore again and do it right the second time. Art On 3/5/09, faber_38@yahoo.no <faber_38@yahoo.no> wrote: > Hi, > > I'm a bit confused about backup and restore using ontape. Why do I > need to take a logical log backup with ontape -a (log # 15) after a > ontape -s -L 0? The full Level 0 archive says it contains the log # 15> but during restore I have to apply the logical backup also containing > the log # 15!?!? If I do not apply it the dbspace is partial restored > and the database is not accessable. I have to run ontape -r -D > <dbspace> and include the logical log : > > informix# ontape -s -L 0> > Please mount tape 1 on /opt/informix/data/backup_device and press > Return to continue ... > 100 percent done. > > Please label this tape as number 1 in the arc tape sequence. > This tape contains the following logical logs: > > 15 > > Program over. > informix # ontape -a > > Performing automatic backup of logical logs. > > Please mount tape 1 on /opt/informix/data/log_backup_device and press > Return to continue ... > > > Do you want to back up the current logical log? (y/n) y > > Please label this tape as number 1 in the log tape sequence. > > This tape contains the following logical logs: > 15 > > Program over. > > -POW > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > -- Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.

On 5 Mar, 21:45, "Everett Mills" <Everett.Mi...@nationalbeef.com> wrote: > > -----Original Message----- > > From: informix-list-boun...@iiug.org [mailto:informix-list- > > boun...@iiug.org] On Behalf Of TheBigPota...@Nothere.Co.Uk > > Sent: Thursday, March 05, 2009 2:15 PM > > To: informix-l...@iiug.org > > Subject: Re: Backup & Restore confusion > > > On Mar 5, 7:48 pm, faber...@yahoo.no wrote: > > > Hi, > > > > I'm a bit confused about backup and restore using ontape. Why do I > > > need to take a logical log backup with ontape -a (log # 15) after a > > > ontape -s -L 0? The full Level 0 archive says it contains the log # 15> > > but during restore I have to apply the logical backup also containing > > > the log # 15!?!? If I do not apply it the dbspace is partial restored > > > and the database is not accessable. I have to run ontape -r -D > > > <dbspace> and include the logical log : > > > > informix# ontape -s -L 0> > > > Please mount tape 1 on /opt/informix/data/backup_device and press > > > Return to continue ... > > > 100 percent done. > > > > Please label this tape as number 1 in the arc tape sequence. > > > This tape contains the following logical logs: > > > >  15 > > > > Program over. > > > informix # ontape -a > > > > Performing automatic backup of logical logs. > > > > Please mount tape 1 on /opt/informix/data/log_backup_device and press > > > Return to continue ... > > > > Do you want to back up the current logical log? (y/n) y > > > > Please label this tape as number 1 in the log tape sequence. > > > > This tape contains the following logical logs: > > >     15 > > > > Program over. > > > > -POW > > > Well, the level 0 archive contains SOME of the logical log 15. > > > So, you could just restore to the archive checkpoint taken at the > > beginning of the level 0 archive, by saying "N" when you get to "Do > > you want to restore logical logs?" > > > If you want to restore to the end of logical log 15, then you can say > > "Y" to "Do you want to restore logical logs?" then it will go to the > > end of logical log 15. > > > (Log 15 sounds like a "new" instance, presumably a test instance?) > > If the spaces you're restoring don't include whichever dbspace contains your logs, it will most likely force you to restore log tapes.  If this is a test instance, why not leave the -D off and restore all of the dbspaces?  That would leave the server consistent ready for an onmode -m to bring it online. > >                 --EEM > > > > > _______________________________________________ > > Informix-list mailing list > > Informix-l...@iiug.org > >http://www.iiug.org/mailman/listinfo/informix-list– Skjul sitert tekst – > > – Vis sitert tekst –– Skjul sitert tekst – > > – Vis sitert tekst – Hi EEM! The reason for posting this subject/question is that we want (for several reasons) to go away from using onbar togheter with Veritas Netbackup. This was set up by a consulting firm several years ago and has been ticking away without any problems and no need to restore. Now the servers have been replaced with new ones and we have to deside to either go the onbar/veritas road or ontape which I belive we could use and be more confident using. The thing is that we run Oracle, Informix, Sybase, MSSQL, MySQL where Oracle stands for 90% of the total db's. I have to come up with a resonable and simple (and cheap) backup and restore plan that satisfy both SLA demands and that we dba's (hmmm ... that would be me:-) ) could handle with manually routines documented. Thanks! PO

> -----Original Message----- > From: informix-list-bounces@iiug.org [mailto:informix-list- > bounces@iiug.org] On Behalf Of faber_38@yahoo.no > Sent: Thursday, March 05, 2009 3:20 PM > To: informix-list@iiug.org > Subject: Re: Backup & Restore confusion > > On 5 Mar, 21:45, "Everett Mills" <Everett.Mi...@nationalbeef.com> > wrote: > > > -----Original Message----- > > > From: informix-list-boun...@iiug.org [mailto:informix-list- > > > boun...@iiug.org] On Behalf Of TheBigPota...@Nothere.Co.Uk > > > Sent: Thursday, March 05, 2009 2:15 PM > > > To: informix-l...@iiug.org > > > Subject: Re: Backup & Restore confusion > > > > > On Mar 5, 7:48 pm, faber...@yahoo.no wrote: > > > > Hi, > > > > > > I'm a bit confused about backup and restore using ontape. Why do I > > > > need to take a logical log backup with ontape -a (log # 15) after a > > > > ontape -s -L 0? The full Level 0 archive says it contains the log #> 15 > > > > but during restore I have to apply the logical backup also > containing > > > > the log # 15!?!? If I do not apply it the dbspace is partial > restored > > > > and the database is not accessable. I have to run ontape -r -D > > > > <dbspace> and include the logical log : > > > > > > informix# ontape -s -L 0> > > > > > Please mount tape 1 on /opt/informix/data/backup_device and press > > > > Return to continue ... > > > > 100 percent done. > > > > > > Please label this tape as number 1 in the arc tape sequence. > > > > This tape contains the following logical logs: > > > > > >  15 > > > > > > Program over. > > > > informix # ontape -a > > > > > > Performing automatic backup of logical logs. > > > > > > Please mount tape 1 on /opt/informix/data/log_backup_device and > press > > > > Return to continue ... > > > > > > Do you want to back up the current logical log? (y/n) y > > > > > > Please label this tape as number 1 in the log tape sequence. > > > > > > This tape contains the following logical logs: > > > >     15 > > > > > > Program over. > > > > > > -POW > > > > > Well, the level 0 archive contains SOME of the logical log 15. > > > > > So, you could just restore to the archive checkpoint taken at the > > > beginning of the level 0 archive, by saying "N" when you get to "Do > > > you want to restore logical logs?" > > > > > If you want to restore to the end of logical log 15, then you can say > > > "Y" to "Do you want to restore logical logs?" then it will go to the > > > end of logical log 15. > > > > > (Log 15 sounds like a "new" instance, presumably a test instance?) > > > > If the spaces you're restoring don't include whichever dbspace contains > your logs, it will most likely force you to restore log tapes.  If this is > a test instance, why not leave the -D off and restore all of the dbspaces? >  That would leave the server consistent ready for an onmode -m to bring it > online. > > > >                 --EEM > > > > > > > > > _______________________________________________ > > > Informix-list mailing list > > > Informix-l...@iiug.org > > >http://www.iiug.org/mailman/listinfo/informix-list- Skjul sitert tekst > - > > > > - Vis sitert tekst -- Skjul sitert tekst - > > > > - Vis sitert tekst - > > Hi EEM! > > The reason for posting this subject/question is that we want (for > several reasons) to go away from using onbar togheter with Veritas > Netbackup. This was set up by a consulting firm several years ago and > has been ticking away without any problems and no need to restore. Now > the servers have been replaced with new ones and we have to deside to > either go the onbar/veritas road or ontape which I belive we could use > and be more confident using. The thing is that we run Oracle, > Informix, Sybase, MSSQL, MySQL where Oracle stands for 90% of the > total db's. I have to come up with a resonable and simple (and cheap) > backup and restore plan that satisfy both SLA demands and that we > dba's (hmmm ... that would be me:-) ) could handle with manually > routines documented. > Judging from what I read in a different post, you wanted to test recovering a single table. If so, maybe you need to try archecker instead of ontape -r -D. It can, if I remember correctly, recover a single table without requiring a whole dbspace to be restored. I think that feature is undocumented, though. You can Google search the comp.databases.informix group to find out more. --EEM > Thanks! > > PO > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list

On 5 Mar, 22:39, "Everett Mills" <Everett.Mi...@nationalbeef.com> wrote: > > -----Original Message----- > > From: informix-list-boun...@iiug.org [mailto:informix-list- > > boun...@iiug.org] On Behalf Of faber...@yahoo.no > > Sent: Thursday, March 05, 2009 3:20 PM > > To: informix-l...@iiug.org > > Subject: Re: Backup & Restore confusion > > > On 5 Mar, 21:45, "Everett Mills" <Everett.Mi...@nationalbeef.com> > > wrote: > > > > -----Original Message----- > > > > From: informix-list-boun...@iiug.org [mailto:informix-list- > > > > boun...@iiug.org] On Behalf Of TheBigPota...@Nothere.Co.Uk > > > > Sent: Thursday, March 05, 2009 2:15 PM > > > > To: informix-l...@iiug.org > > > > Subject: Re: Backup & Restore confusion > > > > > On Mar 5, 7:48 pm, faber...@yahoo.no wrote: > > > > > Hi, > > > > > > I'm a bit confused about backup and restore using ontape. Why do I > > > > > need to take a logical log backup with ontape -a (log # 15) after a > > > > > ontape -s -L 0? The full Level 0 archive says it contains the log #> > 15 > > > > > but during restore I have to apply the logical backup also > > containing > > > > > the log # 15!?!? If I do not apply it the dbspace is partial > > restored > > > > > and the database is not accessable. I have to run ontape -r -D > > > > > <dbspace> and include the logical log : > > > > > > informix# ontape -s -L 0> > > > > > Please mount tape 1 on /opt/informix/data/backup_device and press > > > > > Return to continue ... > > > > > 100 percent done. > > > > > > Please label this tape as number 1 in the arc tape sequence. > > > > > This tape contains the following logical logs: > > > > > >  15 > > > > > > Program over. > > > > > informix # ontape -a > > > > > > Performing automatic backup of logical logs. > > > > > > Please mount tape 1 on /opt/informix/data/log_backup_device and > > press > > > > > Return to continue ... > > > > > > Do you want to back up the current logical log? (y/n) y > > > > > > Please label this tape as number 1 in the log tape sequence. > > > > > > This tape contains the following logical logs: > > > > >     15 > > > > > > Program over. > > > > > > -POW > > > > > Well, the level 0 archive contains SOME of the logical log 15. > > > > > So, you could just restore to the archive checkpoint taken at the > > > > beginning of the level 0 archive, by saying "N" when you get to "Do > > > > you want to restore logical logs?" > > > > > If you want to restore to the end of logical log 15, then you can say > > > > "Y" to "Do you want to restore logical logs?" then it will go to the > > > > end of logical log 15. > > > > > (Log 15 sounds like a "new" instance, presumably a test instance?) > > > > If the spaces you're restoring don't include whichever dbspace contains > > your logs, it will most likely force you to restore log tapes.  If this is > > a test instance, why not leave the -D off and restore all of the dbspaces? > >  That would leave the server consistent ready for an onmode -m to bring it > > online. > > > >                 --EEM > > > > > _______________________________________________ > > > > Informix-list mailing list > > > > Informix-l...@iiug.org > > > >http://www.iiug.org/mailman/listinfo/informix-list-Skjul sitert tekst > > - > > > > - Vis sitert tekst -- Skjul sitert tekst - > > > > - Vis sitert tekst - > > > Hi EEM! > > > The reason for posting this subject/question is that we want (for > > several reasons) to go away from using onbar togheter with Veritas > > Netbackup. This was set up by a consulting firm several years ago and > > has been ticking away without any problems and no need to restore. Now > > the servers have been replaced with new ones and we have to deside to > > either go the onbar/veritas road or ontape which I belive we could use > > and be more confident using. The thing is that we run Oracle, > > Informix, Sybase, MSSQL, MySQL where Oracle stands for 90% of the > > total db's. I have to come up with a resonable and simple (and cheap) > > backup and restore plan that satisfy both SLA demands and that we > > dba's (hmmm ... that would be me:-) ) could handle with manually > > routines documented. > > Judging from what I read in a different post, you wanted to test recovering a single table.  If so, maybe you need to try archecker instead of ontape -r -D.  It can, if I remember correctly, recover a single table without requiring a whole dbspace to be restored.  I think that feature is undocumented, though.  You can Google search the comp.databases.informix group to find out more. > >                 --EEM > > > > > Thanks! > > > PO > > _______________________________________________ > > Informix-list mailing list > > Informix-l...@iiug.org > >http://www.iiug.org/mailman/listinfo/informix-list– Skjul sitert tekst – > > – Vis sitert tekst –– Skjul sitert tekst – > > – Vis sitert tekst – Hi again Everett! The missing/droped table was just one simple scenario I ran to try to understand how ontape works. Of course there is almost countless things that can trigger the need to restore. I probebly need to take the time that is needed to understand this better. Thanks! -PO

> -----Original Message----- > From: informix-list-bounces@iiug.org [mailto:informix-list- > bounces@iiug.org] On Behalf Of faber_38@yahoo.no > Sent: Thursday, March 05, 2009 4:00 PM > To: informix-list@iiug.org > Subject: Re: Backup & Restore confusion > > On 5 Mar, 22:39, "Everett Mills" <Everett.Mi...@nationalbeef.com> > wrote: > > > -----Original Message----- > > > From: informix-list-boun...@iiug.org [mailto:informix-list- > > > boun...@iiug.org] On Behalf Of faber...@yahoo.no > > > Sent: Thursday, March 05, 2009 3:20 PM > > > To: informix-l...@iiug.org > > > Subject: Re: Backup & Restore confusion > > > > > On 5 Mar, 21:45, "Everett Mills" <Everett.Mi...@nationalbeef.com> > > > wrote: > > > > > -----Original Message----- > > > > > From: informix-list-boun...@iiug.org [mailto:informix-list- > > > > > boun...@iiug.org] On Behalf Of TheBigPota...@Nothere.Co.Uk > > > > > Sent: Thursday, March 05, 2009 2:15 PM > > > > > To: informix-l...@iiug.org > > > > > Subject: Re: Backup & Restore confusion > > > > > > > On Mar 5, 7:48 pm, faber...@yahoo.no wrote: > > > > > > Hi, > > > > > > > > I'm a bit confused about backup and restore using ontape. Why do > I > > > > > > need to take a logical log backup with ontape -a (log # 15) > after a > > > > > > ontape -s -L 0? The full Level 0 archive says it contains the > log #> > > 15 > > > > > > but during restore I have to apply the logical backup also > > > containing > > > > > > the log # 15!?!? If I do not apply it the dbspace is partial > > > restored > > > > > > and the database is not accessable. I have to run ontape -r -D > > > > > > <dbspace> and include the logical log : > > > > > > > > informix# ontape -s -L 0> > > > > > > > Please mount tape 1 on /opt/informix/data/backup_device and > press > > > > > > Return to continue ... > > > > > > 100 percent done. > > > > > > > > Please label this tape as number 1 in the arc tape sequence. > > > > > > This tape contains the following logical logs: > > > > > > > >  15 > > > > > > > > Program over. > > > > > > informix # ontape -a > > > > > > > > Performing automatic backup of logical logs. > > > > > > > > Please mount tape 1 on /opt/informix/data/log_backup_device and > > > press > > > > > > Return to continue ... > > > > > > > > Do you want to back up the current logical log? (y/n) y > > > > > > > > Please label this tape as number 1 in the log tape sequence. > > > > > > > > This tape contains the following logical logs: > > > > > >     15 > > > > > > > > Program over. > > > > > > > > -POW > > > > > > > Well, the level 0 archive contains SOME of the logical log 15. > > > > > > > So, you could just restore to the archive checkpoint taken at the > > > > > beginning of the level 0 archive, by saying "N" when you get to > "Do > > > > > you want to restore logical logs?" > > > > > > > If you want to restore to the end of logical log 15, then you can > say > > > > > "Y" to "Do you want to restore logical logs?" then it will go to > the > > > > > end of logical log 15. > > > > > > > (Log 15 sounds like a "new" instance, presumably a test instance?) > > > > > > If the spaces you're restoring don't include whichever dbspace > contains > > > your logs, it will most likely force you to restore log tapes.  If > this is > > > a test instance, why not leave the -D off and restore all of the > dbspaces? > > >  That would leave the server consistent ready for an onmode -m to > bring it > > > online. > > > > > >                 --EEM > > > > > > > _______________________________________________ > > > > > Informix-list mailing list > > > > > Informix-l...@iiug.org > > > > >http://www.iiug.org/mailman/listinfo/informix-list-Skjul sitert > tekst > > > - > > > > > > - Vis sitert tekst -- Skjul sitert tekst - > > > > > > - Vis sitert tekst - > > > > > Hi EEM! > > > > > The reason for posting this subject/question is that we want (for > > > several reasons) to go away from using onbar togheter with Veritas > > > Netbackup. This was set up by a consulting firm several years ago and > > > has been ticking away without any problems and no need to restore. Now > > > the servers have been replaced with new ones and we have to deside to > > > either go the onbar/veritas road or ontape which I belive we could use > > > and be more confident using. The thing is that we run Oracle, > > > Informix, Sybase, MSSQL, MySQL where Oracle stands for 90% of the > > > total db's. I have to come up with a resonable and simple (and cheap) > > > backup and restore plan that satisfy both SLA demands and that we > > > dba's (hmmm ... that would be me:-) ) could handle with manually > > > routines documented. > > > > Judging from what I read in a different post, you wanted to test > recovering a single table.  If so, maybe you need to try archecker instead > of ontape -r -D.  It can, if I remember correctly, recover a single table > without requiring a whole dbspace to be restored.  I think that feature is > undocumented, though.  You can Google search the comp.databases.informix > group to find out more. > > > >                 --EEM > > > > > > > > > Thanks! > > > > > PO > > > _______________________________________________ > > > Informix-list mailing list > > > Informix-l...@iiug.org > > >http://www.iiug.org/mailman/listinfo/informix-list- Skjul sitert tekst > - > > > > - Vis sitert tekst -- Skjul sitert tekst - > > > > - Vis sitert tekst - > > Hi again Everett! > > The missing/droped table was just one simple scenario I ran to try to > understand how ontape works. Of course there is almost countless > things that can trigger the need to restore. I probebly need to take > the time that is needed to understand this better. > > Thanks! Ok then, best advice: Read the Backup and Restore Guide --EEM > > -PO > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list