ADSM-L

Re: Recovery of mirrored db and log volumes

2005-06-21 03:44:27
Subject: Re: Recovery of mirrored db and log volumes
From: Farren Minns <fminns AT WILEY.CO DOT UK>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Tue, 21 Jun 2005 08:43:51 +0100
Hi all

Regarding the reply below (thanks to Jop), I have managed to create new db
volumes and get them all synched up, so that's good. However, the log
volume that got lost was Copy 1 (see below), so what do I do now? Do I try
and make a copy of the remaining good copy (Copy 2), or do I use dsmfmt to
recreate the Copy 1 file that is missing and bring that back on-line? I'm
just being extra careful here as I don't want to do anything to cause me
more problems.

My log volumes look as follows :-

Operation Results


Volume Name               Copy            Volume Name
Copy            Volume Name       Copy
(Copy 1)                  Status          (Copy
2)                  Status          (Copy 3)          Status
----------------          ------          ----------------          ------     
     ----------------  ------

/usr/tsmdbs/log-          Off-L-          /usr/tsmdbs/log-          Sync'd     
                       Undefined

 02/dblog01.dsm            ine
01/logcopy01.dsm                                                               
               

Many thanks in advance.

Farren


>Hi Farren,

>Easiest is to create new DB & LOG volumes on the new disk of the same
>amount largeness.

>If you have done this with a 'dsmfmt' it is sufficient to create a
>"second mirror" with 'dbcopy'.
>In the q dbv the third column should be filled.
>After is says Sync'd, and you have done the same for the log file (q
>logv), you can remove the busted copy (dele dbv & dele logv), leaving
>two volumes (one original and one copy) in place.

>Cheers,

>Jop de Graaf
>Certified Tivoli Consultant/Instructor

>InterAccess Netherlands

Farren Minns
Solaris System Admin / Oracle DBA
IT - Hosting Services

John Wiley & Sons, Ltd.
The Atrium,
Southern Gate,
Chichester,
West Sussex PO19 8SQ.
Tel:  +44 (0) 1243 770406
Fax: +44 (0) 1243 775878

######################################################################
The information contained in this e-mail and any subsequent 
correspondence is private and confidential and intended solely 
for the named recipient(s).  If you are not a named recipient, 
you must not copy, distribute, or disseminate the information, 
open any attachment, or take any action in reliance on it.  If you 
have received the e-mail in error, please notify the sender and delete
the e-mail.  

Any views or opinions expressed in this e-mail are those of the 
individual sender, unless otherwise stated.  Although this e-mail has 
been scanned for viruses you should rely on your own virus check, as 
the sender accepts no liability for any damage arising out of any bug 
or virus infection.
######################################################################

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