We just did a DB restore a couple of weeks ago. First we tried with the
same number of db volumes, but the volumes added up to less space than was
in the original volumes (we had lost a hard drive so we had less space in
our array). That failed because the amount of space was less than the
original, even though the db was only 50% full and didn't really need all
that space (confirmation of the comment that the RESTORE TO db needs to be
AT LEAST as big as the original). We then allocated an additional db volume
with lots of space (confirmation that the exact same number of db volumes IS
NOT required), and the first thing that happened as part of the restore, was
that the db was REDUCED to match the exact size of the original. The
restore was a success after that, but I thought it was interesting how the
db was reduced to match the original size.
Anne Short
Lockheed Martin Enterprise Information Systems
Gaithersburg, Maryland
301-240-6184
CODA/I Storage Management
-----Original Message-----
From: Prather, Wanda [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 19, 2001 5:37 PM
To: [EMAIL PROTECTED]
Subject: Re: DB restore
Well, I'll take a stab at this.
I know when you do a DB restore, the same disk layout (i.e., number of
DBVOLS) is NOT required, been there done that.
I believe the requirement is that the RESTORE TO data base (and recovery
log) must have AT LEAST as much space available as the original, although I
cannot remember where that is documented.
If this is a one-time move, what I would do is use the REDUCE command to
pare the source DB down to 5 GB, then back it up, then restore it to the new
location. If this is a DR drill, then I think you have a problem, but
congratulations on asking the right questions before it's too late!
-----Original Message-----
From: Joe Faracchio [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 19, 2001 5:26 PM
To: [EMAIL PROTECTED]
Subject: Re: DB restore
Good question. I'd like to know from someone that has experienced a
restore.
Somewhere it implies that you have to have the same disk layout because
its a record backup and not logical.
Is this true? Is it documented? I haven't found it, yet!
... joe.f.
Joseph A Faracchio, Systems Programmer, UC Berkeley
On Mon, 19 Mar 2001 [EMAIL PROTECTED] wrote:
> If I have a 20GB database that is spread accross 10 dbvols but is only 10%
> utilized can I restore that database onto a server with 5 dbvols totaling
> 10GB since the 5 dbvols will hold over the 10% of utilization.
>
