Do a redirect restore, copy the log files, rollforward database to the
specified time with complete option. I think this make more sense.

Thank you,

Akhilesh Mittal




"Premnath " <db2udbdba-ezmlmshield-x16044431.[Email address protected]
12/29/2005 04:20 PM
Mail Size: 5507

To
"LazyDBA Discussion" <[Email address protected]
cc

Subject
Re: Urgent Help ..
Our Ref

Your Ref







how will you roll forward in to a point that to after restoring the
database
to somewhere else....please can be more specific or step by step. Thanks


----- Original Message -----
From: "akhileshmittal"
<db2udbdba-ezmlmshield-x9597544.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Thursday, December 29, 2005 4:19 PM
Subject: Re: Urgent Help ..


> Rishi,
>
> Restore the database somewhere else, rollforward it to a point before
the
> data was deleted and then you can retrive the deleted data of table.
>
> Thank you,
>
> Akhilesh Mittal
>
>
>
> "Rishi Upendran "
> <db2udbdba-ezmlmshield-x83885218.[Email address protected]
> 12/29/2005 04:16 PM
> Mail Size: 3508
>
> To
> "LazyDBA Discussion" <[Email address protected]
> cc
>
> Subject
> Urgent Help ..
> Our Ref
>
> Your Ref
>
>
>
>
>
>
>
> HI,
>
> how to recover to deleted records from db2..
>
> I tried rollback, it is not working..
>
> any other solution is there for this??
>
> Thanks
> U.Rishi.
>
>
> ---------------------------------------------------------------------
> PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> website: http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
> -----------------------------------------
> ******************************************************************
> This message originated from the Internet. Its originator may or may
> not be who they claim to be and the information contained in the
> message and any attachments may or may not be accurate.
> ******************************************************************
>
>
>
>
>
> -----------------------------------------
> ***********************************************************************
> This e-mail is confidential. It may also be legally privileged.
> If you are not the addressee you may not copy, forward, disclose
> or use any part of it. If you have received this message in error,
> please delete it and all copies from your system and notify the
> sender immediately by return e-mail.
>
> Internet communications cannot be guaranteed to be timely,
> secure, error or virus-free. The sender does not accept liability
> for any errors or omissions.
> ***********************************************************************
>
>
> ---------------------------------------------------------------------
> PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> website: http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>



---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



DB2 & UDB email list listserv db2-l LazyDBA home page