Re: Expanding chunk sizes

Graham Bartlett wrote: > > I recently had to restore an Online v7 database after a disk failure. I > replaced the 2 gigabyte disk with a 4 gigabyte disk. The disk was split to > give two equal partitions of roughly 2 gigabytes to accomodate the 2 chunks > and then the database restored. > Looking at the status of the spaces I'm shown one of 1022364 pages and the that is cca 2 GB > other of 511692 pages. and this is cca 1 GB > What haven't I done ? Well, seems to me you during adding chunk you specified chunk size in kB, not in pages (1 page = 2 kb most often). > Will I run out of space when the 511692 pages are used even though there > are another 511000 pages available ? I do not know, what you mean by that. You will not be able to restore from level 0, because you have not the same chunks (size, maybe offset too ?) (If you already did restore (succesful :-) from level 0 to smaller chunk, let us know. They say it is not possible.) > Can I extend the chunk ? No, I think. You will have to drop the chunk and add it again with appropriate size and offset. Then restore from level 0 (and logs). If I was wrong, I hope smarter guys will correct me. Michal -- -------------------------------------------------------------- Michal Hajek mailto:hajek@nspuh.cz Sprava NIS http://www.nspuh.cz NsP Uherske Hradiste phone : voice +420 0632 529 204 Purkynova 365 fax +420 0632 551 014 686 68 Uherske Hradiste Czech Republic --------------------------------------------------------------