ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 【RAC】Creating a filesystem physical standby from ASM (RAC ) primary 之二

【RAC】Creating a filesystem physical standby from ASM (RAC ) primary 之二

原创 Linux操作系统 作者:杨奇龙 时间:2011-09-09 22:35:01 0 删除 编辑
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>
后续。。

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

请登录后发表评论 登录
全部评论
MySQL DBA NoSQL DEVOPS

注册时间:2009-10-07

  • 博文量
    1026
  • 访问量
    7701951