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 next 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

Re: Standby database creation (Primary db RACOnenode) standby db in single instance db having asm disk [message #654025 is a reply to message #654006] Mon, 25 July 2016 09:08 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Did you also setup the network requirements? Hard coded entry in listener.ora and tnsnames.ora?
If so, first check if you can talk/ping to standby instance/listener from primary as sysdba.
Re: Standby database creation (Primary db RACOnenode) standby db in single instance db having asm disk [message #654026 is a reply to message #654025] Mon, 25 July 2016 10:05 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
> connected to auxiliary database (not started)
> RMAN-04014: startup failed: ORA-01031: insufficient privileges

RMAN cannot start the instance. Ensure that the environment is correctly set and that the 'oracle' user belongs to the 'dba' group. Also try to start it manually (startup nomount).

Re: Standby database creation (Primary db RACOnenode) standby db in single instance db having asm disk [message #654040 is a reply to message #654026] Tue, 26 July 2016 04:28 Go to previous messageGo to next message
morad_dba
Messages: 93
Registered: June 2008
Member

Dear Frank Naude ,

Oracle user attribute in Primary db and standby db are as follows

Oracle user in Primary db
==================
[oracle@node1 trace]$ id oracle
uid=1101(oracle) gid=1000(oinstall) groups=1000(oinstall),1201(asmdba),1300(dba),1301(oper)
[oracle@node1 trace]$


Oracle user in Standby db
==========================
[oracle@drnode dbs]$ id oracle
uid=1101(oracle) gid=1000(oinstall) groups=1000(oinstall),1300(dba),1201(asmdba),1301(oper) context=user_u:system_r:unconfined_t
[oracle@drnode dbs]$


Dear Frank, During Standby database creation by RMAN session, is there any way to start the standby instance in nomount mode manually..... ? We know that we start standby instance in nomount mode before start of database duplication by RMAN.

For idea, i am sharing the following info as :

Standby site listener file:

[grid@drnode admin]$ pwd
/u01/app/12.1.0/grid/network/admin
[grid@drnode admin]$ cat listener.ora
# listener.ora Network Configuration File: /u01/app/12.1.0/grid/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = drnode)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON              # line added by Agent
VALID_NODE_CHECKING_REGISTRATION_LISTENER=SUBNET                # line added by Agent


SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = sprod)
      (ORACLE_HOME = /u01/app/12.1.0/grid/)
      (SID_NAME = sprod)
    )
  )
[grid@drnode admin]$


Listener status in standby db
===================

[grid@drnode admin]$ lsnrctl status

LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 27-JUL-2016 08:13:26

Copyright (c) 1991, 2014, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=drnode)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 12.1.0.2.0 - Production
Start Date                25-JUL-2016 11:03:12
Uptime                    1 days 21 hr. 10 min. 14 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/12.1.0/grid/network/admin/listener.ora
Listener Log File         /u01/app/grid/diag/tnslsnr/drnode/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=drnode)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=drnode)(PORT=5500))(Security=(my_wallet_directory=/u01/app/oracle/product/12.1.0/dbhome_1/admin/pbl/xdb_wallet))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "+ASM" has 1 instance(s).
  Instance "+ASM", status READY, has 1 handler(s) for this service...
Service "sprod" has 1 instance(s).
  Instance "sprod", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
[grid@drnode admin]$


As standby db is in nomount mode so sprod status is UNKNOWN is lsnrctl status output.

RMAN session can login to standby database instance (as we see in output) and copy spfilesprod.ora file in $ORACLE_HOME/dbs/ directory and shutdown the standby db instance. But RMAN can not start it.

I performed oracle data guard configuration (Physical and logical) in 11g several times.

But here 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.

Looking for help.

Regards,
Morad.


Re: Standby database creation (Primary db RACOnenode) standby db in single instance db having asm disk [message #654047 is a reply to message #654040] Tue, 26 July 2016 06:20 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
 (ORACLE_HOME = /u01/app/12.1.0/grid/)
      (SID_NAME = sprod)

Your listener is looking into GRID home. Not database home. You restored your password file to Database home.
You have issues with environment.

[Updated on: Tue, 26 July 2016 06:21]

Report message to a moderator

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


Current Time: Thu Mar 28 10:15:19 CDT 2024