Forum Stats

  • 3,759,874 Users
  • 2,251,609 Discussions
  • 7,870,852 Comments

Discussions

DB Duplication - Primary DB Status is incorrect in RMAN

Jhil
Jhil Member Posts: 3,171 Bronze Trophy

Dear Experts,

I am trying to configure Physical Standby on my Local machine.

When i connected to target and auxiliary server i am getting both database are not mounted.

Actually primary DB already opened and running fine.


Primary DB server

$ hostname -i

192.168.157.5

SQL> select name, db_unique_name, status from v$database, v$instance;

NAME  DB_UNIQUE_NAME STATUS

--------- ------------------------------ ------------

CRMS  crms OPEN


Physical Standby Configuration :

$ hostname -i

192.168.157.7


[[email protected] ~]$ cd $ORACLE_HOME/network/admin

[[email protected] admin]$ cat tnsnames.ora 

# tnsnames.ora Network Configuration File: /u01/app/oracle/product/12.2.0/db_home/network/admin/tnsnames.ora

# Generated by Oracle configuration tools.


STBY_CRMSDB =

 (DESCRIPTION =

 (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.157.7)(PORT = 1521))

 (CONNECT_DATA =

  (SERVER = DEDICATED)

  (SERVICE_NAME = stbycrms)

  (UR=A)

 )

 )


CRMSDB =

 (DESCRIPTION =

 (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.157.5)(PORT = 1521))

 (CONNECT_DATA =

  (SERVER = DEDICATED)

  (SERVICE_NAME = crms)

  (UR=A) 

 )

 )

[[email protected] ~]$ . oraenv

ORACLE_SID = [stbycrms] ? 

The Oracle base remains unchanged with value /u01/app/oracle

[[email protected] ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Sun Apr 18 22:03:23 2021

Copyright (c) 1982, 2016, Oracle. All rights reserved.

Connected to:

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> select instance_name, status from v$instance;

INSTANCE_NAME STATUS

---------------- ------------

stbycrms STARTED


Connecting both Databases from Physical Standby Server

[[email protected] ~]$ rman target sys/Orclcts12#[email protected] auxiliary sys/Orclcts12#[email protected]_CRMSDB

Recovery Manager: Release 12.2.0.1.0 - Production on Sun Apr 18 22:04:13 2021

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

connected to target database: CRMS (not mounted)

connected to auxiliary database: CRMS (not mounted)

Thanks

Answers