oracle@rac3:/opt/oracle/11.2.0/yangdb/dbs>rman target sys/yang402@rac auxiliary /
Starting Duplicate Db at 08-SEP-11
released channel: c1
released channel: s1
released channel: s2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 09/08/2011 11:22:40
RMAN-06217: not connected to auxiliary yangdb with a net service name
如错误提示::未使用Net服务名连接到辅助数据库,
解决方法:通过连接服务名的方式连接辅助实例即可,使用
rman target sys/yang402@rac auxiliary sys/yang402@yangdb
oracle@rac3:/opt/oracle/11.2.0/yangdb/dbs>rman target sys/yang402@rac auxiliary sys/yang402@yangdb
Recovery Manager: Release 11.2.0.1.0 - Production on Thu Sep 8 11:42:32 2011
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target yangdb: RAC (DBID=2349052205)
connected to auxiliary yangdb: RAC (not mounted)
RMAN> run {
2> allocate channel c1 type disk;
3> allocate auxiliary channel s1 type disk;
4> allocate auxiliary channel s2 type disk;
5> sql channel c1 "alter system archive log current";
6> duplicate target yangdb for standby from active yangdb
7> DB_FILE_NAME_CONVERT=('+DATA1','/opt/oracle/oradata/yangdb')
8> spfile
9> set db_name='rac'
10> set db_unique_name='yangdb'
11> set cluster_yangdb='FALSE'
12> set audit_file_dest='/opt/oracle/admin/yangdb/adump'
13> set DB_CREATE_FILE_DEST='/opt/oracle/oradata/yangdb'
14> set control_files='/opt/oracle/oradata/yangdb/control01.ctl','/opt/oracle/oradata/yangdb/control02.ctl','/opt/oracle/oradata/yangdb/control03.ctl'
15> set undo_tablespace='UNDOTBS1'
16> set service_names='yangdb'
17> set standby_file_management='AUTO'
18> set log_archive_config='DG_CONFIG=(rac,yangdb)'
19> set log_archive_dest_1='LOCATION=/opt/oracle/arch'
20> set log_archive_dest_2='service=rac ARCH ASYNC valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE) db_unique_name=rac'
21> set log_archive_dest_state_1='enable'
22> set log_archive_dest_state_2='enable'
23> set log_archive_format='yangdb%t_%s_%r.log'
24> set remote_login_passwordfile='exclusive'
25> set LOG_FILE_NAME_CONVERT='+DATA1','/opt/oracle/oradata/alibank'
26> set fal_client='yangdb'
27> set fal_server='rac'
28> NOFILENAMECHECK;
29> sql channel c1 "alter system archive log current";
30> }
using target yangdb control file instead of recovery catalog
allocated channel: c1
channel c1: SID=61 instance=rac2 device type=DISK
allocated channel: s1
channel s1: SID=18 device type=DISK
allocated channel: s2
channel s2: SID=17 device type=DISK
sql statement: alter system archive log current
Starting Duplicate Db at 08-SEP-11
contents of Memory Script.:
{
backup as copy reuse
targetfile '/opt/rac/oracle/11.2.0/db/dbs/orapwrac2' auxiliary format
'/opt/oracle/11.2.0/yangdb/dbs/orapwyangdb' targetfile
'+DATA1/rac/spfilerac.ora' auxiliary format
'/opt/oracle/11.2.0/yangdb/dbs/spfileyangdb.ora' ;
sql clone "alter system set spfile= ''/opt/oracle/11.2.0/yangdb/dbs/spfileyangdb.ora''";
}
executing Memory Script
Starting backup at 08-SEP-11
RMAN-03009: failure of backup command on c1 channel at 09/08/2011 11:43:03
ORA-17629: Cannot connect to the remote yangdb server
ORA-17627: ORA-12154: TNS:could not resolve the connect identifier specified
ORA-17629: Cannot connect to the remote yangdb server
continuing other job steps, job failed will not be re-run
released channel: c1
released channel: s1
released channel: s2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 09/08/2011 11:43:04
RMAN-03015: error occurred in stored script. Memory Script
RMAN-03009: failure of backup command on c1 channel at 09/08/2011 11:43:04
ORA-17629: Cannot connect to the remote yangdb server
ORA-17627: ORA-12154: TNS:could not resolve the connect identifier specified
ORA-17629: Cannot connect to the remote yangdb server
RMAN> exit
在备库上:
由于备库在创建的时候是nomount状态的,服务为注册!
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=rac3)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 08-SEP-2011 11:42:07
Uptime 0 days 0 hr. 14 min. 1 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /opt/oracle/11.2.0/alifpre/network/admin/listener.ora
Listener Log File /opt/oracle/diag/tnslsnr/rac3/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rac3)(PORT=1521)))
Services Summary...
Service "alifpre" has 1 instance(s).
Instance "alifpre", status UNKNOWN, has 1 handler(s) for this service...
Service "rac" has 1 instance(s).
Instance "alifpre", status BLOCKED, has 1 handler(s) for this service...
The command completed successfully
必须在listener.ora中配置静态监听:
如上面显示的blocked 状态!
oracle@rac3:/opt/oracle/11.2.0/alifpre/network/admin>cat listener.ora
# listener.ora Network Configuration File: /opt/oracle/11.2.0/alifpre/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /opt/oracle/11.2.0/alifpre)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = alifpre)
(ORACLE_HOME = /opt/oracle/11.2.0/alifpre)
(SID_NAME = alifpre)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac3)(PORT = 1521))
)
)
ADR_BASE_LISTENER = /opt/oracle
oracle@rac3:/opt/oracle/11.2.0/alifpre/network/admin>lsnrctl reload
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 09-SEP-2011 22:44:24
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
The command completed successfully
oracle@rac3:/opt/oracle/11.2.0/alifpre/network/admin>lsnrctl status
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 09-SEP-2011 22:44:33
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 08-SEP-2011 13:18:24
Uptime 1 days 9 hr. 26 min. 9 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /opt/oracle/11.2.0/alifpre/network/admin/listener.ora
Listener Log File /opt/oracle/diag/tnslsnr/rac3/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rac3)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "alifpre" has 2 instance(s).
Instance "alifpre", status UNKNOWN, has 1 handler(s) for this service...
Instance "alifpre", status READY, has 1 handler(s) for this service...
The command completed successfully
oracle@rac3:/opt/oracle/11.2.0/alifpre/network/admin>
后续。。