查看: 4660|回复: 3

[HA] rac dg duplicate db ORA-01017报错

[复制链接]
认证徽章
论坛徽章:
1
优秀写手
日期:2014-03-18 06:00:19
发表于 2014-7-19 19:26 | 显示全部楼层 |阅读模式
本帖最后由 羽化残虹 于 2014-7-19 19:30 编辑

环境是这样的
oracle 版本 11.2.0.4  os  redhat 5.8 64biy
我想做的实验是  11g  单节点rac  dg
hostname   11grac1 primary    asm   单节点 rac 集群   sysdg  dg01  dg02        db_name rac  db_unique_name rac   +ASM1   oracle_sid=rac1
hostname   11grac2 standby  asm    单节点 rac 集群   sysdg data_dg   fra_dg  db_name rac  db_unique_name rac2     +ASM1  oracle_sid=rac2

hosts 文件
192.168.88.21   11grac1   
192.168.88.23   11grac1-vip  
172.168.10.21   11grac1-priv1
172.168.11.21   11grac1-priv2

192.168.88.22  11grac2   
192.168.88.24  11grac2-vip
172.168.10.22  11grac2-priv1
172.168.11.22  11grac2-priv2

192.168.88.25  myscan

11grac1  primary    oracle  tnsnames.ora 如下


RAC =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = myscan)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = rac)
    )
  )







racdg =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.88.22)(PORT = 1522))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = rac)
      (UR = A)
    )
  )


racdb =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.88.23)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = rac)
      (UR = A)
    )
  )

11grac2 oracle  tnsnames.ora 文件如下
racdb =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.88.23)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = rac)
      (UR = A)
    )
  )

racdg =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.88.22)(PORT = 1522))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = rac)
      (UR = A)
    )
  )


standby db 静态监听 listener.ora


SID_LIST_LISTENER=
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = rac)
      (ORACLE_HOME = /g01/11.2.0)
      (SID_NAME = rac2)
    )
  )

listener=
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.88.22)(PORT = 1522))
  )

ADR_BASE_LISTENER = /home/grid

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER = ON

LISTENER_SCAN1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = IPC)(KEY = LISTENER_SCAN1))
  )

ADR_BASE_LISTENER_SCAN1 = /home/grid


11grac2  grid 监听
istener Parameter File   /g01/11.2.0/network/admin/listener.ora
Listener Log File         /home/grid/diag/tnslsnr/11grac2/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.88.24)(PORT=1522)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.88.22)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.88.24)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
  Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "rac" has 1 instance(s).
  Instance "rac2", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfull

在备库上测试主库 oracle连通性
[oracle@11grac2 ~]$
[oracle@11grac2 ~]$ sqlplus sys/oracle@racdb as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Sat Jul 19 18:45:54 2014

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL>
可以正常连接到主库

在主库上测试连接备库 备库 实例手动pfile 启动的nomount状态下 主库是可以正常连接到备库
备库测试主库也是可以正常连接

[oracle@11grac1 admin]$ sqlplus sys/oracle@racdg as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Sat Jul 19 19:02:11 2014

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> select status ,instance_name from gv$instance;

STATUS                   INSTANCE_NAME
------------------------ --------------------------------
STARTED                  rac2



下面开始duplicate

SQL> startup nomount pfile='/s01/oracle/product/11.2.0/dbs/dgsty_pfile.ora'
ORACLE instance started.

Total System Global Area  814227456 bytes
Fixed Size                  2257640 bytes
Variable Size             591400216 bytes
Database Buffers          218103808 bytes
Redo Buffers                2465792 bytes
SQL> quit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
[oracle@11grac2 admin]$ id
uid=501(oracle) gid=54321(oinstall) groups=5001(asmdba),54321(oinstall),54322(dba)
[oracle@11grac2 admin]$ rman target sys/oracle@racdb auxiliary sys/oracle@racdg

