Did you ever have to flashback a production database to recover from human error?
Yes, a primary production database
Yes, the physical standby of a production db
Both primary and standby
No idea or not applicable
Answer and see the results
DBA Top 10
1 M. Cadot 85200
2 T. Boles 42650
3 B. Vroman 36300
4 A. Kavsek 33000
5 P. Wisse 24800
6 J. Péran 21150
7 K. Subramaniam 17200
8 A. Khan 14000
9 A. Hudspith 13750
10 F. Pachot 12550
Download PLATO
The free tool for auditing and tuning your database
Version 54 now available

Sep 04, 2014
(recommended update: build 1403)
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered47108
Total active users29629
Act. users last 24h26
Act. users last hour2
Hits last week1268
Hits last month6462
Tips, Scripts, Papers, Events, Links, ...
Tip:Be careful when installing a brand new database in 11G

Joël Péran, Dec 09
Link:Physical IO on Linux

Philip Wisse, Dec 02
Link:Installation of Oracle 12c on Oracle Enterprise Linux 7

Vijay Mahawar, Nov 24
Link:PL/SQL Challenge

Joël Péran, Nov 24
Link:Oracle IOT: when to use Index Organized Tables

Franck Pachot, Oct 26
Latest Forum Threads
exadata reconfiguration

We have exadata X4-2 machine.
There are two clusters for 14 cell nodes and 8 db nodes.
Cluster 1 ... (0 repl.)
Purging Older Table Partitions

Hi Team,

I need to Purge older table partitions,can any one suggest best method or step by step a... (4 repl.)
dNFS with ASM over dNFS with file system - advantages and disadvantages.

Hello All,

We are creating a 2-node RAC. There will be 3-4 DBs whose instances will be across the... (0 repl.)
purge job is failing with ORA-08130

Its a purge job failing and before this purge job starts one more job will start that job will take ... (14 repl.)
Top Wait Events

Hi, All
Below are the top events on my RAC 4-instances and its Avg. wait time in (ms) for 2 hr test... (6 repl.)
Backup / Recover in Virtual Environments

About a week ago I was asking for some ideas of differences in backups and recovery in various types... (1 repl.)
Oracle Software Installation


I was trying to install Oracle Software in HP-UX machine with version as 11.23. But wh... (2 repl.)
--> Start a new thread ...
Have you ever flashed back your primary production database?
We thought once at using this feature as "backup solution" before appl...
I have used flashback in DR database. recovered a table data by creat...
Used once by a client on produciton database: create restore point bef...
No uso esa esa opción, pero es bueno tenerla presente.
Yes Iv done it to Production - many times. Flashback transaction up...
I was playing with this feature on a test server and it worked. Howeve...