Re: Restoration of DB to pre-test state ???

bowdenj_at_iquest.net (Jim Bowden) wrote:
>
>We would like to know the smoothest way to capture an
>Oracle database at a point in time, conduct a series of
>tests and then restore the database to the pre-test
>condition.
>
>
>
>Jim Bowden
>7260 Shadeland Station 551 North Dearborn Street
>Indianapolis, IN Indianapolis, IN
>v: 317 594 1560 v: 317 263 0363
>f: 317 594 1562
>e: bowdenj_at_iquest.net, jbowden_at_velcome.iupui.edu
>w: velcome.iupui.edu/~jbowden
>Hostelling Information: gnn.com/gnn/bus/ayh
>010996
>
>

The best way would be perform a complete on-line backup. With the database in archive mode and the set of on-line backup tapes (and archived redo log tapes), you can restore the database to some point in time plus more.

-Ted.

-- 
=============================================
= Theodore Do                               =
= Senior Technical Specialist, UNIX/ORACLE  =
= TRW Information Technology Services       =
= tdo_at_mailsrv1.trw.com                      =
=============================================