Home » Infrastructure » Windows » How to schedule backup on windows 2008 server (Windows 2008 (Server), Oracle 11g (server version) )
How to schedule backup on windows 2008 server [message #462798] Sun, 27 June 2010 09:32 Go to next message
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
Re: How to schedule backup on windows 2008 server [message #462799 is a reply to message #462798] Sun, 27 June 2010 09:37 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
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
Re: How to schedule backup on windows 2008 server [message #462801 is a reply to message #462799] Sun, 27 June 2010 14:03 Go to previous messageGo to next message
Littlefoot
Messages: 21806
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?
Re: How to schedule backup on windows 2008 server [message #462809 is a reply to message #462801] Sun, 27 June 2010 15:29 Go to previous messageGo to next message
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
Re: How to schedule backup on windows 2008 server [message #462847 is a reply to message #462809] Mon, 28 June 2010 03:01 Go to previous message
Littlefoot
Messages: 21806
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)
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:
  


Current Time: Fri Mar 29 00:15:33 CDT 2024