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