ADSM-L

Re: Database and log format question.

2004-04-29 15:15:54
Subject: Re: Database and log format question.
From: Andy Carlson <andyc AT ANDYC.CARENET DOT ORG>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 29 Apr 2004 13:15:24 -0500
You are correct, there is no log information.  What is happening is, as
someone here surmised, the DB is being formatted.  I normally get
messages while it is formatting, if I remember right, but it does take a
long time.  I am on AIX though, not Windows.

Andy Carlson

On Wed, 28 Apr 2004, Remeta, Mark wrote:

> Thanks Daniel. I haven't even begun the database restore yet.
> Also I do not believe there is any log information since I erased
> the existing logs before I started the format.
>
>
> Mark
>
>
> -----Original Message-----
> From: Daniel Sparrman [mailto:Daniel.Sparrman AT EXIST DOT SE]
> Sent: Wednesday, April 28, 2004 9:53 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: Database and log format question.
>
>
> Hi
>
> My guess is that it's commiting log information. During DB restore, the
> restore is sequential. However, when commiting the log information, it is
> commiting the log on a per transaction basis. If you're logs where highly
> used during your last db backup, this could explain why it's taking so
> long for the TSM server to mount the log.
>
> Remember, that during inital startup after a db restore, the TSM server
> will do a recovery log roll-back, and commit all transactions within the
> TSM log.
>
> Best Regards
>
> Daniel Sparrman
> -----------------------------------
> Daniel Sparrman
> Exist i Stockholm AB
> Propellervägen 6B
> 183 62 TÄBY
> Växel: 08 - 754 98 00
> Mobil: 070 - 399 27 51
>
>
>
> "Remeta, Mark" <MRemeta AT SELIGMANDATA DOT COM>
> Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
> 2004-04-28 15:47
> Please respond to
> "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
>
>
> To
> ADSM-L AT VM.MARIST DOT EDU
> cc
>
> Subject
> Re: Database and log format question.
>
>
>
>
>
>
> ok the server specs are a quad 1.4ghz pentium 4, 4gb memory running win2k
> advanced server.
> What I did was erase the old log and database volumes, then do a dsmserv
> -k
> format with the log and database volume specs.
> It created the volumes and formatted the recovery log volumes rather
> quickly.
> After it format's the recovery log volumes it does a recovery log volume
> mount.
> This is what is taking so long.
> I've been monitoring the IO and it seems to be doing something to the
> database disk, perhaps formatting the database volumes too? I don't know.
> I've done this before but never with a database this large.
>
> Thanks,
> Mark
>
>
> -----Original Message-----
> From: Justin Bleistein [mailto:justin.bleistein AT SUNGARD DOT COM]
> Sent: Wednesday, April 28, 2004 9:35 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: Database and log format question.
>
>
> 3 hours? Wow!. What's are the hardware specs of your tsm server? What else
> is going on, on that system (topas, if AIX, or top)?
> I would probably consider running either a database audit or re-org, then
> try mounting it again.
> thanks!
>
>       On more thing, are you starting the server up again in the
> foreground
> or background?. If your initially trying to start it up in
> the background, kill it and start it up in the foreground first then let
> it
> do all of it's redo log record and undo passes, as well as log mount.
> Then once it's up, and you get a tsm server prompt. Then halt the server
> and restart it in the background for production operation
> at that point. Just another thought.
>
> --Justin Richard Bleistein
>
>
> |---------+---------------------------->
> |         |           "Remeta, Mark"   |
> |         |           <[email protected]|
> |         |           DATA.COM>        |
> |         |           Sent by: "ADSM:  |
> |         |           Dist Stor        |
> |         |           Manager"         |
> |         |           <[email protected]|
> |         |           .EDU>            |
> |         |                            |
> |         |                            |
> |         |           04/28/2004 09:19 |
> |         |           AM               |
> |         |           Please respond to|
> |         |           "ADSM: Dist Stor |
> |         |           Manager"         |
> |         |                            |
> |---------+---------------------------->
>
> >---------------------------------------------------------------------------
> ---------------------------------------------------|
>   |
> |
>   |       To:       ADSM-L AT VM.MARIST DOT EDU
> |
>   |       cc:
> |
>   |       Subject:  Database and log format question.
> |
>
> >---------------------------------------------------------------------------
> ---------------------------------------------------|
>
>
>
>
> Yesterday morning I had an incident and lost one of the drives I had about
> half my database volumes defined on.
> I'm in the process of reformatting the log and database volumes so I can
> do
> a database restore.
> The database is 100gb and my log size is 13gb.
> It's been mounting the log volumes for over 3 hours now.
> Does anyone have any experience with a database this large in as far as
> approximately how long it will take to format and mount the database/log
> volumes?
>
>
> Thanks in advance,
> Mark Remeta
>
> Confidentiality Note: The information transmitted is intended only for the
> person or entity to whom or which it is addressed and may contain
> confidential and/or privileged material. Any review, retransmission,
> dissemination or other use of this information by persons or entities
> other
> than the intended recipient is prohibited. If you receive this in error,
> please delete this material immediately.
>
> Confidentiality Note: The information transmitted is intended only for the
> person or entity to whom or which it is addressed and may contain
> confidential and/or privileged material. Any review, retransmission,
> dissemination or other use of this information by persons or entities other
> than the intended recipient is prohibited. If you receive this in error,
> please delete this material immediately.
>
>

<Prev in Thread] Current Thread [Next in Thread>