Recovery Archive

Oracle: All about recovering UNDO with no backup

Today’s post is all about recovering a database from a UNDO datafile loss (when there is no backup available). Ideally, we keep backup of our databases for PROD and PRE-PROD environments. However, most of the organizations do

RMAN Block Media Recovery: Lets have a deeper look

As a DBA, we know there are situations where the database blocks get corrupted and we have different methods available to fix the corrupted blocks. In today’s article, I would be discussing the internals involved in the

Oracle 12c New RMAN Feature: Restore and Recovery of database table

Introduction Prior to Oracle database 12c, restoring a single table was not possible through RMAN and it required a lot of manual efforts to successfully restore and recover a specific database table. Oracle 12c database provides a

Recreate AWR in Oracle 11g

1: Check and make a note of the following parameter values SQL> show parameter cluster_database SQL> show parameter statistics_level SQL> show parameter sga_target SQL> show parameter memory_target SQL> show parameter spfile   2: Disable AWR Snapshots by
Visit Us On LinkedinVisit Us On TwitterVisit Us On Google PlusCheck Our Feed