Recovery Manager: Release 11.2.0.4.0 - Production on Sat Jul 19 19:14:17 2014

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

connected to target database: RAC (DBID=2441266579)
connected to auxiliary database: RAC (not mounted)



RMAN> run {
2> allocate channel prmy1 device type disk;
allocate channel prmy2 device type disk;
allocate channel prmy3 device type disk;
allocate auxiliary channel stby device type disk;
duplicate target database for standby from active database  nofilenamecheck;
3> 4> 5> 6> 7> }

using target database control file instead of recovery catalog
allocated channel: prmy1
channel prmy1: SID=19 instance=rac1 device type=DISK

allocated channel: prmy2
channel prmy2: SID=28 instance=rac1 device type=DISK

allocated channel: prmy3
channel prmy3: SID=158 instance=rac1 device type=DISK

allocated channel: stby
channel stby: SID=29 instance=rac2 device type=DISK

Starting Duplicate Db at 2014-07-19 11:00:09

contents of Memory Script:
{
   backup as copy reuse
   targetfile  '/s01/oracle/product/11.2.0/dbs/orapwrac1' auxiliary format
'/s01/oracle/product/11.2.0/dbs/orapwrac2'   ;
}
executing Memory Script

Starting backup at 2014-07-19 11:00:10
Finished backup at 2014-07-19 11:00:16

contents of Memory Script:
{
   backup as copy current controlfile for standby auxiliary format  '+DATA_DG/rac/controlfile/current.256.853326021';
   restore clone controlfile to  '+FRA_DG/rac/controlfile/current.256.853326023' from
'+DATA_DG/rac/controlfile/current.256.853326021';
   sql clone "create spfile from memory";
   shutdown clone immediate;
   startup clone nomount;
   sql clone "alter system set  control_files =
  ''+DATA_DG/rac/controlfile/current.256.853326021'', ''+FRA_DG/rac/controlfile/current.256.853326023'' comment=
''Set by RMAN'' scope=spfile";
   shutdown clone immediate;
   startup clone nomount;
}
executing Memory Script

Starting backup at 2014-07-19 11:00:28
channel prmy1: starting datafile copy
copying standby control file
output file name=/s01/oracle/product/11.2.0/dbs/snapcf_rac1.f tag=TAG20140719T110029 RECID=1 STAMP=853326071
channel prmy1: datafile copy complete, elapsed time: 00:00:36
Finished backup at 2014-07-19 11:01:37

Starting restore at 2014-07-19 11:01:38

channel stby: copied control file copy
Finished restore at 2014-07-19 11:01:43

sql statement: create spfile from memory

Oracle instance shut down

released channel: prmy1
released channel: prmy2
released channel: prmy3
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 07/19/2014 11:01:57
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-04006: error from auxiliary database: ORA-01017: invalid username/password; logon denied

