Data Guard standby database not started

I was creating a new Oracle Data Guard physical standby using RMAN[1]

en español

These are my instances:

Primary: ORADB
Standby: ORADR

I had already

  • copied and renamed the password file from the primary to the standby
  • created the initORADR.ora file with just one entry, db_name=ORADR
  • started the standby using 
    • SQL>startup nomount pfile=$ORACLE_HOME/dbs/initORADR.ora
  • created a listener, LISTENER_ORADR, in the standby (under the database ORACLE_HOME) with an entry for ORADR using static service registration:

 

LISTENER_ORADR =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = standby.test.com)(PORT = 1525))
    )
  )
SID_LIST_LISTENER_ORADR =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = ORADR)
      (ORACLE_HOME = /u01/app/oracle/product/11203/db_1)
      (SID_NAME = ORADR)
    )
  )

 

  • added an entry in the primary’s tnsnames to point to ORADR:

ORADR =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = standby.test.com)(PORT = 1525))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ORADR)
)
)

So, I was ready to duplicate the primary to the standby using RMAN.

I ran the RMAN connection command from the primary server:
$. oraenv
ORADB
$ rman target / auxiliary sys/****@ORADR

Recovery Manager: Release 11.2.0.3.0 – Production on Tue Feb 25 09:31:52 2014

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

connected to target database: ORADB (DBID=9999999999)
connected to auxiliary database (not started)

The (not started) was wrong, it should have been (not mounted) since the standby is in nomount mode.

The problem was this:
The ORACLE_HOME for the standby in the standby server was set to /u01/app/oracle/product/11203/db_1/ with an extra slash ‘/’ at the end.  It was a bad entry in /etc/oratab:
ORADR:/u01/app/oracle/product/11203/db_1/:N
I took the last slash off, resourced the environment (. oraenv).
With the correct ORACLE_HOME, I restarted the standby database (startup nomount pfile).

Now it works:
$ rman target / auxiliary sys/****@ORADR

Recovery Manager: Release 11.2.0.3.0 – Production on Tue Feb 25 09:46:02 2014

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

connected to target database: ORADB (DBID=9999999999)
connected to auxiliary database: ORADR (not mounted)

 

References

Creating a Standby Database with Recovery Manager.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s