Convert Physical Standby into Logical Standby | Oracle 12c Data Guard

Logical Standby Database. A logical #standby mines the primary #database redo and reconstructs the higher level #SQL operations that resulted in the database change, and then applies these SQL statements to maintain the standby database. The benefits to using a logical standby is that. It can be open for reads.

00:00 Convert Physical Standby into Logical Standby
02:11 Primary changes
03:07 Retrieve the list of objects that are not support
03:40 Check the Reason behind the un-supported object
04:49 Identify un-supported schemas on primary
06:03 All the records in primary database uniquely identify
09:27 Stop Redo apply
12:18 Build Log miner directory on primary
18:47 Open physical standby
26:43 Data Guard Broker changes
27:29 Removes the earlier physical standby from Broker
29:09 Start Logical Apply Service on standby server
29:52 Add the new logical standby to the broker
31:07 Verify logical standby
31:48 Check the LSP process at OS level
32:28 Check if logical standby is applying the transaction