/AWS1/IF_ODB=>GETAUTONOMOUSDATABASE()

About GetAutonomousDatabase

Gets information about a specific Autonomous Database.

Method Signature

METHODS /AWS1/IF_ODB~GETAUTONOMOUSDATABASE
  IMPORTING
    !IV_AUTONOMOUSDATABASEID TYPE /AWS1/ODBRESOURCEIDORARN OPTIONAL
  RETURNING
    VALUE(OO_OUTPUT) TYPE REF TO /aws1/cl_odbgetatnmsdbaseout
  RAISING
    /AWS1/CX_ODBACCESSDENIEDEX
    /AWS1/CX_ODBINTERNALSERVEREX
    /AWS1/CX_ODBRESOURCENOTFOUNDEX
    /AWS1/CX_ODBTHROTTLINGEX
    /AWS1/CX_ODBVALIDATIONEX
    /AWS1/CX_ODBCLIENTEXC
    /AWS1/CX_ODBSERVEREXC
    /AWS1/CX_RT_TECHNICAL_GENERIC
    /AWS1/CX_RT_SERVICE_GENERIC.

IMPORTING

Required arguments:

iv_autonomousdatabaseid TYPE /AWS1/ODBRESOURCEIDORARN /AWS1/ODBRESOURCEIDORARN

The unique identifier of the Autonomous Database to retrieve information about.

RETURNING

oo_output TYPE REF TO /aws1/cl_odbgetatnmsdbaseout /AWS1/CL_ODBGETATNMSDBASEOUT

Examples

Syntax Example

This is an example of the syntax for calling the method. It includes every possible argument and initializes every possible value. The data provided is not necessarily semantically accurate (for example the value "string" may be provided for something that is intended to be an instance ID, or in some cases two arguments may be mutually exclusive). The syntax shows the ABAP syntax for creating the various data structures.

DATA(lo_result) = lo_client->getautonomousdatabase( |string| ).

This is an example of reading all possible response values

