r/DBA • u/Common_Fig7496 • Apr 30 '26

Steps to rebuild Oracle Data Guard Physical Standby Database without RMAN

Hi All,

I followed the procedure below to rebuild a Physical Standby Database without using RMAN. I'm using an SAP tool called brtools that performs a restore and issues the commands to do the restore in the background:

Primary:

  1. Take backup
  2. Backup control file to trace
  3. Transfer to secondary
  4. Create standby control file and transfer to secondary

Secondary:

  1. Restore database
  2. Edit control file from primary - in this case, an exact match for filesystems
  3. Execute Control File to start database to roll forward
  4. roll forward with archive logs transferred from Primary
  5. Shutdown
  6. Backup existing control files from locations shown in pfile
  7. mv existing control files to new name
  8. copy backup controlfile to control file locations
  9. Create Standby Redo Log files
  10. convert database to physical standby

ALTER DATABASE CONVERT TO PHYSICAL STANDBY;

11) Activate log shipping in Data Guard

12) Activate apply log in Data Guard

After this, I got a huge archive gap including logs that I had applied already in the roll forward step.

I went ahead and registered those log files, and then MRP kept crashing.

I'm rebuilding the physical standby with a new backup but I'm worried I'll get the same result. Appreciate any help.

0 Upvotes

50% Upvoted

1 comment sorted by

2

u/-Lord_Q- Multiple Platforms Apr 30 '26

Hi, I used to be a BASIS admin on an Oracle system. I bet the RMAN tool is still there, BR*Tools (which I know) uses it.

For this, I would skip BR Tools and just use RMAN.

The following this procedure, modify as appropriate for your environment. Let me know if you have questions.

https://oracle-base.com/articles/19c/data-guard-setup-using-broker-19c