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:
>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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