lo_result = lo_result.
IF lo_result IS NOT INITIAL.
  lo_autonomousdatabase = lo_result->get_autonomousdatabase( ).
  IF lo_autonomousdatabase IS NOT INITIAL.
    lv_resourceidorarn = lo_autonomousdatabase->get_autonomousdatabaseid( ).
    lv_resourcearn = lo_autonomousdatabase->get_autonomousdatabasearn( ).
    lv_string = lo_autonomousdatabase->get_ociresourceanchorname( ).
    lv_float = lo_autonomousdatabase->get_percentprogress( ).
    lv_string = lo_autonomousdatabase->get_ocid( ).
    lv_string = lo_autonomousdatabase->get_ociurl( ).
    lv_string = lo_autonomousdatabase->get_displayname( ).
    lv_string = lo_autonomousdatabase->get_dbname( ).
    lv_string = lo_autonomousdatabase->get_sourceid( ).
    lv_autonomousdatabaseresou = lo_autonomousdatabase->get_status( ).
    lv_string = lo_autonomousdatabase->get_statusreason( ).
    lv_databasetype = lo_autonomousdatabase->get_databasetype( ).
    lv_string = lo_autonomousdatabase->get_dbversion( ).
    lv_dbworkload = lo_autonomousdatabase->get_dbworkload( ).
    lv_string = lo_autonomousdatabase->get_characterset( ).
    lv_string = lo_autonomousdatabase->get_ncharacterset( ).
    lv_databaseedition = lo_autonomousdatabase->get_databaseedition( ).
    lv_licensemodel = lo_autonomousdatabase->get_licensemodel( ).
    lv_openmode = lo_autonomousdatabase->get_openmode( ).
    lv_permissionlevel = lo_autonomousdatabase->get_permissionlevel( ).
    lv_boolean = lo_autonomousdatabase->get_ismtlsconnectionrequired( ).
    lv_autonomousmaintenancesc = lo_autonomousdatabase->get_atnmsmaintscheduletype( ).
    lv_netservicesarchitecture = lo_autonomousdatabase->get_netservicesarchitecture( ).
    LOOP AT lo_autonomousdatabase->get_availableupgradeversions( ) into lo_row.
      lo_row_1 = lo_row.
      IF lo_row_1 IS NOT INITIAL.
        lv_string = lo_row_1->get_value( ).
      ENDIF.
    ENDLOOP.
    lv_integer = lo_autonomousdatabase->get_byolcomputecountlimit( ).
    lo_autonomousdatabaseconne = lo_autonomousdatabase->get_connectionstringdetails( ).
    IF lo_autonomousdatabaseconne IS NOT INITIAL.
      LOOP AT lo_autonomousdatabaseconne->get_allconnectionstrings( ) into ls_row_2.
        lv_key = ls_row_2-key.
        lo_value = ls_row_2-value.
        IF lo_value IS NOT INITIAL.
          lv_string = lo_value->get_value( ).
        ENDIF.
      ENDLOOP.
      lv_string = lo_autonomousdatabaseconne->get_dedicated( ).
      lv_string = lo_autonomousdatabaseconne->get_high( ).
      lv_string = lo_autonomousdatabaseconne->get_medium( ).
      lv_string = lo_autonomousdatabaseconne->get_low( ).
      LOOP AT lo_autonomousdatabaseconne->get_profiles( ) into lo_row_3.
        lo_row_4 = lo_row_3.
        IF lo_row_4 IS NOT INITIAL.
          lv_string = lo_row_4->get_consumergroup( ).
          lv_string = lo_row_4->get_displayname( ).
          lv_string = lo_row_4->get_hostformat( ).
          lv_boolean = lo_row_4->get_isregional( ).
          lv_string = lo_row_4->get_protocol( ).
          lv_string = lo_row_4->get_sessionmode( ).
          lv_string = lo_row_4->get_syntaxformat( ).
          lv_string = lo_row_4->get_tlsauthentication( ).
          lv_string = lo_row_4->get_value( ).
        ENDIF.
      ENDLOOP.
    ENDIF.
    lv_string = lo_autonomousdatabase->get_serviceconsoleurl( ).
    lv_string = lo_autonomousdatabase->get_sqlwebdeveloperurl( ).
    LOOP AT lo_autonomousdatabase->get_customercontacts( ) into lo_row_5.
      lo_row_6 = lo_row_5.
      IF lo_row_6 IS NOT INITIAL.
        lv_sensitivestring = lo_row_6->get_email( ).
      ENDIF.
    ENDLOOP.
    lo_autonomousdatabaseapex = lo_autonomousdatabase->get_apexdetails( ).
    IF lo_autonomousdatabaseapex IS NOT INITIAL.
      lv_string = lo_autonomousdatabaseapex->get_apexversion( ).
      lv_string = lo_autonomousdatabaseapex->get_ordsversion( ).
    ENDIF.
    lo_databasestandbysummary = lo_autonomousdatabase->get_standbydb( ).
    IF lo_databasestandbysummary IS NOT INITIAL.
      lv_string = lo_databasestandbysummary->get_availabilitydomain( ).
      lv_integer = lo_databasestandbysummary->get_lagtimeinseconds( ).
      lv_autonomousdatabaseresou = lo_databasestandbysummary->get_status( ).
      lv_string = lo_databasestandbysummary->get_statusreason( ).
      lv_string = lo_databasestandbysummary->get_mainttargetcomponent( ).
      lv_timestamp = lo_databasestandbysummary->get_timedataguardrolechanged( ).
      lv_timestamp = lo_databasestandbysummary->get_timedisastrrecrolechgd( ).
      lv_timestamp = lo_databasestandbysummary->get_timemaintenancebegin( ).
      lv_timestamp = lo_databasestandbysummary->get_timemaintenanceend( ).
    ENDIF.
    lo_databasestandbysummary = lo_autonomousdatabase->get_localstandbydb( ).
    IF lo_databasestandbysummary IS NOT INITIAL.
      lv_string = lo_databasestandbysummary->get_availabilitydomain( ).
      lv_integer = lo_databasestandbysummary->get_lagtimeinseconds( ).
      lv_autonomousdatabaseresou = lo_databasestandbysummary->get_status( ).
      lv_string = lo_databasestandbysummary->get_statusreason( ).
      lv_string = lo_databasestandbysummary->get_mainttargetcomponent( ).
      lv_timestamp = lo_databasestandbysummary->get_timedataguardrolechanged( ).
      lv_timestamp = lo_databasestandbysummary->get_timedisastrrecrolechgd( ).
      lv_timestamp = lo_databasestandbysummary->get_timemaintenancebegin( ).
      lv_timestamp = lo_databasestandbysummary->get_timemaintenanceend( ).
    ENDIF.
    lv_datasafestatus = lo_autonomousdatabase->get_datasafestatus( ).
    lv_databasemanagementstatu = lo_autonomousdatabase->get_databasemanagementstatus( ).
    lv_operationsinsightsstatu = lo_autonomousdatabase->get_operationsinsightsstatus( ).
    lv_string = lo_autonomousdatabase->get_availabilityzone( ).
    lv_string = lo_autonomousdatabase->get_availabilityzoneid( ).
    lv_string = lo_autonomousdatabase->get_mainttargetcomponent( ).
    lo_autonomousdatabaseconne_1 = lo_autonomousdatabase->get_connectionurls( ).
    IF lo_autonomousdatabaseconne_1 IS NOT INITIAL.
      lv_string = lo_autonomousdatabaseconne_1->get_apexurl( ).
      lv_string = lo_autonomousdatabaseconne_1->get_databasetransformsurl( ).
      lv_string = lo_autonomousdatabaseconne_1->get_graphstudiourl( ).
      lv_string = lo_autonomousdatabaseconne_1->get_mlnotebookurl( ).
      lv_string = lo_autonomousdatabaseconne_1->get_mlusermanagementurl( ).
      lv_string = lo_autonomousdatabaseconne_1->get_mongodburl( ).
      lv_string = lo_autonomousdatabaseconne_1->get_ordsurl( ).
      lv_string = lo_autonomousdatabaseconne_1->get_spatialstudiourl( ).
      lv_string = lo_autonomousdatabaseconne_1->get_sqldevweburl( ).
    ENDIF.
    LOOP AT lo_autonomousdatabase->get_dbtoolsdetails( ) into lo_row_7.
      lo_row_8 = lo_row_7.
      IF lo_row_8 IS NOT INITIAL.
        lv_boolean = lo_row_8->get_isenabled( ).
        lv_string = lo_row_8->get_name( ).
        lv_double = lo_row_8->get_computecount( ).
        lv_integer = lo_row_8->get_maxidletimeinminutes( ).
      ENDIF.
    ENDLOOP.
    LOOP AT lo_autonomousdatabase->get_scheduledoperations( ) into lo_row_9.
      lo_row_10 = lo_row_9.
      IF lo_row_10 IS NOT INITIAL.
        lo_dayofweek = lo_row_10->get_dayofweek( ).
        IF lo_dayofweek IS NOT INITIAL.
          lv_dayofweekname = lo_dayofweek->get_name( ).
        ENDIF.
        lv_string = lo_row_10->get_scheduledstarttime( ).
        lv_string = lo_row_10->get_scheduledstoptime( ).
      ENDIF.
    ENDLOOP.
    lv_string = lo_autonomousdatabase->get_resourcepoolleaderid( ).
    lv_float = lo_autonomousdatabase->get_computecount( ).
    lv_computemodel = lo_autonomousdatabase->get_computemodel( ).
    lv_integer = lo_autonomousdatabase->get_cpucorecount( ).
    lv_integer = lo_autonomousdatabase->get_memperoraclecompunitin00( ).
    LOOP AT lo_autonomousdatabase->get_provisionablecpus( ) into lo_row_11.
      lo_row_12 = lo_row_11.
      IF lo_row_12 IS NOT INITIAL.
        lv_integer = lo_row_12->get_value( ).
      ENDIF.
    ENDLOOP.
    lv_boolean = lo_autonomousdatabase->get_isautoscalingenabled( ).
    lv_double = lo_autonomousdatabase->get_datastoragesizeintbs( ).
    lv_integer = lo_autonomousdatabase->get_datastoragesizeingbs( ).
    lv_double = lo_autonomousdatabase->get_useddatastoragesizeintbs( ).
    lv_integer = lo_autonomousdatabase->get_useddatastoragesizeingbs( ).
    lv_double = lo_autonomousdatabase->get_actluseddatastrgsizintbs( ).
    lv_double = lo_autonomousdatabase->get_allocstoragesizeintbs( ).
    lv_integer = lo_autonomousdatabase->get_inmemoryareaingbs( ).
    lv_boolean = lo_autonomousdatabase->get_isautoscforstorageenbld( ).
    lv_resourceid = lo_autonomousdatabase->get_odbnetworkid( ).
    lv_resourcearn = lo_autonomousdatabase->get_odbnetworkarn( ).
    lv_string = lo_autonomousdatabase->get_privateendpoint( ).
    lv_string = lo_autonomousdatabase->get_privateendpointip( ).
    lv_string = lo_autonomousdatabase->get_privateendpointlabel( ).
    LOOP AT lo_autonomousdatabase->get_allowlistedips( ) into lo_row.
      lo_row_1 = lo_row.
      IF lo_row_1 IS NOT INITIAL.
        lv_string = lo_row_1->get_value( ).
      ENDIF.
    ENDLOOP.
    LOOP AT lo_autonomousdatabase->get_standbyallowlistedips( ) into lo_row.
      lo_row_1 = lo_row.
      IF lo_row_1 IS NOT INITIAL.
        lv_string = lo_row_1->get_value( ).
      ENDIF.
    ENDLOOP.
    lv_standbyallowlistedipsso = lo_autonomousdatabase->get_standbyalwlstipssource( ).
    lv_boolean = lo_autonomousdatabase->get_islocaldataguardenabled( ).
    lv_boolean = lo_autonomousdatabase->get_isremotedataguardenabled( ).
    lv_disasterrecoverytype = lo_autonomousdatabase->get_localdisastrrecoverytype( ).
    lv_dataguardrole = lo_autonomousdatabase->get_role( ).
    LOOP AT lo_autonomousdatabase->get_peerdbids( ) into lo_row.
      lo_row_1 = lo_row.
      IF lo_row_1 IS NOT INITIAL.
        lv_string = lo_row_1->get_value( ).
      ENDIF.
    ENDLOOP.
    lv_integer = lo_autonomousdatabase->get_faileddatarecinseconds( ).
    lv_integer = lo_autonomousdatabase->gt_locadgautflovrmaxdatlos00( ).
    lo_disasterrecoveryconfigu = lo_autonomousdatabase->get_remotedisastrrecconf( ).
    IF lo_disasterrecoveryconfigu IS NOT INITIAL.
      lv_disasterrecoverytype = lo_disasterrecoveryconfigu->get_disasterrecoverytype( ).
      lv_boolean = lo_disasterrecoveryconfigu->get_isrplteautomaticbackups( ).
      lv_boolean = lo_disasterrecoveryconfigu->get_issnapshotstandby( ).
      lv_timestamp = lo_disasterrecoveryconfigu->get_timesnapstandbyenbldtill( ).
    ENDIF.
    lv_boolean = lo_autonomousdatabase->get_isrefreshableclone( ).
    lv_refreshablemode = lo_autonomousdatabase->get_refreshablemode( ).
    lv_refreshablestatus = lo_autonomousdatabase->get_refreshablestatus( ).
    lv_integer = lo_autonomousdatabase->get_autorefreshfreqinseconds( ).
    lv_integer = lo_autonomousdatabase->get_autorefrpointlaginsecs( ).
    lv_boolean = lo_autonomousdatabase->get_isreconnectcloneenabled( ).
    LOOP AT lo_autonomousdatabase->get_clonetablespacelist( ) into lo_row_11.
      lo_row_12 = lo_row_11.
      IF lo_row_12 IS NOT INITIAL.
        lv_integer = lo_row_12->get_value( ).
      ENDIF.
    ENDLOOP.
    lv_integer = lo_autonomousdatabase->get_backupretperiodindays( ).
    lo_longtermbackupschedule = lo_autonomousdatabase->get_longtermbackupschedule( ).
    IF lo_longtermbackupschedule IS NOT INITIAL.
      lv_boolean = lo_longtermbackupschedule->get_isdisabled( ).
      lv_repeatcadence = lo_longtermbackupschedule->get_repeatcadence( ).
      lv_integer = lo_longtermbackupschedule->get_retentionperiodindays( ).
      lv_timestamp = lo_longtermbackupschedule->get_timeofbackup( ).
    ENDIF.
    lv_boolean = lo_autonomousdatabase->get_isbackupretentionlocked( ).
    lv_double = lo_autonomousdatabase->get_totalbackupstrgsizeingbs( ).
    lo_resourcepoolsummary = lo_autonomousdatabase->get_resourcepoolsummary( ).
    IF lo_resourcepoolsummary IS NOT INITIAL.
      lv_boolean = lo_resourcepoolsummary->get_isdisabled( ).
      lv_integer = lo_resourcepoolsummary->get_poolsize( ).
      lv_integer = lo_resourcepoolsummary->get_poolstoragesizeintbs( ).
      lv_double = lo_resourcepoolsummary->get_availstoragecapintbs( ).
      lv_integer = lo_resourcepoolsummary->get_totalcomputecapacity( ).
      lv_integer = lo_resourcepoolsummary->get_availablecomputecapacity( ).
    ENDIF.
    lo_encryptionsummary = lo_autonomousdatabase->get_encryptionsummary( ).
    IF lo_encryptionsummary IS NOT INITIAL.
      lv_encryptionkeyprovider = lo_encryptionsummary->get_encryptionkeyprovider( ).
      lo_encryptionkeyconfigurat = lo_encryptionsummary->get_encryptionkeyconf( ).
      IF lo_encryptionkeyconfigurat IS NOT INITIAL.
        lo_awsencryptionkeyconfigu = lo_encryptionkeyconfigurat->get_awsencryptionkey( ).
        IF lo_awsencryptionkeyconfigu IS NOT INITIAL.
          lv_rolearn = lo_awsencryptionkeyconfigu->get_iamrolearn( ).
          lv_externalidtype = lo_awsencryptionkeyconfigu->get_externalidtype( ).
          lv_kmskeyidorarn = lo_awsencryptionkeyconfigu->get_kmskeyid( ).
        ENDIF.
        lo_ociencryptionkeyconfigu = lo_encryptionkeyconfigurat->get_ociencryptionkey( ).
        IF lo_ociencryptionkeyconfigu IS NOT INITIAL.
          lv_string = lo_ociencryptionkeyconfigu->get_kmskeyid( ).
          lv_string = lo_ociencryptionkeyconfigu->get_vaultid( ).
        ENDIF.
        lo_okvencryptionkeyconfigu = lo_encryptionkeyconfigurat->get_okvencryptionkey( ).
        IF lo_okvencryptionkeyconfigu IS NOT INITIAL.
          lv_string = lo_okvencryptionkeyconfigu->get_certificatedirectoryname( ).
          lv_string = lo_okvencryptionkeyconfigu->get_certificateid( ).
          lv_string = lo_okvencryptionkeyconfigu->get_directoryname( ).
          lv_string = lo_okvencryptionkeyconfigu->get_okvkmskey( ).
          lv_string = lo_okvencryptionkeyconfigu->get_okvuri( ).
        ENDIF.
      ENDIF.
    ENDIF.
    lv_timestamp = lo_autonomousdatabase->get_createdat( ).
    lv_timestamp = lo_autonomousdatabase->get_timeoflastbackup( ).
    lv_timestamp = lo_autonomousdatabase->get_timemaintenancebegin( ).
    lv_timestamp = lo_autonomousdatabase->get_timemaintenanceend( ).
    lv_timestamp = lo_autonomousdatabase->get_timelocaldataguardenbld( ).
    lv_timestamp = lo_autonomousdatabase->get_timedataguardrolechanged( ).
    lv_timestamp = lo_autonomousdatabase->get_timeoflastswitchover( ).
    lv_timestamp = lo_autonomousdatabase->get_timeoflastfailover( ).
    lv_timestamp = lo_autonomousdatabase->get_timeoflastrefresh( ).
    lv_timestamp = lo_autonomousdatabase->get_timeoflastrefreshpoint( ).
    lv_timestamp = lo_autonomousdatabase->get_timeofnextrefresh( ).
    lv_timestamp = lo_autonomousdatabase->get_timeofautorefreshstart( ).
    lv_timestamp = lo_autonomousdatabase->get_timedltnoffreeatnmsdbase( ).
    lv_timestamp = lo_autonomousdatabase->get_tmerclmtnoffreatnmsdbase( ).
    lv_timestamp = lo_autonomousdatabase->get_timedisastrrecrolechgd( ).
    lv_timestamp = lo_autonomousdatabase->get_tmeuntilrecnctcloneenbld( ).
    lv_timestamp = lo_autonomousdatabase->get_nextlongtermbackuptsmp( ).
    lv_timestamp = lo_autonomousdatabase->get_timeundeleted( ).
  ENDIF.
ENDIF.