Dear all,
I have a 2 node cluster in oracle 12c Grid Infrastructure, Database is RACOneNode. Now i am trying to configure data guard. Standby db is single instance but will have asm file system. I installed 12c GI in standby site.
I completed all preparation. when i use RMAN utility to create stanby db, it returns the following error:
[oracle@node1 oracle]$ rman TARGET SYS/admin@racdb AUXILIARY SYS/admin@sprod
Recovery Manager: Release 12.1.0.2.0 - Production on Tue Jul 26 07:06:54 2016
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
connected to target database: RACDB (DBID=914892245)
connected to auxiliary database: RACDB (not mounted)
RMAN> DUPLICATE TARGET DATABASE FOR STANDBY from active database
2> spfile
3> set db_unique_name='sprod'
4> set log_file_name_convert='+DATA','+DATA'
5> nofilenamecheck;
Starting Duplicate Db at 26-JUL-2016 07:08:17
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=28 device type=DISK
contents of Memory Script:
{
backup as copy reuse
targetfile '+DATA/RACDB/PASSWORD/pwdracdb.256.917275157' auxiliary format
'/u01/app/oracle/product/12.1.0/dbhome_1/dbs/orapwsprod' ;
restore clone from service 'racdb' spfile to
'/u01/app/oracle/product/12.1.0/dbhome_1/dbs/spfilesprod.ora';
sql clone "alter system set spfile= ''/u01/app/oracle/product/12.1.0/dbhome_1/dbs/spfilesprod.ora''";
}
executing Memory Script
Starting backup at 26-JUL-2016 07:08:20
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=55 device type=DISK
Finished backup at 26-JUL-2016 07:08:22
Starting restore at 26-JUL-2016 07:08:22
using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service racdb
channel ORA_AUX_DISK_1: restoring SPFILE
output file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/spfilesprod.ora
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:02
Finished restore at 26-JUL-2016 07:08:25
sql statement: alter system set spfile= ''/u01/app/oracle/product/12.1.0/dbhome_1/dbs/spfilesprod.ora''
contents of Memory Script:
{
sql clone "alter system set db_unique_name =
''sprod'' comment=
'''' scope=spfile";
sql clone "alter system set log_file_name_convert =
''+DATA'', ''+DATA'' comment=
'''' scope=spfile";
shutdown clone immediate;
startup clone nomount;
}
executing Memory Script
sql statement: alter system set db_unique_name = ''sprod'' comment= '''' scope=spfile
sql statement: alter system set log_file_name_convert = ''+DATA'', ''+DATA'' comment= '''' scope=spfile
Oracle instance shut down
connected to auxiliary database (not started)
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
[b]RMAN-03002: failure of Duplicate Db command at 07/26/2016 07:08:50
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-04014: startup failed: ORA-01031: insufficient privileges
[/b]
RMAN>
If it is the issue of password file, I am sharing the info that :
I copied the password file of Primary db to standby db as follows:
[grid@node1 ~]$ asmcmd
ASMCMD> pwcopy +DATA/RACDB/PASSWORD/pwdracdb.256.917275157 /u01/app/oracle/orapwsprod
copying +DATA/RACDB/PASSWORD/pwdracdb.256.917275157 -> /u01/app/oracle/orapwsprod
ASMCMD>
[oracle@node1 oracle]$ scp orapwsprod oracle@192.168.201.72:/u01/app/oracle/product/12.1.0/dbhome_1/dbs/
oracle@192.168.201.72's password: 100% 7680 7.5KB/s 00:00
orapwsprod
Please help me in this regard.
Regards
Morad.
[Updated on: Mon, 25 July 2016 04:14]
Report message to a moderator