OraFAQ Forum: Backup & Recovery » Flashback DB question

Home » RDBMS Server » Backup & Recovery » Flashback DB question (Oracle 11.2.0.3, 3-node RAC)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Flashback DB question [message #622475]

Tue, 26 August 2014 18:56

Ricky_1362002
Messages: 111
Registered: February 2009

Senior Member

Hello everyone - I have a few questions on Flashback Database, would be glad to get the answers from the experts like y'all.

Here is the scenario:
Flashback is enabled, flashback_retention is 48 hours, Undo space is huge

1pm: Everything is good on the Database

2pm: some changes in some of the tables were performed

3pm: New tablespaces have been added

4pm: Need the data changes to be rolled back, the database should be as it was at 1pm.

Now, at this point of time, is it possible to Flashback the DB to 1pm?

if yes, would the newly created tablespaces go away as well?

if no, what is the oldest time to which the Database can be flashed back (3.05 pm) ?

Does creating the tablespaces, or having the datafiles increased in size have any affect on Flashback Database?

Please advise.

Thank you,
Ricky

Report message to a moderator

Re: Flashback DB question [message #622476 is a reply to message #622475]

Tue, 26 August 2014 19:30

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

yes
yes, and you lose all changes which happened after 1PM

BTW - It does not matter if the 2PM changes were DML or DDL

Report message to a moderator

Re: Flashback DB question [message #622477 is a reply to message #622476]

Tue, 26 August 2014 20:30

Ricky_1362002
Messages: 111
Registered: February 2009

Senior Member

Thank you BlackSwan.

How about if at 3pm, lot of datafiles were resized, and a lot of new datafiles were added?

In that case, if I flashback to 1pm, do I lose the newly created datafiles, and also the resized ones go back to the actual size as at 1pm?

Report message to a moderator

Re: Flashback DB question [message #622478 is a reply to message #622477]

Tue, 26 August 2014 20:42

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

when all else fails, Read The Fine Manual YOURSELF!

http://www.oracle.com/pls/db121/search?remark=quick_search&word=flashback+database&partno=

Report message to a moderator

Re: Flashback DB question [message #622564 is a reply to message #622477]

Wed, 27 August 2014 12:01

tim2boles
Messages: 38
Registered: August 2008
Location: Clarksburg, WV

Member

Very interesting question......one that I did not know off the top of my head.

Look in the documentat ... http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta023.htm

There may be new versions with different information...but there is a table there that gives you what you want to know for version 11.1.

Regards
Tim

Report message to a moderator

Re: Flashback DB question [message #622734 is a reply to message #622564]

Thu, 28 August 2014 14:10

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

4pm: Need the data changes to be rolled back, the database should be as it was at 1pm.

When you say data changes should be rollback then why don't you consider FLASHBACK table ? OR Your refer entire database should be rollback as its 1 PM ?

Report message to a moderator