Flashback recovery || RMAN || Point in Time Recovery || Oracle Database
Describes the purpose and basic concepts of Oracle Flashback Technology and database point-in-time recovery.
-
#oracledatabasesolutions #flashback #recoverypoint #rman #sql #recovery
-
Performing Flashback and Database Point-in-Time Recovery.
Some typical situations include the following:
A user error or corruption removes needed data or introduces corrupted data. For example, a user or DBA might erroneously delete or update the contents of one or more tables, drop database objects that are still needed during an update to an application, or run a large batch update that fails midway.
A database upgrade fails or an upgrade script goes awry.
A complete database recovery after a media failure cannot succeed because you do not have all of the needed redo logs or incremental backups.
Basic Concepts of Flashback Technology
The flashback features of the Oracle Database are more efficient than media recovery in most circumstances in which they are available. You can use them to investigate past states of the database.
Physical Flashback Features Useful in Backup and Recovery
Oracle Flashback Database is the most efficient alternative to DBPITR.
Unlike the other flashback features, it operates at a physical level and reverts the current data files to their contents at a past time. The result is like the result of a DBPITR, including the OPEN RESETLOGS, but Flashback Database is typically faster because it does not require you to restore data files and requires only limited application of redo compared to media recovery.
A fast recovery area is required for Flashback Database. To enable logging for Flashback Database, you must set the DB_FLASHBACK_RETENTION_TARGET initialization parameter and issue the ALTER DATABASE FLASHBACK ON statement.
Flashback Database Operations on CDBs
Flashback Database on a whole CDB enables you to rewind the entire CDB, including all its PDBs, to a previous point in time. The target time can be specified by system change number (SCN), log sequence number, restore point, or time.
Flashback Database Operations on PDBs
Flashback Database on a PDB enables you to reverse unwanted changes caused by logical data corruption or user errors in that PDB. Other PDBs can remain open and operational while performing Flashback Database on a particular PDB.
The desired target point in time is specified by a PDB restore point, a CDB restore point, an SCN, or a time expression. A flashback operation on a PDB to a CDB restore point is equivalent to a flashback operation on the PDB to the restore point SCN on the CDB incarnation. In general, for PDBs, a flashback operation to a PDB restore point is more accurate than a flashback operation to a CDB restore point. This is because a PDB restore point represents the PDB sub-incarnation of the point in time at which it was created.
Multiple flashback operations can be performed on a single PDB. However, you can only perform a flashback operation on a PDB to one of its ancestor incarnations. A PDB must always stay in a past incarnation that is compatible with the overall database incarnation.
PDB backups remain valid even after a Flashback Database operation is performed on the PDB. In case of a media failure, you can perform recovery by using these backups. This type of PDB recovery can recover through database resetlogs and PDB resetlogs.
You can also perform a Flashback Database operation for a PDB on a physical standby database after performing the same operation on the primary database.
Music Reference :
► Jarico - Landscape : / la. .
► Jarico - Landscape [NCS BEST OF]: • Video
Track: Jarico - Landscape
Music Provided by Magic Records
Listen To The Original: • Jarico - Landscape (Magic Free Release)
Free Download: https://fanlink.to/g3JZ
Watch video Flashback recovery || RMAN || Point in Time Recovery || Oracle Database online without registration, duration hours minute second in high quality. This video was added by user Oracle Database Solutions 01 January 1970, don't forget to share it with your friends and acquaintances, it has been viewed on our site 782 once and liked it 17 people.