Databases Reference
In-Depth Information
Figure 19-21.
Create special RMAN script
After you've entered the RMAN script, click on the Credentials tab and make sure you fill in the host and database
credentials for your environment. You can now click on Submit to have the job run immediately. If you want the job to
run a specific time, then enter those details in the Schedule section.
How It Works
It's fairly easy to schedule custom RMAN scripts through Enterprise Manager. You need to navigate to the appropriate
screens, create the custom RMAN job, and then schedule the job to be run.
You can view job information from the Job Activity screen or you can also query the Enterprise Manager
repository directly. To view job information from SQL*Plus, connect as the repository owner (usually named
sysman
),
and query the MGMT_JOB table:
SQL> connect sysman/<your password>
SQL> select job_name, job_description from mgmt_job;
Here is some sample output:
JOB_NAME JOB_DESCRIPTION
------------------------------ --------------------------------------------------
RECOVERY_O12C_000043 Whole Database Restore and Recover
BACKUP_O12C_000022 Whole Database Backup
RMAN SCRIPT RMAN script
Configuring Backup Settings
Problem
You want to configure backup settings, such as degree of parallelism, backup location, default backup type,
and MML settings.
