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.

ORA-01275: Operation DROP LOGFILE is not allowed

Try to drop standby redo groups and then recreate them,  get below errors:

SQL> alter database drop logfile group 1;
alter database drop logfile group 1
*
ERROR at line 1:
ORA-01275: Operation DROP LOGFILE is not allowed 
           if standby file management is automatic.

Subscribe to get access

Read more of this content when you subscribe today.

Create Physical Standby Database from Active Database in 12c

Subscribe to get access

Read more of this content when you subscribe today.