本帖最后由 aiaix 于 2015-8-20 21:24 编辑
本次采用duplicate 来搭建备份库,
[oracle@ccc ~]$ rman target sys/oracle123@RTPAY AUXILIARY sys/oracle123@RTPAYADG
Recovery Manager: Release 11.2.0.4.0 - Production on Thu Aug 20 21:13:23 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: RTPAY (DBID=577985243)
connected to auxiliary database: RTPAY (not mounted)
连接没有问题,
然后 ,就密码错误了,请各位帮忙看看
duplicate target database for standby from active database nofilenamecheck;
Starting backup at 20-AUG-15
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
copying standby control file
output file name=/u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_RTPAY1.f tag=TAG20150820T210631 RECID=19 STAMP=888267992
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 20-AUG-15
Starting restore at 20-AUG-15
using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: copied control file copy
Finished restore at 20-AUG-15
sql statement: create spfile from memory
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 21:06:42
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
RMAN> exit