Below are the collection of useful flashback related commands. 1. How to check whether flashback is enabled or not: select flashback_on from v$database; 2. Enable flashback in database: --- make sure ...
flashback
How to flashback a RAC database
Below are the steps for flashback a database to restore point in a RAC database. 1. Check the restore point details. SELECT NAME FROM V$RESTORE_POINT; NAME ------------ STAGE_CR178 2. Check the status...
How to flashback a Pluggable database ( PDB) in oracle 12.2
From Oracle 12.2 onwards we can flashback a Pluggable database(PDB). And flashback is very easy and simple if LOCAL UNDO is enabled(which is also a new feature in Oracle 12.2). Let’s start the D...
FLASHBACK parameter in DATAPUMP(EXPDP)
We can use the flashback parameter ( FLASHBACK_SCN or FLASHBACK_TIMESTAMP) in expdp to take a consistent backup of the table as of a specific point in time. Flashback method depends upon undo data. So...
How to change flash recovery area location
Below are the steps for changing the flash recovery area(FRA destination). 1. Check the current FRA destination. SQL> show parameter db_recovery_file NAME TYPE VALUE -------------------------------...
How to enable flash recovery area in oracle database
The flash recovery area(FRA) is an Oracle-managed destination( either FILE SYSTEM or ASM ) for centralized backup and recovery files. It simplifies the backup management. The following recovery-relate...
ORA-01466: unable to read data – table definition has changed during flashback
PROBLEM: While doing flashback a table to a prior timestamp, got below error. 11:20:45 SQL> FLASHBACK TABLE test2 TO TIMESTAMP TO_TIMESTAMP('2017-07-12 11:18:55', 'YYYY-MM-DD HH24:MI:SS'); FLASHBAC...
ORA-38774: cannot disable media recovery – flashback database is enabled
PROBLEM: While disabling archive log mode, got the error – ORA-38774 SQL> alter database noarchivelog; alter database noarchivelog * ERROR at line 1: ORA-38774: cannot disable media r...
ORA-38706: Cannot turn on FLASHBACK DATABASE logging.
You may get ORA-38706: Cannot turn on FLASHBACK DATABASE logging while enabling flashback Problem: SQL> alter database flashback on; alter database flashback on * ERROR at line 1: ORA-38706: Cannot...
How to use flashback query in oracle database
This flashback query allows us to query a table at a point in the past. We can retrieve which we might have deleted by mistake in the past. Make sure flashback is enabled: SQL> select ...