Home » RDBMS Server » Backup & Recovery » How to schedule rman hot backup daily,,, (oracle 10g r2)
How to schedule rman hot backup daily,,, [message #462507] Thu, 24 June 2010 10:58 Go to next message
abhi_shakya
Messages: 50
Registered: September 2009
Location: Nepal
Member
I need to schedule rman hot backup daily at 9 pm....how shud i start??..I need to use EM job scheduler.
Re: How to schedule rman hot backup daily,,, [message #462508 is a reply to message #462507] Thu, 24 June 2010 11:05 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10613
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://www.saraie.net/index.php?option=com_content&view=article&id=35:schedule-oracle-online-backup-rman-with-oem-using-rman- catalog&catid=5:recovery-manager-rman&Itemid=19
Re: How to schedule rman hot backup daily,,, [message #462509 is a reply to message #462507] Thu, 24 June 2010 11:18 Go to previous messageGo to next message
abhi_shakya
Messages: 50
Registered: September 2009
Location: Nepal
Member
if i need to write the script and run it using oracle job schedular..not schedule backup feature...what shud i do??
Re: How to schedule rman hot backup daily,,, [message #462511 is a reply to message #462509] Thu, 24 June 2010 11:22 Go to previous messageGo to next message
BlackSwan
Messages: 21938
Registered: January 2009
Senior Member
>if i need to write the script and run it using oracle job schedular..not schedule backup feature...what shud i do??

use any text editor & start typing
Re: How to schedule rman hot backup daily,,, [message #462512 is a reply to message #462509] Thu, 24 June 2010 11:30 Go to previous message
Mahesh Rajendran
Messages: 10613
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
You mean,
using DBMS_SCHEDULER?
Nothing special here. Would be something like this.
Create a schedule
dbms_scheduler.create_schedule ( ...options...);

create the job
dbms_scheduler.create_job (
....options
program_type => 'EXECUTABLE',
program_action => '/yourPathToBackupScript',
....options
);



Edit:
This might help
http://www.oracle-base.com/articles/10g/Scheduler10g.php

[Updated on: Thu, 24 June 2010 11:32]

Report message to a moderator

Previous Topic: RMAN-01005 : SYNTAX ERROR
Next Topic: Recover database using backup controlfile
Goto Forum:
  


Current Time: Thu Apr 17 03:59:49 CDT 2014

Total time taken to generate the page: 0.12171 seconds