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" |
> | | <MRemeta@SELIGMAN|
> | | 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.
>
>
|