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

Other related posts: