![Fixing No-logging corruption the easy way [12.2 feature]](https://project42.site/wp-content/uploads/2020/08/nologging-360x240.gif)
I have recently discovered a new way to easily fix nologging corruption in a standby which version is 12.2 or higher. The first thing we need to do for this test is to disable the force logging parameter from our Primary Database db1221 > select name,force_logging from v$database; NAME FORCE_LOGGING ________ ________________ DB122 YES db1221... » read more
![How to enable Multi Instance Redo Apply (MIRA) [12.2 feature]](https://project42.site/wp-content/uploads/2020/08/MIRA_spiderman_meme-1-360x240.jpg)
Since 12.2, Managed Recovery Process (MRP) can be started on multiple instances, making Standby recovery much faster and making easier for the system to be kept on Sync with your Primary Database (Found thanks to this old post: http://jeyaseelan-m.blogspot.com/2018/05/mira-multi-instance-redo-apply-12cr2.html) This new feature is called MIRA (more info in following PDF https://www.oracle.com/technetwork/database/availability/redo-apply-2745943.pdf) The process to enable... » read more
![Rolling Forward a Physical Standby using “Recover From Service” command [12.1 feature]](https://project42.site/wp-content/uploads/2020/08/mind-gap-360x240.jpg)
This is what we can see from the Oracle Doc ID 1987763.1 regarding Recover standby from Service option added in 12.1: Rolling Forward a Physical Standby Using Recover From Service Command in 12c (Doc ID 1987763.1) ========================================================================= Prior to 12c, in order to roll forward the standby database using incremental backups you would need to:... » read more
One of the great progress Oracle database made with 12C was the posibility of Recover a table using RMAN without the need of any knowledge of Point-In-Time Recovery and how it is really done. 12C really simplifies everything in a really nice way that allows you a quick recovery as long as you have backup... » read more