查看备库oracle alert 日志

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options.
ORACLE_HOME = /s01/oracle/product/11.2.0
System name:    Linux
Node name:      11grac2
Release:        2.6.32-200.13.1.el5uek
Version:        #1 SMP Wed Jul 27 21:02:33 EDT 2011
Machine:        x86_64
Using parameter settings in client-side pfile /s01/oracle/product/11.2.0/dbs/dgsty_pfile.ora on machine 11grac2
System parameters with non-default values:
  processes                = 150
  memory_target            = 780M
  control_files            = "+DATA_DG/rac/controlfile/current.261.853284563"
  control_files            = "+FRA_DG/rac/controlfile/current.256.853284565"
  db_file_name_convert     = "+DATA_DG/rac/datafile"
  db_file_name_convert     = "+DG01/rac/datafile"
  db_file_name_convert     = "+FRA_DG/rac/datafile"
  db_file_name_convert     = "+DG02/rac/datafile"
  log_file_name_convert    = "+DATA_DG/rac/onlinelog"
  log_file_name_convert    = "+DG01/rac/onlinelog"
  log_file_name_convert    = "+FRA_DG/rac/onlinelog"
  log_file_name_convert    = "+DG02/rac/onlinelog"
  db_block_size            = 8192
  compatible               = "11.2.0.4.0"
  log_archive_dest_1       = "LOCATION=+FRA_DG VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=rac2"
  log_archive_dest_2       = "SERVICE=racdb ASYNC LGWR VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=rac"
  fal_client               = "RACDG"
  fal_server               = "RACDB"
  log_archive_config       = "DG_CONFIG=(rac,rac2)"
  cluster_database         = TRUE
  db_create_file_dest      = "+DATA_DG"
  db_recovery_file_dest    = "+FRA_DG"
  db_recovery_file_dest_size= 4182M
  standby_file_management  = "AUTO"
  thread                   = 1
  undo_tablespace          = "UNDOTBS1"
  instance_number          = 1
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=racXDB)"
  remote_listener          = "dgscan:1521"
  audit_file_dest          = "/s01/oracle/admin/rac/adump"
  audit_trail              = "DB"
  db_name                  = "rac"
  open_cursors             = 300
  diagnostic_dest          = "/s01/oracle"
Cluster communication is configured to use the following interface(s) for this instance
  169.254.121.124
  169.254.200.144
cluster interconnect IPC version:Oracle UDP/IP (generic)
IPC Vendor 1 proto 2
Sat Jul 19 19:00:57 2014
PMON started with pid=2, OS id=10442
Sat Jul 19 19:00:57 2014
PSP0 started with pid=3, OS id=10446
Sat Jul 19 19:00:58 2014
VKTM started with pid=4, OS id=10450 at elevated priority
VKTM running at (1)millisec precision with DBRM quantum (100)ms
Sat Jul 19 19:00:58 2014
GEN0 started with pid=5, OS id=10456
Sat Jul 19 19:00:59 2014
DIAG started with pid=6, OS id=10460
Sat Jul 19 19:01:00 2014
DBRM started with pid=7, OS id=10464
Sat Jul 19 19:01:00 2014
PING started with pid=8, OS id=10469
Sat Jul 19 19:01:00 2014
ACMS started with pid=9, OS id=10473
Sat Jul 19 19:01:00 2014
DIA0 started with pid=10, OS id=10477
Sat Jul 19 19:01:01 2014
LMON started with pid=11, OS id=10481
Sat Jul 19 19:01:01 2014
LMD0 started with pid=12, OS id=10485
* Load Monitor used for high load check
* New Low - High Load Threshold Range = [960 - 1280]
Sat Jul 19 19:01:02 2014
LMS0 started with pid=13, OS id=10491 at elevated priority
Sat Jul 19 19:01:02 2014
RMS0 started with pid=14, OS id=10503
Sat Jul 19 19:01:03 2014
LMHB started with pid=15, OS id=10507
Sat Jul 19 19:01:03 2014
MMAN started with pid=16, OS id=10511
Sat Jul 19 19:01:03 2014
DBW0 started with pid=17, OS id=10515
Sat Jul 19 19:01:03 2014
LGWR started with pid=18, OS id=10519
Sat Jul 19 19:01:04 2014
CKPT started with pid=19, OS id=10523
Sat Jul 19 19:01:04 2014
SMON started with pid=20, OS id=10527
Sat Jul 19 19:01:04 2014
RECO started with pid=21, OS id=10531
Sat Jul 19 19:01:04 2014
RBAL started with pid=22, OS id=10535
Sat Jul 19 19:01:05 2014
ASMB started with pid=23, OS id=10539
Sat Jul 19 19:01:05 2014
MMON started with pid=24, OS id=10543
Sat Jul 19 19:01:05 2014
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Sat Jul 19 19:01:05 2014
MMNL started with pid=25, OS id=10547
starting up 1 shared server(s) ...
lmon registered with NM - instance number 1 (internal mem no 0)
NOTE: initiating MARK startup
Starting background process MARK
Sat Jul 19 19:01:07 2014
MARK started with pid=28, OS id=10563
NOTE: MARK has subscribed
Reconfiguration started (old inc 0, new inc 2)
List of instances:
1 (myinst: 1)
Global Resource Directory frozen
* allocate domain 0, invalid = TRUE
Communication channels reestablished
Master broadcasted resource hash value bitmaps
Non-local Process blocks cleaned out
LMS 0: 0 GCS shadows cancelled, 0 closed, 0 Xw survived
Set master node info
Submitted all remote-enqueue requests
Dwn-cvts replayed, VALBLKs dubious
All grantable enqueues granted
Post SMON to start 1st pass IR
Submitted all GCS remote-cache requests
Post SMON to start 1st pass IR
Fix write in gcs resources
Reconfiguration complete
Sat Jul 19 19:01:09 2014
LCK0 started with pid=31, OS id=10579
Starting background process RSMN
Sat Jul 19 19:01:10 2014
RSMN started with pid=30, OS id=10601
ORACLE_BASE from environment = /s01/oracle
Sat Jul 19 19:02:08 2014
Decreasing number of real time LMS from 1 to 0
Sat Jul 19 19:15:32 2014
NOTE: Loaded library: System
Sat Jul 19 19:15:32 2014
SUCCESS: diskgroup DATA_DG was mounted
SUCCESS: diskgroup FRA_DG was mounted
Sat Jul 19 19:15:37 2014
NOTE: dependency between database rac and diskgroup resource ora.DATA_DG.dg is established
NOTE: dependency between database rac and diskgroup resource ora.FRA_DG.dg is established
Sat Jul 19 19:17:07 2014
Shutting down instance (immediate)
Shutting down instance: further logons disabled
Sat Jul 19 19:17:07 2014
NOTE: Deferred communication with ASM instance
NOTE: deferred map free for map id 11
Stopping background process MMNL
Stopping background process MMON
License high water mark = 8
Sat Jul 19 19:17:09 2014
NOTE: Deferred communication with ASM instance
All dispatchers and shared servers shutdown
alter database close
ORA-1507 signalled during: alter database close...
alter database dismount
ORA-1507 signalled during: alter database dismount...
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Sat Jul 19 19:17:12 2014
Stopping background process VKTM
Sat Jul 19 19:17:13 2014
NOTE: Shutting down MARK background process
Sat Jul 19 19:17:16 2014
freeing rdom 0
Sat Jul 19 19:17:21 2014
Instance shutdown complete


备库 asm alert日志

Sat Jul 19 18:20:28 2014
* allocate domain 1, invalid = TRUE
Sat Jul 19 18:20:28 2014
NOTE: attached to recovery domain 1
Sat Jul 19 18:20:28 2014
NOTE: cache recovered group 1 to fcn 0.622
NOTE: redo buffer size is 256 blocks (1053184 bytes)
Sat Jul 19 18:20:28 2014
NOTE: LGWR attempting to mount thread 1 for diskgroup 1 (DATA_DG)
Process LGWR (pid 4303) is running at high priority QoS for Exadata I/O
NOTE: LGWR found thread 1 closed at ABA 4.58
NOTE: LGWR mounted thread 1 for diskgroup 1 (DATA_DG)
NOTE: LGWR opening thread 1 at fcn 0.622 ABA 5.59
NOTE: cache mounting group 1/0xCD597441 (DATA_DG) succeeded
NOTE: cache ending mount (success) of group DATA_DG number=1 incarn=0xcd597441
NOTE: GMON heartbeating for grp 2
GMON querying group 2 at 7 for pid 22, osid 4384
NOTE: cache opening disk 0 of grp 2: FRA_DG_0000 path:/dev/asm-diskg
NOTE: F1X0 found on disk 0 au 2 fcn 0.0
NOTE: cache mounting (first) external redundancy group 2/0xCD697442 (FRA_DG)
* allocate domain 2, invalid = TRUE
NOTE: attached to recovery domain 2
NOTE: cache recovered group 2 to fcn 0.622
NOTE: redo buffer size is 256 blocks (1053184 bytes)
NOTE: LGWR attempting to mount thread 1 for diskgroup 2 (FRA_DG)
NOTE: LGWR found thread 1 closed at ABA 4.54
NOTE: LGWR mounted thread 1 for diskgroup 2 (FRA_DG)
NOTE: LGWR opening thread 1 at fcn 0.622 ABA 5.55
NOTE: cache mounting group 2/0xCD697442 (FRA_DG) succeeded
NOTE: cache ending mount (success) of group FRA_DG number=2 incarn=0xcd697442
NOTE: GMON heartbeating for grp 3
GMON querying group 3 at 9 for pid 22, osid 4384
NOTE: cache opening disk 0 of grp 3: SYSDG_0000 path:/dev/asm-diskb
NOTE: F1X0 found on disk 0 au 2 fcn 0.0
NOTE: cache opening disk 1 of grp 3: SYSDG_0001 path:/dev/asm-diskc
NOTE: F1X0 found on disk 1 au 2 fcn 0.0
NOTE: cache opening disk 2 of grp 3: SYSDG_0002 path:/dev/asm-diskd
NOTE: F1X0 found on disk 2 au 2 fcn 0.0
NOTE: cache mounting (first) normal redundancy group 3/0xCDE97443 (SYSDG)
* allocate domain 3, invalid = TRUE
NOTE: attached to recovery domain 3
NOTE: cache recovered group 3 to fcn 0.510
NOTE: redo buffer size is 256 blocks (1053184 bytes)
NOTE: LGWR attempting to mount thread 1 for diskgroup 3 (SYSDG)
NOTE: LGWR found thread 1 closed at ABA 5.57
NOTE: LGWR mounted thread 1 for diskgroup 3 (SYSDG)
NOTE: LGWR opening thread 1 at fcn 0.510 ABA 6.58
NOTE: cache mounting group 3/0xCDE97443 (SYSDG) succeeded
NOTE: cache ending mount (success) of group SYSDG number=3 incarn=0xcde97443
Sat Jul 19 18:20:31 2014
NOTE: Instance updated compatible.asm to 11.2.0.0.0 for grp 1
SUCCESS: diskgroup DATA_DG was mounted
NOTE: Instance updated compatible.asm to 11.2.0.0.0 for grp 2
SUCCESS: diskgroup FRA_DG was mounted
NOTE: Instance updated compatible.asm to 11.2.0.0.0 for grp 3
SUCCESS: diskgroup SYSDG was mounted
SUCCESS: ALTER DISKGROUP ALL MOUNT /* asm agent call crs *//* {0:0:2} */
SQL> ALTER DISKGROUP ALL ENABLE VOLUME ALL /* asm agent *//* {0:0:2} */
SUCCESS: ALTER DISKGROUP ALL ENABLE VOLUME ALL /* asm agent *//* {0:0:2} */
Sat Jul 19 18:20:35 2014
WARNING: failed to online diskgroup resource ora.DATA_DG.dg (unable to communicate with CRSD/OHASD)
NOTE: Attempting voting file refresh on diskgroup SYSDG
NOTE: Refresh completed on diskgroup SYSDG
. Found 3 voting file(s).
NOTE: Voting file relocation is required in diskgroup SYSDG
NOTE: Attempting voting file relocation on diskgroup SYSDG
NOTE: Successful voting file relocation on diskgroup SYSDG
WARNING: failed to online diskgroup resource ora.FRA_DG.dg (unable to communicate with CRSD/OHASD)
WARNING: failed to online diskgroup resource ora.SYSDG.dg (unable to communicate with CRSD/OHASD)
Sat Jul 19 18:20:44 2014
NOTE: [crsd.bin@11grac2 (TNS V1-V3) 4397] opening OCR file
Starting background process ASMB
Sat Jul 19 18:20:44 2014
ASMB started with pid=25, OS id=4428
Sat Jul 19 18:20:44 2014
NOTE: client +ASM1:+ASM registered, osid 4433, mbr 0x0
Sat Jul 19 18:22:18 2014
ALTER SYSTEM SET local_listener=' (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.88.24)(PORT=1521))))' SCOPE=MEMORY SID='+ASM1';
Sat Jul 19 19:01:06 2014
NOTE: client rac2:rac registered, osid 10555, mbr 0x1
Sat Jul 19 19:17:14 2014
NOTE: client rac2:rac deregistere



