Sfrgttk

If angels and devils are the same species, why would their mortal offspring appear physically different?

Article. The word "Respect"

Why is that max-Q doesn't occur in transonic regime?

Which RAF squadrons and aircraft types took part in the bombing of Berlin on the 25th of August 1940?

Broad Strokes - missing letter riddle

Can you determine if focus is sharp without diopter adjustment if your sight is imperfect?

Coworker asking me to not bring cakes due to self control issue. What should I do?

Eww, those bytes are gross

Can a player sacrifice a creature after declaring that creature as blocker while taking lethal damage?

Can we "borrow" our answers to populate our own websites?

Potential client has a problematic employee I can't work with

How is this property called for mod?

Apex CPU Time Limit Exceeded error for DateMethods.Year()

What species should be used for storage of human minds?

Why do neural networks need so many training examples to perform?

What's this assembly doing?

Translation needed for 130 years old church document

Subsurf on a crown. How can I smooth some edges and keep others sharp?

What can I do to encourage my players to use their consumables?

Is there a way to store 9th-level spells in a Glyph of Warding or similar method?

I have trouble understanding this fallacy: "If A, then B. Therefore if not-B, then not-A."

Reading Mishnayos without understanding

Non-Cancer terminal illness that can affect young (age 10-13) girls?

Microtypography protrusion with Polish quotation marks

Duplicate databases error

Can RMAN duplicate be used to “replace” an existing database?Duplicating a Database with RMANNot able to connect to non-default oracle database after rebootConnected to an idle instance; trouble creating DBRMAN backup set, nothing else, how can I duplicate?Duplicate sequence of rowshow to prevent an oracle block corruption from duplicating a database with a few nologging tablesDelete duplicate with same ID PHP/PDO/MYSQLFrom RAC to Standby RAC With Active Dataguardduplicate key error index MongoDB

0

1

I have two Oracle 11gR2 databases on separate servers. I want to duplicate these databases.

For this, I do these steps :

• 
  

  In auxiliary db :

  
  
  
  
  
  • create password file with password that is same if target password
  
  
  
  


• 
  

  In target database:

  
  
  
  
  
  • Create a pfile and set db_name to auxiliary db
  
  
  • in tnsname.ora set the auxiliary db
  
  
  • with sqlplus connect to auxiliary db and startup, nomount with pfile.
  
  
  
  

With rman connect to these db and when I want to duplicate these databases with command below, I have an error that's in attach of this question.

Duplicate database to orcl1 with active database spfile nofilenamecheck.

Can any one help me?

oracle-11g-r2 duplication

share|improve this question

edited 4 mins ago

Glorfindel

9931816

asked Jan 21 '15 at 9:08

saeed.shsaeed.sh

761513

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Please copy the error you're getting as text into your question. Images aren't searchable (and the host you used is blocked by some corporate filters).
  
  – Mat
  Jan 21 '15 at 11:57
  

  
  
  
  

add a comment | 

0

1

I have two Oracle 11gR2 databases on separate servers. I want to duplicate these databases.

For this, I do these steps :

• 
  

  In auxiliary db :

  
  
  
  
  
  • create password file with password that is same if target password
  
  
  
  


• 
  

  In target database:

  
  
  
  
  
  • Create a pfile and set db_name to auxiliary db
  
  
  • in tnsname.ora set the auxiliary db
  
  
  • with sqlplus connect to auxiliary db and startup, nomount with pfile.
  
  
  
  

With rman connect to these db and when I want to duplicate these databases with command below, I have an error that's in attach of this question.

Duplicate database to orcl1 with active database spfile nofilenamecheck.

Can any one help me?

oracle-11g-r2 duplication

share|improve this question

edited 4 mins ago

Glorfindel

9931816

asked Jan 21 '15 at 9:08

saeed.shsaeed.sh

761513

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Please copy the error you're getting as text into your question. Images aren't searchable (and the host you used is blocked by some corporate filters).
  
  – Mat
  Jan 21 '15 at 11:57
  

  
  
  
  

add a comment | 

I have two Oracle 11gR2 databases on separate servers. I want to duplicate these databases.

For this, I do these steps :

• 
  

  In auxiliary db :

  
  
  
  
  
  • create password file with password that is same if target password
  
  
  
  


• 
  

  In target database:

  
  
  
  
  
  • Create a pfile and set db_name to auxiliary db
  
  
  • in tnsname.ora set the auxiliary db
  
  
  • with sqlplus connect to auxiliary db and startup, nomount with pfile.
  
  
  
  

With rman connect to these db and when I want to duplicate these databases with command below, I have an error that's in attach of this question.

Duplicate database to orcl1 with active database spfile nofilenamecheck.

Can any one help me?

oracle-11g-r2 duplication

share|improve this question

edited 4 mins ago

Glorfindel

9931816

asked Jan 21 '15 at 9:08

saeed.shsaeed.sh

761513

Duplicate database to orcl1 with active database spfile nofilenamecheck.

share|improve this question

edited 4 mins ago

Glorfindel

9931816

asked Jan 21 '15 at 9:08

saeed.shsaeed.sh

761513

share|improve this question

edited 4 mins ago

Glorfindel

9931816

asked Jan 21 '15 at 9:08

saeed.shsaeed.sh

761513

edited 4 mins ago

Glorfindel

9931816

edited 4 mins ago

Glorfindel

9931816

asked Jan 21 '15 at 9:08

saeed.shsaeed.sh

761513

asked Jan 21 '15 at 9:08

