Home » RDBMS Server » Backup & Recovery » duplication of db
duplication of db [message #156906] Sun, 29 January 2006 19:37 Go to next message
skodman
Messages: 10
Registered: March 2005
Location: Auckland
Junior Member
Here is the thing.
I have production db on one machine and test db on second. Test DB has the same schema's defined like production db except they are all empty (no tables, procedures etc.).

Now i have to duplicate production db to test environment. I do have full backup of production database (level 0 from yesterday).
What is the best way to do this?
Re: duplication of db [message #156942 is a reply to message #156906] Mon, 30 January 2006 04:25 Go to previous message
alanm
Messages: 284
Registered: March 2005
Senior Member

hi,
to duplicate use the following syntax (all done from within the RMAN environment)

I normally take a look at the alertlog file from the production database to get a log sequence that has been archived

run {
set newname for datafile xx to '/path/datafile.dbf';

add the rest of your datafiles here

set until logseq xxxx thread 1;

duplicate target database to TEST

logfile
GROUP 4 ('/full_path/TESTlog4.dbf') size 100M,
GROUP 3 ('/full_path/TESTlog3.dbf') size 100M,
GROUP 2 ('/full_path/TESTlog2.dbf') size 100M,
GROUP 1 ('/full_path/TESTlog1.dbf') size 100M,
GROUP 5 ('/full_path/TESTlog5.dbf') size 100M;
}

you need to add the required amount of logfiles

hope this helps

Alan.

[Updated on: Mon, 30 January 2006 05:02]

Report message to a moderator

Previous Topic: oracle DB recovery using rman
Next Topic: offline tablespace backup
Goto Forum:
  


Current Time: Mon Dec 23 03:19:49 CST 2024