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

In article <4d8hll$8gh$1_at_mhadg.production.compuserve.com>, 72020.101_at_CompuServe.COM says...
>

Rather than using import/export or backup, consider

One-time tasks:

1. sqldba connect internal; spool datafiles.lis; select file_name from dba_data_files; select member from v$logfile;
2. shut down the database
3. copy (cp -p on UNIX) all datafiles, init.ora, and a control file from the test areas to your refresh area
4. backup all datafiles to tape (insurance)
5. copy from refresh back to test areas, verify you have all the datafiles and control files set up correctly. You only need one control file, but be sure to copy it to all the correct locations with the correct filenames.
6. start the database (you'll immediately know if you don't have all the datafiles you need)

If you're all set:

1. run your tests
2. cp -p to restore the datafiles and control file
3. gosub 1

It might be quicker than import - it is for me.

-- 
Lisa Roderick
Applications Systems Engineering Performance Group
Digital Equipment Corporation
Nashua, NH
lisa.roderick_at_zko.mts.dec.com