Re: backup and restore
You cannot restore individual dbspaces with ontape in the way that you are
attempting to do :o( This is a common question.
Informix considers the dbspace to be out of sync until you re-apply all
transactions made since the backup was taken by restoring from the logical
logs. The problem with this of course is that your drop database stmnt will
also be re-applied and you won't be able to achieve your objective. As far
as I'm aware non of the Informix backup programs, ontape, onarchive or onbar
allow you to restore individual dbspaces in the way that you describe.
Tony Flaherty
all mine
price wrote in message <8kgj6v$1rp@netnews.hinet.net>...
>I create a demo datebase on dbspace1 and I backup the IDS with ontape -s
>and ontape -a
>then I drop the demo datebase
>when I restore with ontape -r -D dbspace1 online
>I find the dbspace1 is down
>but I can not online the dbspace1 with onspaces -s dbspace1 -p PATH -o
>offset -O
>sorry about my bad skill??
>
>PS:where can I find more information about backup and restore (good with
>example)
>
>
>--
> Dimerco Data System Corp.
> Price Chen
>TEL : 886-2-25117233 ext 524
> FAX: 886-2-25117238
> Email : price@rs520.ddsc.com.tw
> 8th Fl, 57-1, Sec. 2,
> Chung Shan N. Rd.,
> Taipei, Taiwan, R.O.C.
>
>
>
>
>--
> Dimerco Data System Corp.
> ³¯¥Ã³¹ Price Chen
>TEL : 886-2-25117233 ext 524
> FAX: 886-2-25117238
> Email : price@rs520.ddsc.com.tw
> 8th Fl, 57-1, Sec. 2,
> Chung Shan N. Rd.,
> Taipei, Taiwan, R.O.C.
>
>
>