个人不明白的地方就是 首先我的密码文件时从主库上cp过来的,这个肯定没问题,而且我

rman target sys/oracle@racdb auxiliary sys/oracle@racdg都是成功的,除非是duplicate db 的是跑内存脚本 发生了改变,备库的asm状态都是正常的,找不到头绪呢了。。。
请各位大侠指点一下,究竟哪里有问题了。。再次感谢了!
认证徽章
论坛徽章:
1
优秀写手
日期:2014-03-18 06:00:19
发表于 2014-7-19 22:05 | 显示全部楼层
沙发先做一下。。

使用道具 举报

回复
论坛徽章:
8
ITPUB9周年纪念徽章
日期:2010-10-08 09:32:262013年新春福章
日期:2013-02-25 14:51:24ITPUB社区12周年站庆徽章
日期:2013-10-08 14:54:39ITPUB社区12周年站庆徽章
日期:2013-10-08 14:56:08ITPUB社区12周年站庆徽章
日期:2013-10-08 14:59:19宝马
日期:2013-10-30 10:48:172014年新春福章
日期:2014-02-18 16:44:08马上有对象
日期:2014-02-18 16:44:08
发表于 2015-8-20 22:49 | 显示全部楼层
羽化残虹 发表于 2014-7-19 22:05
沙发先做一下。。

