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
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: 64151
Registered: March 2007
Location: Nanterre, France, http://...
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
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
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: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
DBMS_JOB, especially SUBMIT procedure.

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


Current Time: Fri Dec 09 23:25:56 CST 2016

Total time taken to generate the page: 0.04832 seconds