Stack Overflow
Stack Overflow

Questions tagged [flashback]

*Flashback* is an Oracle technology that enables users to view previous states of the database.

Oracle Flashback is a group of database technologies and commands that lets users and database administrators view / restore previous states of the database. It is used mostly after data was erroneously deleted / updated, and the changes were committed before the error was noticed.

See Oracle documentation for Flashback

61 questions
0
votes
1 answer

Oracle Insert using FLASHBACK Query

I have two identical schemas, on different databases connected via Database Link. Schema_1: Source Schema. **Rows being inserted at rapid rate.** Schema_2: Target Schema. Rows being inserted into Schema_1 (source schema) at rapid rate. I am…
oradbanj
  • 551
  • 7
  • 23
0
votes
1 answer

Recover existing object code in greenplum database

One of my procedure in greenplum database is replaced by a wrong code.I want the old and correct version of the procedure. Is it possible in greenplum database to recover the code? Is there any function like Flashback in greenplum database?
Priyanka Das
  • 11
  • 1
  • 3
0
votes
0 answers

Can Oracle Flashback SCN be a negative value?

Is there a definition for SCN used in Oracle Flashback technology? I was wondering whether the SCN can take a negative value or is it an unsigned value.
Sampath
  • 1,144
  • 1
  • 21
  • 38
0
votes
1 answer

Rewind a database table in Oracle and return to the current state in real time

We are working on a new release of our product and we want to implement a feature where a user can view older data for a disease prediction made by the application. For example, the user would have an option to go back in time to see the predictions…
Sarang Joshi
  • 21
  • 3
0
votes
1 answer

Flashback, backup, checkpoint, redo logs

I was searching over the internet to find good explanations of flashback, backup and checkpoint, but I find it hard to understand the difference. Both flashback and backup can revert database to the previous state. Flashback can fix logical…
Lantya
  • 1
0
votes
1 answer

How to recover a database that has been deleted by installing a theme plugin for UI?

I am currently building a database in my class in SQL PLSQL. Using Apex Oracle, I made a huge mistake,installed a new apex theme plugin and set it as my current theme to enhance the UI. This plugin replaced my database with all of its own stuff and…
Beaugh
  • 1
  • 2
0
votes
1 answer

Flashback query retention time

I want to set flashback query retention to 240 in order to be able to perform flashback query from last 4 hours. I would like to do something similar to this: alter system set db_flashback_retention_target = 240; but I couldn't find the name of…
Snochacz
  • 685
  • 1
  • 8
  • 23
0
votes
0 answers

Flashback Oracle Database - Shutdown abort

If I killed a long transaction that is rolling back millions of deleted records, is there any risk to use SHUTDOWN ABORT on the DB before issuing a flashback command on it? Since the Database needs only to be in MOUNT state for the flashback, I…
XChoopa
  • 435
  • 2
  • 6
  • 13
0
votes
1 answer

Records Deleted. Commit executed. Can we have that records back from anywhere?

Recovered Records Should be up to date as when they were deleted.
Viplove Sharma
  • 1
  • 1
0
votes
2 answers

How Do I recover data from a dropped Table?

I accidentally dropped a table, and I recovered it with flashback statement and recycle bin information: FLASHBACK TABLE "XXXXXXXXXXXXXXX==$0" TO BEFORE DROP; But when I made it a select * from XXX it was empty. Is there a way to recover the…
Pablo Glez
  • 306
  • 1
  • 7
  • 20
0
votes
1 answer

I dropped a table in Oracle, how can I retrieve it from the undo tablespace?

I accidentally dropped a fairly large table -- recycling bin is not enabled. I'm fairly certain the data still exists in the UNDO tablespace, but I'm not sure how to get it out. I recreated the table exactly as it was before it was dropped -- the…
user2836455
  • 1
  • 1
  • 1
0
votes
1 answer

Oracle Apex: dropped objects don't appear in recycle bin

After accidentally dropping a package body in Oracle Application Express 4.0.2.00.09, I tried to restore it from the recycle bin. The object however does not appear in that folder, along with other numerous objects I have dropped in the past.…
user2747399
  • 1
0
votes
1 answer

Oracle 11G - SE1 Flashback Query Retention Log

I want to increase the size of the FLASHBACK "retention log" so I can do flashback queries far back in time ( from now on ). How do I do this ? I'm using Oracle 11G SE1 on Amazon RDS. Cheers !
MadSeb
  • 7,958
  • 21
  • 80
  • 121
0
votes
1 answer

Oracle flashback: Is there a way to get the REDO SQL queries?

Within the oracle database 11g the table FLASHBACK_TRANSACTION_QUERY provides the UNDO_SQL column which SQL reverses the modification done by a specific previously executed query. However, I need the REDO_SQL (the original SQL which has been…
MRalwasser
  • 15,605
  • 15
  • 101
  • 147
-1
votes
1 answer

Oracle flashback database remotely

I often have to flashback my database to a certain restore point. On the machine where the database is running I log in with sqlplus and issue the following commands. shutdown immediate; startup mount; flashback database to restore point…
bbuser
  • 918
  • 11
  • 33
1 2 3
4
5