flashback

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

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-5beda77acccaf407058392/] 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-5beda77acd390596183128/]   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-5beda77...

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