Home » RDBMS Server » Server Administration » Oracle Restore Point
Oracle Restore Point [message #357485] Wed, 05 November 2008 10:35 Go to next message
ssammy
Messages: 2
Registered: November 2008
Junior Member
Hi,

I want an automated script that create a oracle restore point every hour, So when ever I need to restore the db, I just go to the restore point and do the backup...

Any one have a nice script that creates the above, Your help is much appreciated!

thanks

Report message to a moderator

Re: Oracle Restore Point [message #357491 is a reply to message #357485] Wed, 05 November 2008 10:52 Go to previous messageGo to next message
Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Why not schedule a job to do it?

Take care there is a limit of 2048 restore points and some operations preclude from restoring like file shrinking.

Regards
Michel

Report message to a moderator

Re: Oracle Restore Point [message #357500 is a reply to message #357491] Wed, 05 November 2008 12:06 Go to previous messageGo to next message
ssammy
Messages: 2
Registered: November 2008
Junior Member
Thanks Michel,

I am looking for a script to do this, please explain how i could run a job...

thanks,
s

Report message to a moderator

Re: Oracle Restore Point [message #357519 is a reply to message #357500] Wed, 05 November 2008 13:12 Go to previous message
Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
DBMS_JOB, especially SUBMIT procedure.

Regards
Michel

Report message to a moderator

Previous Topic: Effects of Alter Table ?
Next Topic: problem with execute privilege on sys.truncate_table
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon May 11 12:40:38 CDT 2026
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.