Fixing No-logging corruption the easy way [12.2 feature]
Fixing No-logging corruption the easy way [12.2 feature]

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

Rolling Forward a Physical Standby using “Recover From Service” command [12.1 feature]
Rolling Forward a Physical Standby using “Recover From Service” command [12.1 feature]

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

Recover a Table using RMAN Backup in 12c
Recover a Table using RMAN Backup in 12c

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