OraFAQ Forum: Backup & Recovery » How to schedule rman hot backup daily,,,

Home » RDBMS Server » Backup & Recovery » How to schedule rman hot backup daily,,, (oracle 10g r2)

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

How to schedule rman hot backup daily,,, [message #462507]

Thu, 24 June 2010 10:58

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.

Report message to a moderator

Re: How to schedule rman hot backup daily,,, [message #462508 is a reply to message #462507]

Thu, 24 June 2010 11:05

Mahesh Rajendran
Messages: 10708
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

Report message to a moderator

Re: How to schedule rman hot backup daily,,, [message #462509 is a reply to message #462507]

Thu, 24 June 2010 11:18

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??

Report message to a moderator

Re: How to schedule rman hot backup daily,,, [message #462511 is a reply to message #462509]

Thu, 24 June 2010 11:22

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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

Report message to a moderator

Re: How to schedule rman hot backup daily,,, [message #462512 is a reply to message #462509]

Thu, 24 June 2010 11:30

Mahesh Rajendran
Messages: 10708
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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 21 22:00:56 CST 2024