log shipping - synch

I have to schedule the automatic restore the standby database for
testing backups . The database was already in log shipping mode. Up to
what point do I need to restore the database without affecting the log
shipping sequence? Can we query the log shipping tables for the last
scn applied and recover up to that point? Any suggestoions are welcome.

Thanks

TramHi

Have you checked out other posts regarding re-syncing log shipping. Such as:
http://tinyurl.com/cot3k

If you want to look at manual log shipping check out
http://www.winnetmag.com/Artic*le/A...3231/23231.html
http://tinyurl.com/4ez3l
http://tinyurl.com/6rdth

John

"tram" <tram_e@.hotmail.com> wrote in message
news:1117879701.158308.305390@.o13g2000cwo.googlegr oups.com...
>I have to schedule the automatic restore the standby database for
> testing backups . The database was already in log shipping mode. Up to
> what point do I need to restore the database without affecting the log
> shipping sequence? Can we query the log shipping tables for the last
> scn applied and recover up to that point? Any suggestoions are welcome.
>
> Thanks
> Tram