Home » RDBMS Server » Server Utilities » Flashback in Oracle 11g (11g / Linux)
Flashback in Oracle 11g [message #470494] Tue, 10 August 2010 02:16 Go to next message
Miiiiriiii
Messages: 4
Registered: August 2010
Location: Leinfelden Echterdingen
Junior Member
I have a question concerning flashback in Oracle11g:

In 10g changes made to the db structure like adding datafiles or log file groups were not affected by flashback. In 11g these changes seem to be reverted, too.

Does anyone knows which changes flashback in 11g reverts?

Cheers,
Miri
Re: Flashback in Oracle 11g [message #470498 is a reply to message #470494] Tue, 10 August 2010 02:19 Go to previous messageGo to next message
Michel Cadot
Messages: 58501
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Can you explain in details what you did and what you want to do, it is not clear.
First of all, which kind of flashback are you talking about?

Regards
Michel
Re: Flashback in Oracle 11g [message #470510 is a reply to message #470498] Tue, 10 August 2010 02:36 Go to previous messageGo to next message
Miiiiriiii
Messages: 4
Registered: August 2010
Location: Leinfelden Echterdingen
Junior Member
I do performance analysis for an application.
Before I start running a test I create a restore point,
after the test I flashback to restore point.

During the testing I sometimes add or enlarge datafiles etc.
In 10g these changes were not undone by flashback.

In 11g this seems to be the case. Do you know exactly which actions flashback undoes in 11g?
Re: Flashback in Oracle 11g [message #470531 is a reply to message #470510] Tue, 10 August 2010 03:32 Go to previous message
Michel Cadot
Messages: 58501
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
In 11g this seems to be the case

I didn't test it; are you sure? I think it is doubful; does Oracle also shrink the OS file?

By the way, 11g what? Always post your Oracle version with 4 decimals.

Regards
Michel
Previous Topic: Importing a dump
Next Topic: IMPDP
Goto Forum:
  


Current Time: Wed Jul 23 11:17:03 CDT 2014

Total time taken to generate the page: 0.09965 seconds