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.
Yogesh said...do we need to drop target database before starting active cloning ?
The target database is the source, so dropping that would be a really bad idea. :)
You will need to remove the auxiliary (destination) database before doing the clone.
Yatender said...While creating duplicate db from active database its throwing following error.
RMAN-05001: auxiliary file name /u01/oracle/oradata/archive/1_24_941316145.dbf conflicts with a file used by the target database
I have already created all necessary directories but duplicate command fails with above error, even my db name is not getting change. :( Kindly help.
It seems to think this will overwrite an existing file. You are duplicating to a different machine right? If not you need to make sure the instance name is different and all paths are altered using the convert parameters. You will also need to make sure your duplicate command sets any other parameters from the source that include paths.
DO NOT ask technical questions here! They will be deleted!
These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!
If you post personal information (name, email address etc.) you are agreeing to them being stored and displayed. Feel free to remain anonymous.