搭建dataguard时复制数据库的orapw文件出错
本帖最后由 乌鲁木齐-小小 于 2014-12-27 12:01 编辑问题出现时情况
$ 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的监听器
$ 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
状态
$ 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的监听器
$ 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
状态
$ 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
请大牛们指点下，问题出在哪了？如还需要提供其它的信息可以留言告诉我！谢谢了哦！ 你这配置的挺乱
能按照这个来做吗：http://t.askmaclean.com/thread-2530-1-1.html Maclean Liu(刘相兵 发表于 2014-12-29 18:58 static/image/common/back.gif
你这配置的挺乱
能按照这个来做吗：http://t.askmaclean.com/thread-2530-1-1.html
谢谢maclean,已解决！ Maclean Liu(刘相兵 发表于 2014-12-29 18:58 static/image/common/back.gif
你这配置的挺乱
能按照这个来做吗：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;
在我使用第二句后，执行成功了，但是我想知道我的两个库都没有恢复编录，但是第二句为什么会成功，以及第一句为什么会报错？
页:
[1]