raw device and "backup and recovery"
510293Apr 6 2007 — edited May 24 2007Hi. all.
We are going to use raw device, but I am not familiar with this.
Could you give me some documents or html links for my studying?
Or, could you give me the answer about the following?
--------------------------------------------------------------------------------------
1. If I create a raw partiton with the size of 10 Giga bytes, and creae a data file
with the size of 2 Giga bytes, then the space of the empty 8 Giga bytes
is the waste of space?
That is becuase we can creae only one file to one raw partition. In addition,
It is not likely that the datafile grows beyond 2Giga bytes.
What do you think about this?
2. In case of 1, what about the backup issue?
Can I backup only the 2 Giga datafile , or must I backup the whole raw partition(10 Giga)?
3. In case of 2, what about the restore issue?
Can I restore only the 2 Giga datafile, or I must control the whole raw partition as one unit?
4. After I create a raw partition and a datafile in it, can I devide the raw partition which already contain a datafile in order to allocate another datafile?
--------------------------------------------------------------------------------------
A hardware vendor working with me suggests "1 Tera disk arrays with raid 0+1" that have 18 raw partition from 200 Mega to 10 Giga in size.
I think the expected total db size does not go over "5 Giga" in near few years(2 or 3 years, maybe).
So, what happen to the extra 955 Giga??
Can I use this space for other purpose later even when every raw partition has its own datafile?
Thanks in advance. I wil be waiting for your advice.
Have a good day.
Best Regards.
Message was edited by:
user507290