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
- I created a pfile from the spfile on the target database and moved it to the new server.
- edited the new(init.ora) file to include the new database name and parameters
- created all the necessary directories.
- edited the listener.ora and tnsnames.ora files respectively
- created the password file on the clone server
- 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.