awrwh_add_src_db
Adds a database as a source to the AWR Warehouse.
Prerequisites:
-
AWR Warehouse should be configured.
-
The database being added cannot be:
-
An instance of a RAC database
-
The AWR Warehouse
-
-
The database user should be a DBA.
-
The database user should have execute privilege on SYS.DBMS_SWRF_INTERNAL.
Format
emcli awrwh_add_src_db -target_name=<target_database_name> -target_type=<target_database_type> -db_cred=<target_database_named_credential> -db_host_cred=<target_database_host_named_credential> [-retention_days=<number_of_retention_days>] [-upload_interval=<snapshot_upload_interval>] -src_dir=<directory_to_store_extracted_dump_files> [ ] indicates that the parameter is optional
Options
-
target_name
Name of the target database added as a source to the AWR Warehouse.
-
target_type
Type of target. The possible values for target type are
oracle_database
,oracle_pdb
, andrac_database
. -
db_cred
Named credential for the target database.
-
db_host_cred
Named credential for the target database host.
-
retention_days
Number of days the AWR data will be retained in warehouse. The default value is one year.
-
upload_interval
Snapshot upload interval for the source database in AWR Warehouse. The default value is 24 hours.
-
src_dir
Directory to store extracted dump files. This is an optional parameter except for PDBs on cluster and by default the default agent directory is used.
Output
Success/Error message
Example
The following example adds the target database sample_database
as a
source to the AWR Warehouse:
emcli awrwh_add_src_db -target_name=sample_database -target_type=oracle_database -db_cred=DB1_NAMED_CRED -db_host_cred=TEST_HOST_CRED