saeed.shsaeed.sh

761513

2 Answers
2

active

oldest

votes

0

the error messages you got because you don't have privileges to log in to the server so you need to grant the user the necessary access.

some tips to solve this issue:

1) Mount the remote disk locally (map network drive).

2) Use rman CATALOG command to make the backups available.

3) user has enough privileges on ORACLE level

share|improve this answer

answered Jan 21 '15 at 9:30

Ahmad AbuhasnaAhmad Abuhasna

1,99731329

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  i have mount auxiliary database in host db : (in target databse write this commancd : )sqlplus sys/password@orcl1 sql>startup nomount pfile='destination';
  
  – saeed.sh
  Jan 21 '15 at 9:46
  
  
  

  
  
  
  

add a comment | 

0

You didn't show your command to start rman, but it appears that you have not connected to both the target and the auxiliary. You will need something like this:

rman TARGET sys/password@source AUXILIARY sys/password@destination

I don't think it matters, but you also don't need to have the duplicate command in a run block.

If you haven't already, you may also need to set the db_file_name_convert and log_file_name_convert parameters in the spfile.

Documentation: http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta020.htm#RCMRF126

share|improve this answer

answered Jan 21 '15 at 14:03

Leigh RiffelLeigh Riffel

20.3k1366136

add a comment | 

Your Answer

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f89784%2fduplicate-databases-error%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

0

the error messages you got because you don't have privileges to log in to the server so you need to grant the user the necessary access.

some tips to solve this issue:

1) Mount the remote disk locally (map network drive).

2) Use rman CATALOG command to make the backups available.

3) user has enough privileges on ORACLE level

share|improve this answer

answered Jan 21 '15 at 9:30

Ahmad AbuhasnaAhmad Abuhasna

1,99731329

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  i have mount auxiliary database in host db : (in target databse write this commancd : )sqlplus sys/password@orcl1 sql>startup nomount pfile='destination';
  
  – saeed.sh
  Jan 21 '15 at 9:46
  
  
  

  
  
  
  

add a comment | 

0

the error messages you got because you don't have privileges to log in to the server so you need to grant the user the necessary access.

some tips to solve this issue:

1) Mount the remote disk locally (map network drive).

2) Use rman CATALOG command to make the backups available.

3) user has enough privileges on ORACLE level

share|improve this answer

answered Jan 21 '15 at 9:30

Ahmad AbuhasnaAhmad Abuhasna

1,99731329

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  i have mount auxiliary database in host db : (in target databse write this commancd : )sqlplus sys/password@orcl1 sql>startup nomount pfile='destination';
  
  – saeed.sh
  Jan 21 '15 at 9:46
  
  
  

  
  
  
  

add a comment | 

the error messages you got because you don't have privileges to log in to the server so you need to grant the user the necessary access.

some tips to solve this issue:

1) Mount the remote disk locally (map network drive).

2) Use rman CATALOG command to make the backups available.

3) user has enough privileges on ORACLE level

share|improve this answer

answered Jan 21 '15 at 9:30

Ahmad AbuhasnaAhmad Abuhasna

1,99731329

share|improve this answer

answered Jan 21 '15 at 9:30

Ahmad AbuhasnaAhmad Abuhasna

1,99731329

answered Jan 21 '15 at 9:30

Ahmad AbuhasnaAhmad Abuhasna

1,99731329

answered Jan 21 '15 at 9:30

Ahmad AbuhasnaAhmad Abuhasna

1,99731329

0

You didn't show your command to start rman, but it appears that you have not connected to both the target and the auxiliary. You will need something like this:

rman TARGET sys/password@source AUXILIARY sys/password@destination

I don't think it matters, but you also don't need to have the duplicate command in a run block.

If you haven't already, you may also need to set the db_file_name_convert and log_file_name_convert parameters in the spfile.

Documentation: http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta020.htm#RCMRF126

share|improve this answer

answered Jan 21 '15 at 14:03

Leigh RiffelLeigh Riffel

20.3k1366136

add a comment | 

0

You didn't show your command to start rman, but it appears that you have not connected to both the target and the auxiliary. You will need something like this:

rman TARGET sys/password@source AUXILIARY sys/password@destination

I don't think it matters, but you also don't need to have the duplicate command in a run block.

If you haven't already, you may also need to set the db_file_name_convert and log_file_name_convert parameters in the spfile.

Documentation: http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta020.htm#RCMRF126

share|improve this answer

answered Jan 21 '15 at 14:03

Leigh RiffelLeigh Riffel

20.3k1366136

add a comment | 

You didn't show your command to start rman, but it appears that you have not connected to both the target and the auxiliary. You will need something like this:

rman TARGET sys/password@source AUXILIARY sys/password@destination

I don't think it matters, but you also don't need to have the duplicate command in a run block.

If you haven't already, you may also need to set the db_file_name_convert and log_file_name_convert parameters in the spfile.

Documentation: http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta020.htm#RCMRF126

share|improve this answer

answered Jan 21 '15 at 14:03

Leigh RiffelLeigh Riffel

20.3k1366136

rman TARGET sys/password@source AUXILIARY sys/password@destination

share|improve this answer

answered Jan 21 '15 at 14:03

Leigh RiffelLeigh Riffel

20.3k1366136

answered Jan 21 '15 at 14:03

Leigh RiffelLeigh Riffel

20.3k1366136

answered Jan 21 '15 at 14:03

Leigh RiffelLeigh Riffel

20.3k1366136