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
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
Difference between RMAN Validate and crosscheck
Please find some more interview question:
ReplyDeletewww.top15search.blogspot.com