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

  • From: Mladen Gogala <mgogala@xxxxxxxxxxxxxxxxxxxx>
  • To: j.velikanovs@xxxxxxxxx
  • Date: Mon, 18 Apr 2005 17:27:31 -0400

Yury Velikanov wrote:

>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


Other related posts: