DG搭建--做主库复制到备库发生错误

在主备库其他设置都做好了以后，进行rman 的duplicate 操作，将主库复制到备库时发生如下错误：
操作过程及问题的发生：

1. [oracle@ming ~]$ rman target sys/oracle@pmxdb auxiliary sys/oracle@smxdb
   
2. 
   
3. Recovery Manager: Release 11.2.0.3.0 - Production on Tue Aug 18 11:57:02 2015
   
4. 
   
5. Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
   
6. 
   
7. connected to target database: MXDB (DBID=2294087120)
   
8. connected to auxiliary database: MXDB (not mounted)
   
9. 
   
10. RMAN> duplicate target database for standby nofilenamecheck from active database;
    
11. 
    
12. Starting Duplicate Db at 18-AUG-15
    
13. using target database control file instead of recovery catalog
    
14. allocated channel: ORA_AUX_DISK_1
    
15. channel ORA_AUX_DISK_1: SID=134 device type=DISK
    
16. 
    
17. contents of Memory Script:
    
18. {
    
19.    backup as copy reuse
    
20.    targetfile '/yang/u02/oracle/dbs/orapwmxdb' auxiliary format
    
21.  '/yang/u02/oracle/dbs/orapwmxdb' ;
    
22. }
    
23. executing Memory Script
    
24. 
    
25. Starting backup at 18-AUG-15
    
26. allocated channel: ORA_DISK_1
    
27. channel ORA_DISK_1: SID=15 device type=DISK
    
28. RMAN-00571: ===========================================================
    
29. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    
30. RMAN-00571: ===========================================================
    
31. RMAN-03002: failure of Duplicate Db command at 08/18/2015 11:57:48
    
32. RMAN-05501: aborting duplication of target database
    
33. RMAN-03015: error occurred in stored script Memory Script
    
34. RMAN-03009: failure of backup command on ORA_DISK_1 channel at 08/18/2015 11:57:48
    
35. ORA-17629: Cannot connect to the remote database server
    
36. ORA-17627: ORA-12154: TNS:could not resolve the connect identifier specified
    
37. ORA-17629: Cannot connect to the remote database server

分析：
关键问题应该在
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
这个部分，通过错误提示，应该是不能连接到远程数据库。
1、可能是密码文件的问题
2、可能是tnsname.ora 配置文件有误或监听文件有问题

尝试解决问题：
1、备库：
分别做主库和备库的登录尝试：

1. [oracle@ming ~]$ sqlplus sys/oracle@pmxdb as sysdba
   
2. 
   
3. SQL*Plus: Release 11.2.0.3.0 Production on Tue Aug 18 12:38:01 2015
   
4. 
   
5. Copyright (c) 1982, 2011, Oracle. All rights reserved.
   
6. 
   
7. 
   
8. Connected to:
   
9. Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
   
10. With the Partitioning, OLAP, Data Mining and Real Application Testing options
    
11. 
    
12. SQL> exit
    
13. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
    
14. With the Partitioning, OLAP, Data Mining and Real Application Testing options
    
15. [oracle@ming ~]$ sqlplus sys/oracle@smxdb as sysdba
    
16. 
    
17. SQL*Plus: Release 11.2.0.3.0 Production on Tue Aug 18 12:38:11 2015
    
18. 
    
19. Copyright (c) 1982, 2011, Oracle. All rights reserved.
    
20. 
    
21. 
    
22. Connected to:
    
23. Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
    
24. With the Partitioning, OLAP, Data Mining and Real Application Testing options
    
25. 
    
26. SQL> exit

两个都登录成功，说明密码文件和备库的监听文件，以及tnsname.ora都没问题。

2、主库：
分别做主库和备库的登录尝试：

1. [oracle@yang ~]$ sqlplus sys/oracle@pmxdb as sysdba
   
2. 
   
3. SQL*Plus: Release 11.2.0.3.0 Production on Tue Aug 18 12:37:16 2015
   
4. 
   
5. Copyright (c) 1982, 2011, Oracle. All rights reserved.
   
6. 
   
7. ERROR:
   
8. ORA-12154: TNS:could not resolve the connect identifier specified
   
9. 
   
10. 
    
11. Enter user-name:
    
12. ERROR:
    
13. ORA-01017: invalid username/password; logon denied
    
14. 
    
15. 
    
16. Enter user-name:
    
17. ERROR:
    
18. ORA-01017: invalid username/password; logon denied
    
19. 
    
20. 
    
21. SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
    
22. [oracle@yang ~]$ sqlplus sys/oracle@smxdb as sysdba
    
23. 
    
24. SQL*Plus: Release 11.2.0.3.0 Production on Tue Aug 18 12:37:34 2015
    
25. 
    
26. Copyright (c) 1982, 2011, Oracle. All rights reserved.
    
27. 
    
28. ERROR:
    
29. ORA-12154: TNS:could not resolve the connect identifier specified
    
30. 
    
31. 
    
32. Enter user-name:
    
33. ERROR:
    
34. ORA-01017: invalid username/password; logon denied
    
35. 
    
36. 
    
37. Enter user-name:
    
38. ERROR:
    
39. ORA-01017: invalid username/password; logon denied
    
40. 
    
41. 
    
42. SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

说明，主库的某些配置出现了问题，
首先密码文件：
由于我确定我只前做了密码的更改操作
[oracle@qing ~]$ orapwd file=/u01/oracle/11g/dbs/orapwupdb password=oracle force=y ignorecase=y
所以先排除密码错误的因素。

其次查看
listener.ora 文件

1. LISTENER2 =
2. (ADDRESS_LIST=
3. (ADDRESS=(PROTOCOL=tcp)(HOST=yang.uplooking.com)(PORT=1521))
4. (ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER1521)))
7. SID_LIST_LISTENER=
8. (SID_LIST=
9. (SID_DESC=
10. (GLOBAL_DBNAME=mxdb)
11. (SID_NAME=mxdb)
12. (ORACLE_HOME=/yang/u02/oracle)
13. )
14. (SID_DESC=
15. (GLOBAL_DBNAME=pmxdb)
16. (SID_NAME=mxdb)
17. (ORACLE_HOME=/yang/u02/oracle)
18. )
19. (SID_DESC=
20. (GLOBAL_DBNAME=pmxdb_DGMGRL)
21. (SID_NAME=mxdb)
22. (ORACLE_HOME=/yang/u02/oracle)
23. )
24. )

host以及实例名都与我们设计的相同，所以该文件没有问题，

接下来再查看tnsname.ora文件：

1. mxdb =
2. (DESCRIPTION =
3. (ADDRESS = (PROTOCOL = TCP)(HOST = yang.uplooking.com)(PORT = 1521))
4. (CONNECT_DATA =
5. (SERVER = dedicated)
6. (SERVICE_NAME = mxdb)
7. )
8. )
10. pupdb =
11. (DESCRIPTION =
12. (ADDRESS = (PROTOCOL = TCP)(HOST = yang.uplooking.com)(PORT = 1521))
13. (CONNECT_DATA =
14. (SERVER = dedicated)
15. (SERVICE_NAME = pupdb)
16. )
17. )
19. supdb =
20. (DESCRIPTION =
21. (ADDRESS = (PROTOCOL = TCP)(HOST = ming.up.com)(PORT = 1521))
22. (CONNECT_DATA =
23. (SERVER = dedicated)
24. (SERVICE_NAME = supdb)
25. )
26. )

发现我们的服务名不对，将所有的updb改为mxdb ，重新在主库上进行连接测试，成功。

重新进行rman的duplicate复制，这下就成功了。

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

转载于:http://blog.itpub.net/28946321/viewspace-1775678/