搭建dataguard时复制数据库的orapw文件出错

乌鲁木齐-小小

问题出现时情况
[oracle@dg2 ~]$ rman target sys/oracle@dg1 auxiliary sys/oracle@dg2

Recovery Manager: Release 11.2.0.4.0 - Production on Sat Dec 27 19:59:27 2014

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: MDCS (DBID=3854523219)
connected to auxiliary database: MDCS (not mounted)

RMAN> duplicate target database for standby nofilenamecheck from active database;

Starting Duplicate Db at 27-DEC-14
using channel ORA_AUX_DISK_1

contents of Memory Script:
{
   backup as copy reuse
   targetfile  '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/orapwmdcs' auxiliary format
'/u01/app/oracle/product/11.2.0/dbhome_1/dbs/orapwmdcs'   ;
}
executing Memory Script

Starting backup at 27-DEC-14
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 12/27/2014 06:45:27
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 12/27/2014 06:45:27
ORA-17629: Cannot connect to the remote database server
ORA-17627: ORA-12528: TNS:listener: all appropriate instances are blocking new connections
ORA-17629: Cannot connect to the remote database server

10.3.21.4数据库状态
SQL> startup nomount;
ORACLE instance started.

Total System Global Area 2939596800 bytes
Fixed Size                  2256872 bytes
Variable Size             687865880 bytes
Database Buffers         2231369728 bytes
Redo Buffers               18104320 bytes
SQL> show parameter name

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
cell_offloadgroup_name               string
db_file_name_convert                 string
db_name                              string      mdcs
db_unique_name                       string      dg2
global_names                         boolean     FALSE
instance_name                        string      mdcs
lock_name_space                      string
log_file_name_convert                string
processor_group_name                 string
service_names                        string      dg2

10.3.21.3 数据库状态
SQL> startup
ORACLE instance started.

Total System Global Area 2939596800 bytes
Fixed Size                  2256872 bytes
Variable Size             687865880 bytes
Database Buffers         2231369728 bytes
Redo Buffers               18104320 bytes
Database mounted.
Database opened.
SQL> show parameter name

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
cell_offloadgroup_name               string
db_file_name_convert                 string
db_name                              string      mdcs
db_unique_name                       string      dg1
global_names                         boolean     FALSE
instance_name                        string      mdcs
lock_name_space                      string
log_file_name_convert                string
processor_group_name                 string
service_names                        string      dg1

监听器
10.3.21.4的监听器
[oracle@dg2 admin]$ more listener.ora
#listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.3.21.4)(PORT = 1521))
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = mdcs)
      (ORACLE_HOME =/u01/app/oracle/product/11.2.0/dbhome_1)
      (SID_NAME = mdcs)
    )
  )

ADR_BASE_LISTENER = /u01/app/oracle
状态
[oracle@dg2 admin]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 27-DEC-2014 07:02:27

Copyright (c) 1991, 2013, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date                27-DEC-2014 06:59:50
Uptime                    0 days 0 hr. 2 min. 36 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/dg2/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.3.21.4)(PORT=1521)))
Services Summary...
Service "dg2" has 2 instance(s).
  Instance "dg2", statusBLOCKED, has 1 handler(s) for this service...
  Instance "mdcs", status BLOCKED, has 1 handler(s) for this service...
Service "mdcs" has 1 instance(s).
  Instance "mdcs", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
10.3.21.3的监听器
[oracle@mdcs admin]$ more listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.3.21.3)(PORT = 1521))
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = mdcs)
      (ORACLE_HOME =/u01/app/oracle/product/11.2.0/dbhome_1)
      (SID_NAME = mdcs)
    )
  )

ADR_BASE_LISTENER = /u01/app/oracle
状态
[oracle@mdcs admin]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 27-DEC-2014 06:58:51

Copyright (c) 1991, 2013, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date                27-DEC-2014 02:11:44
Uptime                    0 days 4 hr. 47 min. 6 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/mdcs/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=mdcs)(PORT=1521)))
Services Summary...
Service "dg1" has 1 instance(s).
  Instance "mdcs", status READY, has 1 handler(s) for this service...
Service "mdcs" has 1 instance(s).
  Instance "mdcs", status UNKNOWN, has 1 handler(s) for this service...
Service "mdcsXDB" has 1 instance(s).
  Instance "mdcs", status READY, has 1 handler(s) for this service...
The command completed successfully

请大牛们指点下，问题出在哪了？如还需要提供其它的信息可以留言告诉我！谢谢了哦！

乌鲁木齐-小小

Maclean Liu(刘相兵 发表于 2014-12-29 18:58
你这配置的挺乱

能按照这个来做吗：http://t.askmaclean.com/thread-2530-1-1.html

duplicate target database for standby nofilenamecheck from active database;
duplicate target database for standby nofilenamecheck from active database nocatalog;
在我使用第二句后，执行成功了，但是我想知道我的两个库都没有恢复编录，但是第二句为什么会成功，以及第一句为什么会报错？

乌鲁木齐-小小

Maclean Liu(刘相兵 发表于 2014-12-29 18:58
你这配置的挺乱

能按照这个来做吗：http://t.askmaclean.com/thread-2530-1-1.html

谢谢maclean,已解决！

Maclean Liu(刘相兵

你这配置的挺乱

能按照这个来做吗：http://t.askmaclean.com/thread-2530-1-1.html