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博客

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

最新文章