Hi,
We are in process to configure dataguard between primary and standby database . Dataguard has been already configured and redo data is being synced from primary to standby without any problem. However we are facing one weird problem during conversion of our standby database into snapshot standby. We are using dgbroker to convert the physical standby to snapshot. The dgbroker configuration and other details related to each database are showing error free. But it gets stuck whenever try to convert into snapshot standby.
C:\Windows\system32>dgmgrl sys/password@orcl
DGMGRL> show configuration
Configuration - my_dg_config
Protection Mode: MaxPerformance
Members:
orcl - Primary database
orcldr - Physical standby database
Fast-Start Failover: Disabled
Configuration Status:
SUCCESS (status updated 36 seconds ago)
DGMGRL> convert database 'orcldr' to snapshot standby;
Converting database "orcldr" to a Snapshot Standby database, please wait...
Env details: Windows server 2022
DB version: Oracle 19.27
Alert log of standby db during conversion:-
alter database convert to snapshot standby
2025-06-25T10:27:52.100850+03:00
Drop guaranteed restore point
Guaranteed restore point dropped
Created guaranteed restore point SNAPSHOT_STANDBY_REQUIRED_06/25/2025 10:27:52
RSM0 (PID:13508): Killing 1 processes (PIDS:15336) (all RFS) in order to disallow current and future RFS connections. Requested by OS process 13508
2025-06-25T10:27:52.350651+03:00
RSM0 (PID:13508): DBROLE: Converted to a SNAPSHOT at [kcvs.c:3388]
RSM0 (PID:13508): Begin: SRL archival
Anyone faced such issue , or any help would be very helpful.
Note: Database change tracking is not enabled in primary database .