Home » Server Options » Data Guard » Standby database creation (Primary db RACOnenode) standby db in single instance db having asm disk (Oracle 12c, RHEL 5.9 64bit)
Standby database creation (Primary db RACOnenode) standby db in single instance db having asm disk [message #654006] Mon, 25 July 2016 04:11 Go to previous message
morad_dba
Messages: 93
Registered: June 2008
Member
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

 
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: No of archivelog generation between the period in RAC envirnoment
Next Topic: Service Name in Data Guard
Goto Forum:
  


Current Time: Fri Mar 29 09:33:31 CDT 2024