dbTalk Databases Forums  

Question regarding restore of a full (but not "Whole-system") onbar backup

comp.databases.informix comp.databases.informix


Discuss Question regarding restore of a full (but not "Whole-system") onbar backup in the comp.databases.informix forum.



Reply
 
Thread Tools Display Modes
  #11  
Old   
Malc
 
Posts: n/a

Default Re: Question regarding restore of a full (but not "Whole-system")onbar backup - 11-10-2010 , 04:51 AM






On Nov 10, 10:32*am, Superboer <superbo... (AT) t-online (DOT) de> wrote:
Quote:
Hello Malc,

--> I know we can, using -w. I'm asking if the -f version allows the
same,
--> or can we only restore to the point where space 3 was backed up?
--> Simple as that.

No you can not. The onbar -b -w -L 0 does backup the content of your
logical logs too simular as an
ontape would do. So the restore can do a fast recovery after a
physical restore.

onbar -b -L 0 does not backup the content of your logs;
(believe me i have been there you need your trx log to restore which
means that you can not restore
to the point in time the archive starts. this you can only do with an
archive taken before and using trx logs.)
Ta. Shame the manuals and training material don't state this
explicitly. The impression from the training manual is that this is in
fact possible.

Quote:
You could try and tune a bit in *upping BAR_NB_XPORT_COUNT
make sure BAR_XFER_BUF_SIZE is 31 make a not if you change
BAR_XFER_BUF_SIZE because you may not be able to restore an older
archive taken with a different BAR_XFER_BUF_SIZE size.
BAR_NB_EXPORT_COUNT is 10, BUF_SIZE 31 already.

Reply With Quote
  #12  
Old   
Superboer
 
Posts: n/a

Default Re: Question regarding restore of a full (but not "Whole-system")onbar backup - 11-10-2010 , 04:58 AM






Hello Malc,

you could try

BAR_NB_EXPORT_COUNT 1000

means 31 MB extra claimed.

Superboer.


On 10 nov, 11:51, Malc <mal... (AT) googlemail (DOT) com> wrote:
Quote:
On Nov 10, 10:32*am, Superboer <superbo... (AT) t-online (DOT) de> wrote:



Hello Malc,

--> I know we can, using -w. I'm asking if the -f version allows the
same,
--> or can we only restore to the point where space 3 was backed up?
--> Simple as that.

No you can not. The onbar -b -w -L 0 does backup the content of your
logical logs too simular as an
ontape would do. So the restore can do a fast recovery after a
physical restore.

onbar -b -L 0 does not backup the content of your logs;
(believe me i have been there you need your trx log to restore which
means that you can not restore
to the point in time the archive starts. this you can only do with an
archive taken before and using trx logs.)

Ta. Shame the manuals and training material don't state this
explicitly. The impression from the training manual is that this is in
fact possible.



You could try and tune a bit in *upping BAR_NB_XPORT_COUNT
make sure BAR_XFER_BUF_SIZE is 31 make a not if you change
BAR_XFER_BUF_SIZE because you may not be able to restore an older
archive taken with a different BAR_XFER_BUF_SIZE size.

BAR_NB_EXPORT_COUNT is 10, BUF_SIZE 31 already.

Reply With Quote
  #13  
Old   
Martin Fuerderer
 
Posts: n/a

Default Re: Question regarding restore of a full (but not"Whole-system") onbar backup - 11-10-2010 , 09:31 AM



Hi,

The "Backup and Restore Guide" of IDS 10 () said
(just to pick one place):

---excerpt start----------------------
ON-Bar Backup Examples

The following sections contain examples of ON?Bar
syntax for backing up storage spaces.

Performing a Level-0 Backup of All Storage Spaces

To perform a standard, level-0 backup of all online
storage spaces and used logical logs, use one of
the following commands:
onbar -b
onbar -b -L 0

ON?Bar never backs up offline storage spaces,
temporary dbspaces, or temporary sbspaces.

Important:
Save your logical logs so that you can restore from
this backup.
---excerpt end----------------------

I think what you are missing is mentioned with the
keyword "Important" ... it may be for a reason ...

Regards, Martin
--
Martin Fuerderer
IBM Informix Development Munich, Germany
Information Management

IBM Deutschland Research & Development GmbH
Chairman of the Supervisory Board: Martin Jetter
Board of Management: Dirk Wittkopp
Corporate Seat: Boeblingen, Germany
Reg.-Gericht: Amtsgericht Stuttgart, HRB 243294

Quote:
On Nov 10, 10:32 am, Superboer <superbo... (AT) t-online (DOT) de> wrote:
Hello Malc,

--> I know we can, using -w. I'm asking if the -f version allows the
same,
--> or can we only restore to the point where space 3 was backed up?
--> Simple as that.

No you can not. The onbar -b -w -L 0 does backup the content of your
logical logs too simular as an
ontape would do. So the restore can do a fast recovery after a
physical restore.

onbar -b -L 0 does not backup the content of your logs;
(believe me i have been there you need your trx log to restore which
means that you can not restore
to the point in time the archive starts. this you can only do with an
archive taken before and using trx logs.)

Ta. Shame the manuals and training material don't state this
explicitly. The impression from the training manual is that this is in
fact possible.


You could try and tune a bit in upping BAR_NB_XPORT_COUNT
make sure BAR_XFER_BUF_SIZE is 31 make a not if you change
BAR_XFER_BUF_SIZE because you may not be able to restore an older
archive taken with a different BAR_XFER_BUF_SIZE size.

BAR_NB_EXPORT_COUNT is 10, BUF_SIZE 31 already.
_______________________________________________
Informix-list mailing list
Informix-list (AT) iiug (DOT) org
http://www.iiug.org/mailman/listinfo/informix-list

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.