Home » RDBMS Server » Backup & Recovery » Backup using schedular using a procedure (Oracle 10g)
Backup using schedular using a procedure [message #399621] Thu, 23 April 2009 02:51 Go to next message
virmahi
Messages: 266
Registered: April 2008
Location: India
Senior Member
Hi,
I have to schedule an automated database backup.
I need to write a procedure where a batch file could autimatically stop Oracle service, take backup and then restart Oracle service.

I do not understand how to do this but client has requested for such a procedure.
In case the database can't be stopped what other way is to take the backup using a schular which could be started by the procedure.
Kindly help me in this as I am new to this.

Regards,
Mahi
Re: Backup using schedular using a procedure [message #399629 is a reply to message #399621] Thu, 23 April 2009 03:23 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
net stop ...
rman ...
net start ...

I don't see why you want to stop the service, if you really want to make a cold backup just stop the database.

Regards
Michel
Re: Backup using schedular using a procedure [message #399639 is a reply to message #399629] Thu, 23 April 2009 04:47 Go to previous messageGo to next message
virmahi
Messages: 266
Registered: April 2008
Location: India
Senior Member
Hi Michel,
Thanks for your response. I have looked into google and found it can be done the way you suggested.
But can you please elaborate as I am not aware about rman backups.
I have to write a procedure that would be run scheduled and could take backup and restore when required.

Kindly elaborate on this please.

Thanks for looking into this.
Re: Backup using schedular using a procedure [message #399658 is a reply to message #399639] Thu, 23 April 2009 05:52 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


Check Ramn cold backup method in oracle document.

Babu
Re: Backup using schedular using a procedure [message #399662 is a reply to message #399639] Thu, 23 April 2009 06:19 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
http://www.oracle.com/pls/db102/portal.portal_db?selected=3#index-BAC

Regards
Michel
Previous Topic: Cannot restore from hot full backup(ORA-01152 RMAN-06053)
Next Topic: Editing RMAN Job DB Control
Goto Forum:
  


Current Time: Sat Dec 10 16:43:41 CST 2016

Total time taken to generate the page: 0.09691 seconds