RMAN-06136: ORACLE error from auxiliary database: ORA-17629

Finished backup at 27-DEC-18

contents of Memory Script:
{
   restore clone from service  'prod5h1' standby controlfile;
}
executing Memory Script

Starting restore at 27-DEC-18
using channel ORA_AUX_DISK_1

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 12/27/2018 16:03:36
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-06136: ORACLE error from auxiliary database: ORA-17629: Cannot connect to the remote database server
ORA-17627: ORA-12154: TNS:could not resolve the connect identifier specified
ORA-17629: Cannot connect to the remote database server

问题原因：tnsnames.ora中只配了prod1的字符串。

解决办法：主备库同时在tnsnames.ora加入prod1和prod2.

PROD1=
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = hx01.example.com)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = PROD1.example.com)
    )
  )
 
PROD2=
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = hx02.example.com)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = PROD2.example.com)
    )
  )

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/31557076/viewspace-2286708/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/31557076/viewspace-2286708/