| RMAN duplicate [message #617941] |
Fri, 04 July 2014 11:34  |
 |
oxfordpauluk
Messages: 2
Registered: July 2014
|
Junior Member |
|
|
Hi,
Sorry but struggling to get this to work, and bound to be something foolish but...
Trying to duplicate a database onto same server so we can do some testing against the same volume data and on same hardware etc, so thought best/simplest way would be to use rman duplicate database.
I have created a new pfile and change structure, have tried to edit tnsnames and listener to add aux, start and stop lstnr but then when I try to either connect to Aux in rman or sqlplus I get:
RMAN> RMAN-04006: error from auxiliary database: ORA-12528: TNS:listener: all appropriate instances are blocking new connections
or
[yedv6app@yedell03 yedv6app]$ sqlplus user/password@aux as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Jul 4 16:47:41 2014
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-12528: TNS:listener: all appropriate instances are blocking new connections
lsnrctl status is:
[yedv6app@servername yedv6app]$ lsnrctl status
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 04-JUL-2014 16:40:04
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 04-JUL-2014 15:01:07
Uptime 0 days 1 hr. 38 min. 56 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u00/app/yedv6app/yedv6DB/network/admin/listener.ora
Listener Log File /u00/app/yedv6app/yedv6DB/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=servername)(PORT=1521)))
Services Summary...
Service "YEDV6" has 1 instance(s).
Instance "YEDV6", status READY, has 1 handler(s) for this service...
Service "YEDV6XDB" has 1 instance(s).
Instance "YEDV6", status READY, has 1 handler(s) for this service...
Service "YEDV6_XPT" has 1 instance(s).
Instance "YEDV6", status READY, has 1 handler(s) for this service...
Service "aux" has 1 instance(s).
Instance "aux", status BLOCKED, has 1 handler(s) for this service...
Service "aux_XPT" has 1 instance(s).
Instance "aux", status BLOCKED, has 1 handler(s) for this service...
The command completed successfully
and listenter.ora is:
# listener.ora Network Configuration File: /u00/app/yedv6app/yedv6DB/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_YEDV6=
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u00/app/yedv6app/yedv6DB)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = YEDV6)
(ORACLE_HOME = /u00/app/yedv6app/yedv6DB)
)
(SID_DESC =
(SID_NAME = aux)
(ORACLE_HOME = /u00/app/yedv6app/yedv6DB)
)
)
YEDV6 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROCYEDV6))
(ADDRESS = (PROTOCOL = TCP)(HOST = servername)(PORT = 1521))
)
)
and tnsnames is:
# tnsnames.ora Network Configuration File: /u00/app/yedv6app/yedv6DB/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
YEDV6 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = servername)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = YEDV6)
)
)
aux =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = servername)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = aux)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROCYEDV6))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
Actual dbf files are meant to go to:
/u00/app/yedv6app/oradata/YEDV6
/u00/app/yedv6app/oradata/aux
Thanks for any help.
|
|
|
|
|
|
| Re: RMAN duplicate [message #617956 is a reply to message #617941] |
Sat, 05 July 2014 06:15  |
John Watson
Messages: 8968
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
You should be able to connect to the open target and the nomount auxiliary and run the duplicate if you connect like this, using passwordfile authentication to connect to the target and operating system authentication to connect to the auxiliary:
rman target sys/password@yedv6 auxiliary /
--added: you must of course SET ORACLE_SID=AUX first
[Updated on: Sat, 05 July 2014 06:16] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
