| Clone using RMAN [message #305763] |
Tue, 11 March 2008 22:39  |
dbasudar
Messages: 8
Registered: August 2007
Location: chennai
|
Junior Member |
|
|
Hi
I took a rman backup in oracle 9i on windows.using that backup,i tried to make a clone database.but when using "duplicate target database" command it shows an error that the there is no backup of the datafile.i have attached here with my error message.can anyone help me to make a clone database.
Thank you
|
|
|
|
|
|
| Re: Clone using RMAN [message #306006 is a reply to message #305763] |
Wed, 12 March 2008 09:45  |
kudur_kv
Messages: 75
Registered: February 2005
|
Member |
|
|
One simple question.
Are you trying to clone on the same server/machine or another?
because if you are trying to do this on the same server, you normally do not get this error.
You need to make sure that you have the necessary pfiles and controlfiles. you need to start the clone DB in nomount stage.
Yes. Read the documentation on the link provided by ebrian.
KV.
[Updated on: Wed, 12 March 2008 09:48] Report message to a moderator |
|
|
|
|
|
| Re: Clone using RMAN [message #306032 is a reply to message #306024] |
Wed, 12 March 2008 11:02 |
kudur_kv
Messages: 75
Registered: February 2005
|
Member |
|
|
Honestly, you need to read the documentation, understand the process to a certain extend and then try anything anywhere.
You do not keep the production in Nomount stage. The production DB has to be open, the test/dev database has to be in no mount stage. you dont even seem to have set a different name/path for your clone db. Where are the datafiles for the clone database supposed to be go? you need to specify that as well. for Example.
run {
ALLOCATE AUXILIARY CHANNEL CH00 TYPE disk;
SET NEWNAME FOR DATAFILE 1 TO 'E:/oradata/clonedb/system01.dbf';
SET NEWNAME FOR DATAFILE 2 TO 'E:/oradata/clonedb/undotbs01.dbf';
..
.
.
.
.
.
for all the datafiles. you need to add the redo log files and the temporary tablespace file.
Remember that the RMAN backup does not consider the Temporary tablespace while backing up a DB.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
