How to Setup Data Guard Physical Standby in Oracle Database 18c

This post applies to 12c and 19c as well, it introduced two popular ways for creating a standby database: RMAN DUPLICATE and from primary database backup

Introduction

This post demonstrates how to build an Oracle 18c physical standby database managed by data guard.  The method should also apply to 12c and 19c as well.

Subscribe to get access

Read more of this content when you subscribe today.

DUPLICATE FROM ACTIVE DATABASE Fails With RMAN-03009 ORA-17628 ORA-19505

While creating a new physical standby database by using RMAN duplicate command, the following errors occur:

RMAN> run {
allocate channel prim1 type disk;
allocate channel prim2 type disk;
allocate auxiliary channel standby1 type disk;
DUPLICATE TARGET DATABASE
FOR STANDBY
FROM ACTIVE DATABASE
...
..
.
RMAN-03009: failure of backup command on prim2 channel 
ORA-17628: Oracle error 19505 returned by remote Oracle server
ORA-19505: failed to identify file ""

SOLUTION

  1. Check and remove the old standby database data files.
  2. Make sure directories for standby database data files created and accessible.

How to Uninstall OEM 13c Old OMS Home

Firstly uninstall Oracle Management Agent by referring to post How to Deinstall OEM Agents in Oracle Enterprise Manager 13C

After OMS central agent is uninstalled, now it is time to deinstall OMS home:

Subscribe to get access

Read more of this content when you subscribe today.

How to Upgrade Oracle Enterprise Manager 13c Release 4

How to Upgrade Oracle Management Agents Using Agent Gold Images

This post demonstrates how to upgrade Oracle management agents by using agent gold images. Also provides two ways of upgrading agents. The first one is by using OEM GUI , and the second method is by using EM CLI.

Contents

Subscribe to get access

Read more of this content when you subscribe today.