Dear all,
I did RMAN cloning from Server to Server
Source : cdc1.com (11201) -> database name is orcl
Target : cdc3.com (11201) -> here i did cloning named as 'clon'
Problem:
After successful cloning, i could NOT able to connect to the database on the auxiliary SERVER (clon) database
I am sure clon database is up and running
$ ps -ef | grep pmon
oracle 8141 1 0 Oct25 ? 00:00:00 ora_pmon_clon
oracle 9046 4628 0 00:09 pts/1 00:00:00 grep pmon
[oracle@cdc3 dbs]$
>> Connecting clon database at auxiliary Server
oracle@cdc3 dbs]$ . oraenv
ORACLE_SID = [clon] ? clon
The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 is /u01/app/oracle
[oracle@cdc3 dbs]$ rlsqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Fri Oct 26 00:03:12 2018
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
>> From Source database 'orcl' i,e (target database), i am able to connect to Auxiliary database (clon)
SQL> select name from v$database;
NAME
---------
ORCL
SQL> conn sys/orcl@CLON as sysdba
Connected.
SQL> select name from v$database;
NAME
---------
CLON
SQL> select status from v$instance;
STATUS
------------
OPEN
NOTE => From Source database, i am able to connect.
What was the problem ?
>> Duplicate command - It was successful
RMAN> duplicate target database to 'clon' from active database;
Starting Duplicate Db at 25-OCT-18
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=19 device type=DISK
contents of Memory Script:
{
sql clone "create spfile from memory";
}
executing Memory Script
sql statement: create spfile from memory
contents of Memory Script:
{
shutdown clone immediate;
startup clone nomount;
}
executing Memory Script
Oracle instance shut down
connected to auxiliary database (not started)
Oracle instance started
Total System Global Area 835104768 bytes
Fixed Size 2217952 bytes
Variable Size 494929952 bytes
Database Buffers 335544320 bytes
Redo Buffers 2412544 bytes
contents of Memory Script:
{
sql clone "alter system set db_name =
''ORCL'' comment=
''Modified by RMAN duplicate'' scope=spfile";
sql clone "alter system set db_unique_name =
''CLON'' comment=
''Modified by RMAN duplicate'' scope=spfile";
shutdown clone immediate;
startup clone force nomount
backup as copy current controlfile auxiliary format '/u02/app/oracle/oradata/clon/control01.ctl';
restore clone controlfile to '/u02/app/oracle/flash_recovery_area/clon/control02.ctl' from
'/u02/app/oracle/oradata/clon/control01.ctl';
alter clone database mount;
}
executing Memory Script
..
...
TRIMMED
}
executing Memory Script
executing command: SET NEWNAME
renamed tempfile 1 to /u02/app/oracle/oradata/clon/temp01.dbf in control file
cataloged datafile copy
datafile copy file name=/u02/app/oracle/oradata/clon/sysaux01.dbf RECID=1 STAMP=990487910
cataloged datafile copy
datafile copy file name=/u02/app/oracle/oradata/clon/undotbs01.dbf RECID=2 STAMP=990487910
cataloged datafile copy
datafile copy file name=/u02/app/oracle/oradata/clon/users01.dbf RECID=3 STAMP=990487910
cataloged datafile copy
datafile copy file name=/u02/app/oracle/oradata/clon/example01.dbf RECID=4 STAMP=990487910
datafile 2 switched to datafile copy
input datafile copy RECID=1 STAMP=990487910 file name=/u02/app/oracle/oradata/clon/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=2 STAMP=990487910 file name=/u02/app/oracle/oradata/clon/undotbs01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=3 STAMP=990487910 file name=/u02/app/oracle/oradata/clon/users01.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=4 STAMP=990487910 file name=/u02/app/oracle/oradata/clon/example01.dbf
contents of Memory Script:
{
Alter clone database open resetlogs;
}
executing Memory Script
database opened
Finished Duplicate Db at 25-OCT-18
O.S : RHEL 5.7
DB : 11201