How to Enable and Configure Oracle Data Guard (Training Guide)

 Introduction

Oracle Data Guard provides a disaster recovery solution. In this guide, we’ll explain how to enable a standby database for training purposes.

Steps:

1. Enable Archivelog Mode

SHUTDOWN IMMEDIATE;

STARTUP MOUNT;

ALTER DATABASE ARCHIVELOG;

ALTER DATABASE OPEN;

2. Create Standby Database

Use RMAN duplicate or manual backup copy.

3. Configure Listener on Standby

Edit listener.ora with a new port.

4. Configure tnsnames.ora

Ensure primary and standby databases can connect to each other.

5. Test Data Guard Switchover

ALTER DATABASE COMMIT TO SWITCHOVER TO STANDBY;

Conclusion

Even for training, Data Guard is important to understand disaster recovery.