flashback

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. [crayon-5c400dec1e4a9619016228/] 2. Change db_recovery_file_dest parameter. [crayon-5c4...

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. [crayon-5c400dec20525735918923/] CAUSE & SOLUTION:   This error happens when a DDL change happened on that object and...

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: [crayon-5c400dec20cd0797981965/]   solution:   Put database in archivelog mode , if not   ...

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: [crayon-5c400de...

How to enable and disable flashback in oracle database

By using flashback technology we can restore the database to a particular point in past. It’s like time machine. Here we will see , how to enable and disable flashback in oracle.   ENABLE F...

Skip to toolbar