Home » RDBMS Server » Server Administration » Problem with Deleting Flashback Logs (Oracle 10g R2, Windows 2003 Server)
Problem with Deleting Flashback Logs [message #360777] Mon, 24 November 2008 00:35 Go to next message
Creems
Messages: 70
Registered: July 2007
Location: Johannesburg
Member
Hi,


Flashback logs is enabled on the database, actually the target was configured for 1 day (1440) but it doesn't get deleted automatically.

And when I issued a statement to delete it ... the statement went through but the flashback logs is still there not deleted.

shutdown immediate
startup mount
alter database flashback off;
alter database open;

Please what could be the problem here? Meanwhile, when I did the same on my Windows XP with the same version of Oracle10g it get deleted. Is there a problem with Win 2003 server deleting flashback logs?


Regards,

Texas B

Re: Problem with Deleting Flashback Logs [message #360792 is a reply to message #360777] Mon, 24 November 2008 00:56 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Oracle will delete them when space will be needed in your FRA.

Regards
Michel
Re: Problem with Deleting Flashback Logs [message #360796 is a reply to message #360792] Mon, 24 November 2008 01:01 Go to previous messageGo to next message
Creems
Messages: 70
Registered: July 2007
Location: Johannesburg
Member
Hi Michel,

Thanks for your reply.


But when I did the same on my work station (Win XP) @ home it gets deleted but why not deleting on the Win 2003 server?


That is my question. A client is on my neck for this and I need to find a solution.


Regards,

Texas B
Re: Problem with Deleting Flashback Logs [message #360805 is a reply to message #360796] Mon, 24 November 2008 01:19 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
With what you posted I can't say more than what I already said.
Maybe in your workstation FRA size is much smaller.

Regards
Michel
Re: Problem with Deleting Flashback Logs [message #360815 is a reply to message #360805] Mon, 24 November 2008 01:29 Go to previous messageGo to next message
Creems
Messages: 70
Registered: July 2007
Location: Johannesburg
Member
Actually that's true. The size of FRA on my workstatin is 2G while the size @ office is 150G.

One more question please ... I know that when FRA is needed the flashback logs get deleted ... will it be deleted in this situation?


Thanks so much ... now I can go relax.


Regards,

Texas B
Re: Problem with Deleting Flashback Logs [message #360823 is a reply to message #360815] Mon, 24 November 2008 01:46 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
will it be deleted in this situation?

In which one? It will be deleted each time space is needed and files are expired.

Regards
Michel

[Updated on: Mon, 24 November 2008 01:47]

Report message to a moderator

Previous Topic: Table Fragmentation
Next Topic: Compatibility - Solaris 10 with Oracle7+forms
Goto Forum:
  


Current Time: Sat Dec 03 17:53:50 CST 2016

Total time taken to generate the page: 0.09709 seconds