Next step to convert standby to primary database
Server 1 is the primary database "TrgtX" and Server 2 is the standby database "TrgtY". The two databases have been configured such that the "TrgtX" is primary database and "TrgtY" is standby database. The objective is to use the standby database and test that the standby database works effectively in the event that the primary database is down.
Currently, log shipping from primary to standby is working as expected. My question is how do I turn the standby database to the primary database so that I can sastify my requirement for testing. Is it possible to test this without configuring DGMGRL? Your assistance is appreciated.