Category: Premium Content

Create Physical Standby Database from Active Database in 12c

Subscribe to get access

Read more of this content when you subscribe today.

Subscribe

Create Standby Database From Active Database Duplication in 11gR2

Subscribe to get access

Read more of this content when you subscribe today.

Subscribe

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.

Subscribe

ORA-17628 RMAN-03009 duplicate target database for standby from active database

While run RMAN “duplicate target database for standby from active database nofilenamecheck” in 11g database, then got below errors:

...
..
.
set newname for datafile 3 to "/u02/oradata/TESTDBSTY/undotbs01.dbf";
...
..
.
channel ORA_DISK_1: starting datafile copy
input datafile file number=00003 name=/u02/oradata/TESTDB/undotbs01.dbf
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 01/15/2019 15:53:17
ORA-17628: Oracle error 19505 returned by remote Oracle server
continuing other job steps, job failed will not be re-run
...
..
.

Subscribe to get access

Read more of this content when you subscribe today.

Subscribe

SQL*Net message from client

A client asked about why it takes 14.96 seconds for below sql(1):

SQL>select * from dba_tables;
Elapsed: 00:00:14.96

While it takes only 0.59 second for this sql(2):

SQL>select count(*) from dba_tables;
Elapsed: 00:00:00.59

Let’s compare the tkprof summary from sql tracing for those two sqls:

Subscribe to get access

Read more of this content when you subscribe today.

Subscribe