|Duplicate a Database Using RMAN in Oracle Database 11g Release 2 - This article summarizes the process of duplicating a database using the RMAN DUPLICATE command.|
lesio said...nice for start
G said...there is a section missing:
creating the oracle instance
"STARTUP NOMOUNT;" creates an instance. It is not missing. The procedures work fine. Try them before posting comments saying they are missing something.
Vimal said...Hi, as the other user said the section to create the instance service in OS level is missing. I mean creating new SID service with ORADIM.
Also, we must allocate at least one auxiliary channel before executing duplicate command.
You can see from the paths that this was done on Linux/UNIX, not on Windows. That's why I didn't mention ORADIM.EXE.
Can't speak for Windows, but on Linux no additional channel allocation is necessary.
Barry said...Seemed to lose the thread of it when it said you can conenct to the target/auxiliary/catalog depending on what type of duplication you want but did not follow up with anything. Type of duplication followed by the connection required would have been helpful.
Ernie said...There is a problem in this procedure... The duplicate won't work if all you are using is:
$ rman AUXILIARY /
How will RMAN get the metadata from the backup? RMAN needs to either connect to the target or a catalog server to get/read the backup metadata correct?
If I'm wrong... please enlighten me. :)
Ernie said...Oops... I stand corrected... I'm used to using the SBT channel, but apparently it cab be done with disk based backup.
From Oracle documentation:
In this case, the only requirement is that you provide a disk backup location where RMAN can find all the backups, data file copies, archived logs, and control file copies for database duplication.
Tim... said...No worries. :)
JL said...Will see if I can translate into Windows.
Sanjay Acharya said...This is one of the nice way i have seen to explain, very very easy to understand. Thank you very much.