Re: Q:Copy production database to Q/A or test environment

Yury Velikanov wrote:

>Amihay,
>
>It is easy if you need to copy whole database.
>
>
>

Yup. Something like this will do it:

run {
set until scn= 4706686;
duplicate target database for standby dorecover; }

Just figure out the appropriate SCN by using "list backup of database;" which will show the appropriate checkpoint SCN and run this little script from the appropriate interpretter, with appropriate arguments and it's done.

-- 
Mladen Gogala
Oracle DBA
Ext. 121


--
http://www.freelists.org/webpage/oracle-l