How to create DB restore point in 19C Database

What is Restore point?

Flashback database can reverse the changes and can take entire database back in pervious stage.  Restore points work as bookmark in this.

Before doing any major changes to database, a restore point can be created to allow for a 'restore point' to undo the changes.   

Types of restore points

Normal Restore point

Guaranteed restore point

Normal Restore point:

The normal restore point is associated with a specific time / SCN as a kind of bookmark. The name of restore point with respect to SCN gets recorded in control file.

The control file can maintain a record of thousands of restore points without impacting database performance.

Guaranteed restore point:

The guaranteed restore point associated with SCN enforces the requirement that you can perform flashback

Database operation to return your database to its state at that SCN.

A guarantee restore point must be manually deleted.

SQL Commands

Example:

My PDB Name is india

SQL> alter session set container="india ";

Session altered.

SQL> show con_name;

CON_NAME ------------------------------ india  

 

 Verify the old restore point user below commands

SQL> select GUARANTEE_FLASHBACK_DATABASE,NAME from v$restore_point;

SQL> select NAME,TIME,SCN,PDB_RESTORE_POINT,GUARANTEE_FLASHBACK_DATABASE from V$RESTORE_POINT;

no rows selected


creating a guaranteed restore point before patching

SQL> create restore point BEFORE_Patch guarantee flashback database;

Restore point created.


SQL> select NAME,TIME,SCN,PDB_RESTORE_POINT,GUARANTEE_FLASHBACK_DATABASE from V$RESTORE_POINT;

NAME

--------------------------------------------------------------------------------------------------------------------------------

TIME                                                                               SCN PDB GUA

--------------------------------------------------------------------------- ---------- --- ---

BEFORE_PATCH

10-MAY-21 08.01.47.000000000 AM                                             3.6965E+13 YES YES

 

Dropping restore point

SQL> Drop restore point BEFORE_PATCH;

Restore point dropped.

Reference:

Loss of a Non system Data file recovery scenarios

Archive log Basic

Difference between RMAN Validate and crosscheck

Overview of RMAN Recovery Catalog

RMAN Overview

Comments

  1. Please find some more interview question:
    www.top15search.blogspot.com

    ReplyDelete

Post a Comment

Popular posts from this blog

How to troubleshoot long running concurrent request in R12.2

How to run Gather Schema Statistics in R12.2

How to compile forms in R12.2