OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » flashback (Oracle 11g)

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

flashback [message #639258]

Sat, 04 July 2015 00:46

ashish.tiwari
Messages: 9
Registered: June 2015
Location: New Delhi

Junior Member

Quote:

hi,
i configured new oracle database server(11g) with flashback. But my problem is that flashback log file size is continuously increase
, so my server space is decreasing, so please assist me how to manage flashback??

Report message to a moderator

Re: flashback [message #639261 is a reply to message #639258]

Sat, 04 July 2015 01:14

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

Senior Member
Account Moderator

Disable it or do less work in your database.

[Updated on: Sat, 04 July 2015 01:14]

Report message to a moderator

Re: flashback [message #639262 is a reply to message #639261]

Sat, 04 July 2015 01:20

ashish.tiwari
Messages: 9
Registered: June 2015
Location: New Delhi

Junior Member

Disable it or do less work in your database.

Report message to a moderator

Re: flashback [message #639263 is a reply to message #639262]

Sat, 04 July 2015 01:22

ashish.tiwari
Messages: 9
Registered: June 2015
Location: New Delhi

Junior Member

But i can't disable and it's my production server.
so please suggest me.... Can i delete this log files ?

Report message to a moderator

Re: flashback [message #639264 is a reply to message #639263]

Sat, 04 July 2015 01:33

ashish.tiwari
Messages: 9
Registered: June 2015
Location: New Delhi

Junior Member

any body give me solutionnnnn

Report message to a moderator

Re: flashback [message #639265 is a reply to message #639264]

Sat, 04 July 2015 01:47

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

Senior Member
Account Moderator

Be patient, this is a volunteer forum, you pay us nothing, we owe you nothing.
But YOU owe us thanks to spend time to help you (review your previous topic).

You have only 4 choices:
1/ Disable flashback
2/ Decrease retention (and drop guaranteed restore point)
3/ Decrease the modification in the db
4/ Buy more disks

So choose.

You cannot manually delete files, Oracle will do when appropriate (assuming you have correctly set your FRA).

Report message to a moderator

Re: flashback [message #639268 is a reply to message #639265]

Sat, 04 July 2015 02:03

ashish.tiwari
Messages: 9
Registered: June 2015
Location: New Delhi

Junior Member

ok
Thanks

Report message to a moderator

Re: flashback [message #639289 is a reply to message #639258]

Sat, 04 July 2015 09:22

John Watson
Messages: 8964
Registered: January 2010
Location: Global Village

Senior Member

The space usage should stabilize, once your db_flashback_retention_target time has passed. If you look at v$flashback_datbase_stat you can get an idea of how much flashback data is being generated, and the estimted size needed to meet whatever your target is set to.

Report message to a moderator

Re: flashback [message #639317 is a reply to message #639258]

Mon, 06 July 2015 03:22

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

SQL> SELECT * FROM v$restore_point;

Report message to a moderator

Previous Topic:	'Configuration' wait class in AWR report
Next Topic:	Oracle does not use a conditional index

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 30 11:35:06 CST 2025