Home » RDBMS Server » Performance Tuning » flashback (Oracle 11g)
flashback [message #639258] Sat, 04 July 2015 00:46 Go to next message
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??
Re: flashback [message #639261 is a reply to message #639258] Sat, 04 July 2015 01:14 Go to previous messageGo to next message
Michel Cadot
Messages: 65387
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
ashish.tiwari
Messages: 9
Registered: June 2015
Location: New Delhi
Junior Member
Disable it or do less work in your database.
Re: flashback [message #639263 is a reply to message #639262] Sat, 04 July 2015 01:22 Go to previous messageGo to next message
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 ?
Re: flashback [message #639264 is a reply to message #639263] Sat, 04 July 2015 01:33 Go to previous messageGo to next message
ashish.tiwari
Messages: 9
Registered: June 2015
Location: New Delhi
Junior Member
any body give me solutionnnnn
Re: flashback [message #639265 is a reply to message #639264] Sat, 04 July 2015 01:47 Go to previous messageGo to next message
Michel Cadot
Messages: 65387
Registered: March 2007
Location: Nanterre, France, http://...
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).

Re: flashback [message #639268 is a reply to message #639265] Sat, 04 July 2015 02:03 Go to previous messageGo to next message
ashish.tiwari
Messages: 9
Registered: June 2015
Location: New Delhi
Junior Member
ok
Thanks
Re: flashback [message #639289 is a reply to message #639258] Sat, 04 July 2015 09:22 Go to previous messageGo to next message
John Watson
Messages: 7262
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.
Re: flashback [message #639317 is a reply to message #639258] Mon, 06 July 2015 03:22 Go to previous message
gazzag
Messages: 909
Registered: November 2010
Location: Bristol, UK
Senior Member
SQL> SELECT * FROM v$restore_point;
Previous Topic: 'Configuration' wait class in AWR report
Next Topic: Oracle does not use a conditional index
Goto Forum:
  


Current Time: Wed Feb 21 17:58:32 CST 2018

Total time taken to generate the page: 0.06374 seconds