Since you only have a small DB, you could do a DB Load/Unload, then you can use
less physical space
It will however take longer than a straight restore
"Short, Anne" <[EMAIL PROTECTED]> on 03/20/2001 12:51:45 PM
Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
cc: (bcc: John Naylor/HAV/SSE)
Subject: Re: DB restore
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.
>
**********************************************************************
The information in this E-Mail is confidential and may be legally
privileged. It may not represent the views of Scottish and Southern
Energy plc.
It is intended solely for the addressees. Access to this E-Mail by
anyone else is unauthorised. If you are not the intended recipient,
any disclosure, copying, distribution or any action taken or omitted
to be taken in reliance on it, is prohibited and may be unlawful.
Any unauthorised recipient should advise the sender immediately of
the error in transmission.
Scottish Hydro-Electric and Southern Electric are trading names of
Scottish and Southern Energy Group.
**********************************************************************
