OEM and the Job Scheduler
The OEM provides you with the ability to configure a set of jobs to be automatically run on one or more of your databases. You can set up the jobs to run at the same time on each database or at different times. Oracle supplies a list of commonly used jobs to choose from. You can also write your own customized scripts and schedule them to run automatically.
As with all the OEM utilities, the OEM Job Scheduler uses the intelligent agent on each computer node to perform the actual work that has been scheduled. There is only one intelligent agent per node, regardless of how many databases are on that node or how many jobs have been scheduled to be run against those databases.
The default tasks provided with the OEM Job Scheduler utility can be run either one time or on a scheduled basis:
Back up tablespace
Export
Import
Load
Run DBA script
Run SQL*Plus
Shut down database
Start up database
Broadcast message
Run OS command
Run TCL
Deinstall product
Delete package
Distribute package
Install package
Many of these tasks help protect your databases, as we describe in the following sections.
Back Up Tablespaces, Export, Import, and Load Data
The ability to back up tablespaces on a scheduled basis is a wonderful option that helps ensure you can recover your database to either the last time the tablespaces were backed up or to a point in time after the last backup (if archivelog mode has been enabled). However, if you are going to schedule automatic tablespace backups, ...
Get Oracle Security now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
