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
9
votes
3 answers

Tune Oracle Database for faster startup (flashback)

I'm using Oracle Database 11.2. I have a scenario where I issue FLASHBACK DATABASE quite often. It seems that a FLASHBACK DATABASE cycle does a reboot of the database instance which takes approx. 7 seconds on my setup. Database is small (~ 1 GB…
MRalwasser
  • 15,605
  • 15
  • 101
  • 147
7
votes
2 answers

How to disable flashback query logging for a specific table (Oracle)?

We have a specific table that has a lot of activity and it creates a lot of change records. The consequence is that the flashback data only goes back a couple of days. That is OK for many cases but it would be beneficial to have access to more…
Arturo Hernandez
  • 2,749
  • 3
  • 28
  • 36
4
votes
1 answer

How to rollback my DB changes after a commit?

I did a DB update without using a where clause and commit without taking any backup. All the rows in the table are updated. Is there any way to rollback the changes? The DB is a Oracle SQL one. Please help.
Niketh Kovin
  • 63
  • 1
  • 2
  • 10
3
votes
1 answer

Cannot drop Oracle flashback data archive

Wanted to do a clean test on Flashback Data Archive so had to remove the existing. I disabled FDA on all enabled tables and dropped FDA. But still i see the record in DBA_FLASHBACK_ARCHIVE And DBA_FLASHBACK_ARCHIVE_TS If i attempt to drop the…
mediocre_10
  • 61
  • 2
3
votes
2 answers

FLASHBACK_TRANSACTION_QUERY View in Oracle 12c returning no rows

I am learning Flashback Transaction Query in Oracle 12c. I executed some DDL and DML statements. At the end, I executed a select statement on the FLASHBACK_TRANSACTION_QUERY view in order to see the UNDO_SQL value, but it returned no rows. I am…
A J
  • 31
  • 2
3
votes
1 answer

Hibernate doesn't return manually INSERTed rows

I'm having an issue with my jpa repository doesn't return rows that I've manually inserted into the database (Oracle) via good old SQL Insert into SYSTEM.USER (ID,CREDENTIALS,ISADMIN) values (USERSEQ.nextval,'foo',1); My Jpa…
Snæbjørn
  • 10,322
  • 14
  • 65
  • 124
3
votes
1 answer

Postgresql equivalent of flashback

I'm Oracle Dba and want to learn Postgresql. Does it have equivalent of flashback in Postgresql?
Rauf Aliyev
  • 45
  • 1
  • 1
  • 3
3
votes
1 answer

Rollback changes to the commited update statements

There are around 1500 records updated in my database and unfortunately, I had committed the changes. I could remember that there is an option to rollback the changes in oracle 11g. I am using Toad tool and I had run the below query FLASHBACK…
user2075017
  • 457
  • 4
  • 11
  • 23
3
votes
2 answers

How to restore the data in a Oracle table?

I did a terrible mistake on my work, I executed an updated query on a oracle table without the 'where' clause and everything changed on this table, I was wondering if there is any way to restore the data on a table. I know I can use Flashback, but…
Walter Colchado
  • 337
  • 1
  • 6
  • 16
2
votes
1 answer

What is Read ONLY Role to give to Oracle developers to veiw the Flashback Data via versions Query

I have created Oracle FDA and its tracking the DMLS on the tables but can i know if there is a specific role that could be granted to users to view the data using VERSIONS BETWEEN Query GRANT FLASHBACK ANY TABLE or GRAN FLASHBACK on tblname seems to…
mediocre_10
  • 61
  • 2
2
votes
0 answers

Maximum number of days SCN retains, to query archived data

I have a table which is flashback enabled. I want to query the data using AS OF clause as following: SELECT * FROM employees AS OF TIMESTAMP TO_TIMESTAMP('2019-09-11 00:00:00', 'YYYY-MM-DD HH24:MI:SS'); The flashback archive has a retention period…
Ravi Shankar
  • 277
  • 9
  • 23
2
votes
1 answer

how to know the previous length of a column after altering that

I have altered the size of a column in Oracle , and now i want to get the prev size of that column, so is there anyway we can get the prev size of that column. Thanks.
Danish
  • 189
  • 2
  • 3
  • 14
2
votes
2 answers

flashback recovery in oracle 10g

i m using oracle 10g and i want to enable flashback database i hava manually run all the command like SQL> shutdown immediate; SQL> startup mount; SQL> alter database archivelog; SQL> ALTER SYSTEM SET DB_FLASHBACK_RETENTION_TARGET=4320; SQL> ALTER…
Bhavana
  • 329
  • 2
  • 4
  • 9
2
votes
1 answer

How can I migrate data, adding a new column with constraints, with flashback archives enabled?

I've currently got a string value in one table, which I would like to change so that it references another table. For instance, currently I have: | Table: Animal | ----------------------- | Name | Class | |-----------|---------| |…
Lunivore
  • 17,277
  • 4
  • 47
  • 92
2
votes
1 answer

Version Query Output after Insert, Update and Delete

Following is a question related to Oracle SQL Expert exam and have 4 choices. It says the correct answer is C. But I have a doubt and think that D should be the answer as this uses Oracle FlashBack technique. Can anybody explain this please. Thank…
CAD
  • 4,112
  • 6
  • 29
  • 47
1
2 3 4 5