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.
Marcel said...Hello Tim,
one question to backupbased duplication.
I do the backups via sbt_tape driver. So i need to connect via rman to target and auxiliary for duplicate.
But now i only want to do a incomplete duplicate to the time of the last backup. But also i don't want to manually set until time or scn.
I searched but find nothing. It is possible to do that?
Thanks for advices
I don't understand why you can't set an until time or SCN, but...
If you use a backup location for your duplicate, you can perform the duplicate based on only what is available/possible in the backup location. It uses the metadata from the backups, not from the catalog. We do this sometimes from disk-based backups. Not sure how this works from tape though.
Sri Balaje said...Hi,
Before duplicating we used pfile parameter with only DBNAME=11G. Wanted to understand while doing startup nomount with it, how memory n background processes gets allocated initially?
It uses defaults for everything. If you look at the duplicate command, it include SPFILE. It will create a new SPFILE and the instance will be restarted using that, which is how you end up with the proper settings. :)
Yong said...Should the line
No. It's creating a new database called MYCLONE as a clone of DB11G.
Yong said...You're right. I mistakenly interpreted it to be duplicating for standby.
No problem. The duplicate database articles include the clones for standby.
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.