Subscribe to get access
Read more of this content when you subscribe today.
Blog
Create Standby Database From Active Database Duplication in 11gR2
Subscribe to get access
Read more of this content when you subscribe today.
ORA-16816: incorrect database role
In Data Guard, for some reason, standby database rule are incorrectly shown as primary database, while primary database shows as standby rule.
DGMGRL> show configuration;
Configuration - TESTDB
Protection Mode: MaxPerformance
Databases:
TESTDBSTY - Primary database
Error: ORA-16810: multiple errors or warnings detected
for the database
TESTDB - Physical standby database
Error: ORA-16810: multiple errors or warnings detected
for the database
Fast-Start Failover: DISABLED
Configuration Status:
ERROR
DGMGRL> show database "TESTDBSTY";
Database - TESTDBSTY
Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s): TESTDBSTY
Error: ORA-16782: instance not open for read and write access
Database Error(s):
ORA-16816: incorrect database role
Database Status:
ERROR
How to fix it ?
Subscribe to get access
Read more of this content when you subscribe today.
RMAN-05001: auxiliary file name conflicts with a file used by the target database
In 11g, duplicate a standby database from active database with “RMAN-05001” error:
RMAN> run {
duplicate target database for standby from active database;
}
RMAN-05001: auxiliary file name /u02/oradata/TESTDBSTY/sysaux01.dbf
conflicts with a file used by the target database
WORKAROUND
The issue is a bug, it seems the file system for both primary and standby database are the same, though “db_file_name_convert” and “log_file_name_convert” are configured already.
Add “NOFILENAMECHECK” option into duplicate RMAN command:
RMAN> run
{
duplicate target database for standby
from active database nofilenamecheck;
}
This issue does not happen on 12c, so it seems a bug for 11g.
RMAN-03002 RMAN-05501 RMAN-03015 RMAN-03009 ORA-17629 ORA-17627 ORA-27101 ORA-17629 duplicate target database for standby from active database
In 12c , try to duplicate a standby database with below errors:
channel ORA_DISK_1: SID=158 device type=DISK RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate Db command at 01/15/2019 18:35:32 RMAN-05501: aborting duplication of target database RMAN-03015: error occurred in stored script Memory Script RMAN-03009: failure of backup command on ORA_DISK_1 channel at 01/15/2019 18:35:32 ORA-17629: Cannot connect to the remote database server ORA-17627: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Linux-x86_64 Error: 2: No such file or directory Additional information: 3651 Additional information: -603812709 ORA-17629: Cannot connect to the remote database server
WORKAROUND
In tnsnames.ora of both primary and standby database server, add “(UR = A)” for the standby database entry :
TESTDBSTY = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1521)) (CONNECT_DATA = (SERVICE_NAME = TESTDBSTY)(UR=A)) )
Make DBA Life Easy 