| duplication of db [message #156906] |
Sun, 29 January 2006 19:37  |
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  |
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
