Home » RDBMS Server » Backup & Recovery » RMAN duplicate (Oracle 10g red hat 3)
RMAN duplicate [message #617941] Fri, 04 July 2014 11:34 Go to next message
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 #617946 is a reply to message #617941] Fri, 04 July 2014 13:30 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Welcome to this forum

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and please read http://www.orafaq.com/forum/t/174502/102589/

http://francispaulraj.wordpress.com/ora-12528-tnslistener-all-appropriate-instances-are-blocking-new-connections/
Re: RMAN duplicate [message #617956 is a reply to message #617941] Sat, 05 July 2014 06:15 Go to previous messageGo to next message
John Watson
Messages: 8922
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

Re: RMAN duplicate [message #617966 is a reply to message #617956] Sat, 05 July 2014 13:03 Go to previous message
oxfordpauluk
Messages: 2
Registered: July 2014
Junior Member
Thanks will give that a try.
--update worked perfectly thanks again.

[Updated on: Sun, 06 July 2014 11:09]

Report message to a moderator

Previous Topic: Hot backup using RMAN
Next Topic: RMAN Restore from different path
Goto Forum:
  


Current Time: Thu Mar 28 20:50:11 CDT 2024