OraFAQ Forum: Backup & Recovery » Backup using schedular using a procedure

Home » RDBMS Server » Backup & Recovery » Backup using schedular using a procedure (Oracle 10g)

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

Backup using schedular using a procedure [message #399621]

Thu, 23 April 2009 02:51

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

Report message to a moderator

Re: Backup using schedular using a procedure [message #399629 is a reply to message #399621]

Thu, 23 April 2009 03:23

Michel Cadot
Messages: 68645
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

Report message to a moderator

Re: Backup using schedular using a procedure [message #399639 is a reply to message #399629]

Thu, 23 April 2009 04:47

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.

Report message to a moderator