Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

RMAN CLONE/DUPLICATE FAILED

2935122May 1 2015 — edited May 4 2015

Hello Everyone,

                          I am having problems with cloning an oracle  database (11gr2) using Rman. I have completed all the steps and the process fails during the duplicate process. The clonning is being done from one unix  server to another . These are the steps I have completed so far

  1. I created a pfile from the spfile on the target database and moved it to the new server.
  2. edited the new(init.ora) file to include the new database name and parameters
  3. created all the necessary directories.
  4. edited the listener.ora and tnsnames.ora files respectively
  5. created the password file on the clone server
  6. Took a full backup of the database.

These are the issues I am currently facing.

  • I'm unable to connect to the clone database (connect sys /as sysdba) without using a password
  • Rman connect auxiliary / does not work without me specifying the sid name.
  • below is the sysout when the process fails.

RMAN> run {
2> allocate auxiliary channel c1 device type disk;
3> allocate channel c2 device type disk;
4> duplicate target database to 'IVDBLAB';
5> }

using target database control file instead of recovery catalog
allocated channel: c1
channel c1: SID=298 device type=DISK

allocated channel: c2
channel c2: SID=432 device type=DISK

Starting Duplicate Db at 01-MAY-15

contents of Memory Script:
{
   sql clone "alter system set  db_name =
''PROD'' comment=
''Modified by RMAN duplicate'' scope=spfile";
   sql clone "alter system set  db_unique_name =
''LAB'' comment=
''Modified by RMAN duplicate'' scope=spfile";
   shutdown clone immediate;
   startup clone force nomount
   restore clone primary controlfile;
   alter clone database mount;
}
executing Memory Script

sql statement: alter system set  db_name =  ''PROD'' comment= ''Modified by RMAN duplicate'' scope=spfile

sql statement: alter system set  db_unique_name =  ''LAB'' comment= ''Modified by RMAN duplicate'' scope=spfile

Oracle instance shut down

released channel: c2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 05/01/2015 11:59:36
RMAN-06174: not connected to auxiliary database
RMAN-03015: error occurred in stored script Memory Script
RMAN-04006: error from auxiliary database: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

RMAN>

can someone please help me.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 1 2015
Added on May 1 2015
15 comments
5,734 views