OraFAQ Forum: Backup & Recovery » Drop guaranteed restore point and make more space

Home » RDBMS Server » Backup & Recovery » Drop guaranteed restore point and make more space (Oracle 12 C windows)

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

Drop guaranteed restore point and make more space [message #676669]

Mon, 01 July 2019 11:32

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

Report message to a moderator

Re: Drop guaranteed restore point and make more space [message #676670 is a reply to message #676669]

Mon, 01 July 2019 12:55

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

Senior Member
Account Moderator

Quote:

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

Yes.

Report message to a moderator

Re: Drop guaranteed restore point and make more space [message #676671 is a reply to message #676670]

Mon, 01 July 2019 16:24

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?

Report message to a moderator

Re: Drop guaranteed restore point and make more space [message #676672 is a reply to message #676671]

Tue, 02 July 2019 00:22

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

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

Report message to a moderator

Re: Drop guaranteed restore point and make more space [message #676675 is a reply to message #676672]

Tue, 02 July 2019 14:38

anncao
Messages: 87
Registered: August 2013

Member

Thank you, that does help!

Report message to a moderator

Previous Topic:	Including Archive logs in Controlfile manually
Next Topic:	Как лучше всего создать вторую БД?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jun 05 14:27:41 CDT 2025