我也碰到同样的问题,请问你的解决了吗,我的是2节点RAC+单节点 adg  ,都是ASM .
Oracle instance shut down

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 08/20/2015 17:09:30
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-04006: error from auxiliary database: ORA-01017: invalid username/password; logon denied

使用道具 举报

回复
认证徽章
论坛徽章:
1
优秀写手
日期:2014-03-18 06:00:19
发表于 2015-9-1 20:15 | 显示全部楼层
主库和备库都强制重新写密码文件

使用道具 举报

回复

您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

DTCC2020中国数据库技术大会 限时8.5折

【架构革新 高效可控】2020年6月4日~6日第十一届中国数据库技术大会将在北京隆重召开。

大会设置2大主会场,20+技术专场,将邀请超百位行业专家,重点围绕数据架构、AI与大数据、传统企业数据库实践和国产开源数据库等内容展开分享和探讨,为广大数据领域从业人士提供一场年度盛会和交流平台。

http://dtcc.it168.com


大会官网>>
TOP技术积分榜 社区积分榜 徽章 团队 统计 知识索引树 积分竞拍 文本模式 帮助
  ITPUB首页 | ITPUB论坛 | 数据库技术 | 企业信息化 | 开发技术 | 微软技术 | 软件工程与项目管理 | IBM技术园地 | 行业纵向讨论 | IT招聘 | IT文档
  ChinaUnix | ChinaUnix博客 | ChinaUnix论坛
CopyRight 1999-2011 itpub.net All Right Reserved. 北京盛拓优讯信息技术有限公司版权所有 联系我们 
京ICP备09055130号-4  北京市公安局海淀分局网监中心备案编号:11010802021510 广播电视节目制作经营许可证:编号(京)字第1149号
  
快速回复 返回顶部 返回列表