Browsed by
Tag: Active Data Guard

Automatic block media recovery to the rescue

Automatic block media recovery to the rescue

As pointed out earlier, Oracle Active Data Guard (ADG) is a lot more than just the read-only standby database. One of the technologies no other product beats us on in regards to disaster recovery is the automatic block media recovery, which is part of the Active Data Guard license. This gets automatically enabled when you open the standby database read-only with redo apply enabled. You do not need to do something specific for it, it is just there. In spite…

Read More Read More

AWR on ADG

AWR on ADG

Active Data Guard is a lot more than the read-only standby database. Let’s focus on this part a bit. Read-only workloads are select workloads and are just queries. Working on a read-only database where redo apply is running results in a complex mechanism of keeping data up to date and combining it with user queries. From time to time, you can’t help but question the performance of the queries or how the overall standby database is performing. What could possibly…

Read More Read More

DBMS_ROLLING explained

DBMS_ROLLING explained

Active Data Guard is more than just the Read-Only Standby database. Together with your Active Data Guard license comes the “Rolling Upgrade using Active Data Guard” Feature, better known as DBMS_ROLLING. If you search this blog for Transient logical standby, you can find it here. But DBMS_ROLLING is way easier. The principle remains the same: Create the guaranteed restore point Build the logminer dictionary Convert the physical standby to a logical standby Upgrade the logical standby Start the apply again…

Read More Read More

%d bloggers like this: