edit_dbprofile
Edits the schedule and purge policy of an existing database profile.
Format
emcli edit_dbprofile -comp_loc="Database Profile component location in software library" [-schedule= [NONE]|[frequency:interval|weekly|monthly|yearly]; start_time:yy-MM-dd HH:mm; end_time:yy-MM-dd HH:mm; [repeat:#m]; [months:#,#,#,...]; [days:#,#,#,...]; [tz:{java timezone ID}]; [grace_period:xxx]; ] [-purge_policy= DAYS|SNAPSHOTS: number] [ ] indicates that the parameter is optional.
Options
-
comp_loc
A combination of the database profile location and name.
-
schedule
-
frequency: The frequency type with which the databse profile will be created. It can be an interval (in minutes), weekly, monthly, or yearly.
-
start_time: Denotes the start time of Database Profile Component Creation in the format yy-MM-dd HH:mm.
-
end_time: Denotes the end time of Database Profile Component Creation Repetition in the format yy-MM-dd HH:mm
-
repeat: The repetition rate at which database profile will be created. If the frequency is an interval, then repeat is in minutes.
-
months: The number of months after which the repetition of Database Profile Component Creation will occur.
-
days: The number of days after which repetition of Database Profile Component Creation will occur.
-
tz: The time zone ID, for example tz:America/New_York.
-
grace_period: A period of time in minutes that defines the maximum permissible delay when attempting to create a databasse profile. If the job system cannot start the execution within a time period equal to the scheduled time plus the grace period, it will set the create database profile to be skipped. By default, the grace period is indefinite.
-
-
purge_policy
You can purge the collected data based on a specified number of days (DAYS) or a count of snapshots (SNAPSHOT). If the purge_policy parameter is not specified, then it is defaulted to NONE.
Exit Codes
0 if successful. A non-zero value indicates that verb processing was unsuccessful.
Example
The following example edits the schedule and purge policy database profile RMAN_Profile with the location Database Provisioning Profiles/11.2.0.4.0/linux_x64
.
emcli edit_dbprofile -comp_loc="Database Provisioning Profiles/11.2.0.4.0/linux_x64/RMAN_Profile" -schedule="frequency:interval;start_time:14-10-05 05:30;end_time: 14-10-12 05:23;repeat:30;grace_period:60;tz:America/New_York" -purge_policy=DAYS:2