OraFAQ Forum: Server Utilities » Flashback in Oracle 11g

Home » RDBMS Server » Server Utilities » Flashback in Oracle 11g (11g / Linux)

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

Flashback in Oracle 11g [message #470494]

Tue, 10 August 2010 02:16

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

Report message to a moderator

Re: Flashback in Oracle 11g [message #470498 is a reply to message #470494]

Tue, 10 August 2010 02:19

Michel Cadot
Messages: 68775
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Flashback in Oracle 11g [message #470510 is a reply to message #470498]

Tue, 10 August 2010 02:36

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?

Report message to a moderator

Re: Flashback in Oracle 11g [message #470531 is a reply to message #470510]

Tue, 10 August 2010 03:32

Michel Cadot
Messages: 68775
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Previous Topic:	Importing a dump
Next Topic:	IMPDP

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Mar 03 20:33:54 CST 2026