Home » RDBMS Server » Backup & Recovery » Drop guaranteed restore point and make more space (Oracle 12 C windows)
Drop guaranteed restore point and make more space [message #676669] Mon, 01 July 2019 11:32 Go to next message
anncao
Messages: 87
Registered: August 2013
Member
We are using Oracle 12c on windows.
This is a test environment. and we are testing a long process that runs step by step.

We created a couple of guaranteed restore point on steps that need possibly recover if any failure happened during the process.

Now the process done successfully, but since our guaranteed restore point is till turned on, the space is run off. and database is hang. We asked network engineer to add space to the data drive. Now it works.
But it will fill up soon again since people still work on the server.

What should we do now since our database admin is absent for a couple of days. If we drop the guaranteed restore point, will that spare some space on the fast recovery area? Currently we have the test database archive log on, flash database on and guranteed restore point on?

Thanks
Re: Drop guaranteed restore point and make more space [message #676670 is a reply to message #676669] Mon, 01 July 2019 12:55 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
If we drop the guaranteed restore point, will that spare some space on the fast recovery area?

Yes.
Re: Drop guaranteed restore point and make more space [message #676671 is a reply to message #676670] Mon, 01 July 2019 16:24 Go to previous messageGo to next message
anncao
Messages: 87
Registered: August 2013
Member
Thanks, could you expain a little more, when drop a guaranteed restore point, what will happen, what files will be deleted or removed?

Re: Drop guaranteed restore point and make more space [message #676672 is a reply to message #676671] Tue, 02 July 2019 00:22 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

I think the following will help you to understand:
Database Backup and Recovery User's Guide
Chapter 7 Using Flashback Database and Restore Points

Re: Drop guaranteed restore point and make more space [message #676675 is a reply to message #676672] Tue, 02 July 2019 14:38 Go to previous message
anncao
Messages: 87
Registered: August 2013
Member
Thank you, that does help!
Previous Topic: Including Archive logs in Controlfile manually
Next Topic: Как лучше всего создать вторую БД?
Goto Forum:
  


Current Time: Thu Mar 28 10:17:50 CDT 2024