Re: informix restore

I did a cold restore and worked as a charm. Thank you so much. When I restore just a dbspace you are saying that I need to restore the logical logs as well. One more question: Let say that the last backup ontape -s and ontape -a was done last night at midnight. Now I need to restore just a dbspace that is having problems. Where can I find the latest logs ? Do I need to do a ontape -a before I do the partial restore ? Using the last night's logs wouldn't help in this case right ? I actually believe that they cannot be used at all in this case, right ? Thanks a lot On 5/27/05, Martin Fuerderer <MARTINFU@de.ibm.com> wrote: > Hi, > > if I understood you correctly, then you did a so called "warm restore" > of this one dbspace ? I.e. the database server was still running with > all other dbspaces being OK ? > In that case you have to restore logical logs. The logical logs need > to be applied to this one restored dbspace to "let it catch up" with > the rest of the system, so that the whole system will be consistent > again. > Without logical log restore, the dbspace (only physically restored) > has the state of the time when the backup was done. But since the > system has moved on in the meantime (i.e. some work was done > in the other dbspaces), this physiaclly restored dbspace is not in > sync with the rest. Logical restore is needed to get it there. > > If you do not have logical logs backed up, then you are at a loss at > this point. In this case all you can do is restore the complete system > (i.e. a cold restore), so that everything gets to the same state and > thus will be in sync. Of course that means you will loose the work > done since the last backup (level-0 or level-1) that is restored. > If you want to recover such work also, you need to backup and keep > logical logs so that you can restore them ... > > The zipping and unzipping that you did with the backup sounds > about right. This should not be the problem. > > Regards, > Martin > -- > Martin Fuerderer > IBM Informix Development Munich, Germany > Information Management > > owner-informix-list@iiug.org wrote on 26.05.2005 19:33:22: > > onstat -d shows ) free space> > > > On 5/26/05, Gentian Hila <genti.tech@gmail.com> wrote: > > > I run a backup ontape -s which was saved to a file and then zipped it > > > through gzip and then unzipped it and restored through: > > > > > > ontape -r -D dbsdata> > > > > > but I didn't restore any logical logs ? Should I have restored them. > > > > > > Now dbsdata shows as Disabled in DBSPACES status I get a ND for > dbsdata > > > > > > How can I enable it ? > > > > sending to informix-list > > sending to informix-list

Gentian Hila <genti.tech@gmail.com> wrote in message news:<1117226286.96414c3e6f99f734ecd031182e0d86c5@teranews>... > I did a cold restore and worked as a charm. > > Thank you so much. > > When I restore just a dbspace you are saying that I need to restore > the logical logs as well. > One more question: > Let say that the last backup ontape -s and ontape -a was done last > night at midnight. Now I need to restore just a dbspace that is having > problems. Where can I find the latest logs ? If the latest 'ontape -a' was at midnight the log entries after midnight are all on the Logical Logs on disk. The restore process will read these log entries from disk. Ruediger Papke > Do I need to do a ontape -a before I do the partial restore ? > Using the last night's logs wouldn't help in this case right ? I > actually believe that they cannot be used at all in this case, right ? > > Thanks a lot > > On 5/27/05, Martin Fuerderer <MARTINFU@de.ibm.com> wrote: > > Hi, > > > > if I understood you correctly, then you did a so called "warm restore" > > of this one dbspace ? I.e. the database server was still running with > > all other dbspaces being OK ? > > In that case you have to restore logical logs. The logical logs need > > to be applied to this one restored dbspace to "let it catch up" with > > the rest of the system, so that the whole system will be consistent > > again. > > Without logical log restore, the dbspace (only physically restored) > > has the state of the time when the backup was done. But since the > > system has moved on in the meantime (i.e. some work was done > > in the other dbspaces), this physiaclly restored dbspace is not in > > sync with the rest. Logical restore is needed to get it there. > > > > If you do not have logical logs backed up, then you are at a loss at > > this point. In this case all you can do is restore the complete system > > (i.e. a cold restore), so that everything gets to the same state and > > thus will be in sync. Of course that means you will loose the work > > done since the last backup (level-0 or level-1) that is restored. > > If you want to recover such work also, you need to backup and keep > > logical logs so that you can restore them ... > > > > The zipping and unzipping that you did with the backup sounds > > about right. This should not be the problem. > > > > Regards, > > Martin > > -- > > Martin Fuerderer > > IBM Informix Development Munich, Germany > > Information Management > > > > owner-informix-list@iiug.org wrote on 26.05.2005 19:33:22: > > > onstat -d shows ) free space> > > > > > On 5/26/05, Gentian Hila <genti.tech@gmail.com> wrote: > > > > I run a backup ontape -s which was saved to a file and then zipped it > > > > through gzip and then unzipped it and restored through: > > > > > > > > ontape -r -D dbsdata> > > > > > > > but I didn't restore any logical logs ? Should I have restored them. > > > > > > > > Now dbsdata shows as Disabled in DBSPACES status I get a ND for > > dbsdata > > > > > > > > How can I enable it ? > > > > > > sending to informix-list > > > > > > sending to informix-list

It will read the entries from disk only if you back them up... When you do the restore with ontape -r you are prompted :- Do you want to back up the logs? (y/n) This then salvages the logs from on disk and puts them on tape. i.e. performs a 'log salvage'. Note you MUST put in a fresh tape for this backup. Check the manual at http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp