OraFAQ Forum: Windows » How to schedule backup on windows 2008 server

Home » Infrastructure » Windows » How to schedule backup on windows 2008 server (Windows 2008 (Server), Oracle 11g (server version) )

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

How to schedule backup on windows 2008 server [message #462798]

Sun, 27 June 2010 09:32

oraranjangmailcom
Messages: 67
Registered: April 2010

Member

Hi,

On windows 2008, need to schedule task for database backup.

Can I have some help on this.

Thanks,
Ranjan

Report message to a moderator

Re: How to schedule backup on windows 2008 server [message #462799 is a reply to message #462798]

Sun, 27 June 2010 09:37

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Code: [Select all] [Show/ hide]

SQL> desc dba_scheduler_jobs
 Name					   Null?    Type
 ----------------------------------------- -------- ----------------------------
 OWNER						    VARCHAR2(30)
 JOB_NAME					    VARCHAR2(30)
 JOB_SUBNAME					    VARCHAR2(30)
 JOB_STYLE					    VARCHAR2(11)
 JOB_CREATOR					    VARCHAR2(30)
 CLIENT_ID					    VARCHAR2(64)
 GLOBAL_UID					    VARCHAR2(32)
 PROGRAM_OWNER					    VARCHAR2(4000)
 PROGRAM_NAME					    VARCHAR2(4000)
 JOB_TYPE					    VARCHAR2(16)
 JOB_ACTION					    VARCHAR2(4000)
 NUMBER_OF_ARGUMENTS				    NUMBER
 SCHEDULE_OWNER 				    VARCHAR2(4000)
 SCHEDULE_NAME					    VARCHAR2(4000)
 SCHEDULE_TYPE					    VARCHAR2(12)
 START_DATE					    TIMESTAMP(6) WITH TIME ZONE
 REPEAT_INTERVAL				    VARCHAR2(4000)
 EVENT_QUEUE_OWNER				    VARCHAR2(30)
 EVENT_QUEUE_NAME				    VARCHAR2(30)
 EVENT_QUEUE_AGENT				    VARCHAR2(256)
 EVENT_CONDITION				    VARCHAR2(4000)
 EVENT_RULE					    VARCHAR2(65)
 FILE_WATCHER_OWNER				    VARCHAR2(65)
 FILE_WATCHER_NAME				    VARCHAR2(65)
 END_DATE					    TIMESTAMP(6) WITH TIME ZONE
 JOB_CLASS					    VARCHAR2(30)
 ENABLED					    VARCHAR2(5)
 AUTO_DROP					    VARCHAR2(5)
 RESTARTABLE					    VARCHAR2(5)
 STATE						    VARCHAR2(15)
 JOB_PRIORITY					    NUMBER
 RUN_COUNT					    NUMBER
 MAX_RUNS					    NUMBER
 FAILURE_COUNT					    NUMBER
 MAX_FAILURES					    NUMBER
 RETRY_COUNT					    NUMBER
 LAST_START_DATE				    TIMESTAMP(6) WITH TIME ZONE
 LAST_RUN_DURATION				    INTERVAL DAY(9) TO SECOND(6)
 NEXT_RUN_DATE					    TIMESTAMP(6) WITH TIME ZONE
 SCHEDULE_LIMIT 				    INTERVAL DAY(3) TO SECOND(0)
 MAX_RUN_DURATION				    INTERVAL DAY(3) TO SECOND(0)
 LOGGING_LEVEL					    VARCHAR2(11)
 STOP_ON_WINDOW_CLOSE				    VARCHAR2(5)
 INSTANCE_STICKINESS				    VARCHAR2(5)
 RAISE_EVENTS					    VARCHAR2(4000)
 SYSTEM 					    VARCHAR2(5)
 JOB_WEIGHT					    NUMBER
 NLS_ENV					    VARCHAR2(4000)
 SOURCE 					    VARCHAR2(128)
 NUMBER_OF_DESTINATIONS 			    NUMBER
 DESTINATION_OWNER				    VARCHAR2(128)
 DESTINATION					    VARCHAR2(128)
 CREDENTIAL_OWNER				    VARCHAR2(30)
 CREDENTIAL_NAME				    VARCHAR2(30)
 INSTANCE_ID					    NUMBER
 DEFERRED_DROP					    VARCHAR2(5)
 ALLOW_RUNS_IN_RESTRICTED_MODE			    VARCHAR2(5)
 COMMENTS					    VARCHAR2(240)
 FLAGS						    NUMBER

Report message to a moderator

Re: How to schedule backup on windows 2008 server [message #462801 is a reply to message #462799]

Sun, 27 June 2010 14:03

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I'm certainly far from being an expert, but - isn't it about an operating system scheduler, rather than the database one?

Report message to a moderator

Re: How to schedule backup on windows 2008 server [message #462809 is a reply to message #462801]

Sun, 27 June 2010 15:29

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>I'm certainly far from being an expert, but - isn't it about an operating system scheduler, rather than the database one?

Last I checked, SCHEDULER can invoke OS script

Report message to a moderator

Re: How to schedule backup on windows 2008 server [message #462847 is a reply to message #462809]

Mon, 28 June 2010 03:01

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Thank you; now I'm a little bit closer to become an expert /forum/fa/917/0/

(baby steps, baby steps)

Report message to a moderator

Previous Topic:	Oracle 11g: established two database(d1, d2) but not able to connect the second database(d2).
Next Topic:	Fast Method to Install Oracle Client in multiple machines

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 04 01:07:23 CDT 2025