"oci db backup list" not working with compartment-id parameter

[dbarj]

Hello.

AMAC02SJ3M7G8WN:~ rodrigo.jorge$ oci -v
2.12.13

If I try to get a specific DBaaS backup object, I can:

AMAC02SJ3M7G8WN:~ rodrigo.jorge$ oci --cli-rc-file /dev/null db backup get --backup-id ocid1.dbbackup.oc1.iad.abuwcljsvvlb6ymyoc4x4cmqh42qy2c2gnzq5hr6jw7jhowfrf4n66oegdoq
{
  "data": {
    "availability-domain": "CYtq:US-ASHBURN-AD-1",
    "compartment-id": "ocid1.compartment.oc1..aaaaaaaaysvxrbvyht4goajycwzxiulxvrqygtmed3ugzbpamrydot6xjskq",
    "database-edition": "ENTERPRISE_EDITION_HIGH_PERFORMANCE",
    "database-id": "ocid1.database.oc1.iad.abuwcljs3k7gngtjqgyqkiexolsgxrrmq55sypfwdtp3fawjrzgafnjhxwzq",
    "database-size-in-gbs": 4.181640625,
    "display-name": "Automatic Backup",
    "id": "ocid1.dbbackup.oc1.iad.abuwcljsvvlb6ymyoc4x4cmqh42qy2c2gnzq5hr6jw7jhowfrf4n66oegdoq",
    "lifecycle-details": null,
    "lifecycle-state": "ACTIVE",
    "shape": "VM.Standard2.1",
    "time-ended": "2020-10-03T08:41:47.821000+00:00",
    "time-started": "2020-10-03T08:19:25.263000+00:00",
    "type": "INCREMENTAL",
    "version": "19.8.0.0.0"
  },
  "etag": "4b86ebd4--gzip"
}

However, listing using the "compartment-id" parameter won't return any data:

AMAC02SJ3M7G8WN:~ rodrigo.jorge$ oci --cli-rc-file /dev/null db backup list --compartment-id ocid1.compartment.oc1..aaaaaaaaysvxrbvyht4goajycwzxiulxvrqygtmed3ugzbpamrydot6xjskq
AMAC02SJ3M7G8WN:~ rodrigo.jorge$

Using "db backup list" with "database-id" works.

AMAC02SJ3M7G8WN:~ rodrigo.jorge$ oci --cli-rc-file /dev/null db backup list --database-id ocid1.database.oc1.iad.abuwcljs3k7gngtjqgyqkiexolsgxrrmq55sypfwdtp3fawjrzgafnjhxwzq
{
  "data": [
    {
      "availability-domain": "CYtq:US-ASHBURN-AD-1",
      "compartment-id": "ocid1.compartment.oc1..aaaaaaaaysvxrbvyht4goajycwzxiulxvrqygtmed3ugzbpamrydot6xjskq",
      "database-edition": "ENTERPRISE_EDITION_HIGH_PERFORMANCE",
      "database-id": "ocid1.database.oc1.iad.abuwcljs3k7gngtjqgyqkiexolsgxrrmq55sypfwdtp3fawjrzgafnjhxwzq",
      "database-size-in-gbs": 4.181640625,
      "display-name": "Automatic Backup",
      "id": "ocid1.dbbackup.oc1.iad.abuwcljsvvlb6ymyoc4x4cmqh42qy2c2gnzq5hr6jw7jhowfrf4n66oegdoq",
      "lifecycle-details": null,
      "lifecycle-state": "ACTIVE",
      "shape": "VM.Standard2.1",
      "time-ended": "2020-10-03T08:41:47.821000+00:00",
      "time-started": "2020-10-03T08:19:25.263000+00:00",
      "type": "INCREMENTAL",
      "version": "19.8.0.0.0"
    }
  ]
}

Thanks, RJ

[HamadaGabrIbrahim]

@dbarj Thanks for bringing this here. I am looking into

[dbarj]

Thanks @HamadaGabrIbrahim , any plan to fix this issue soon? My collections are taking 10x more as I need to loop over every Database instead of every compartment to get the list of all backups. Thanks, RJ

[KartikShrikantHegde]

Hi @dbarj , This issue seems to be fixed in the latest CLI versions. The option compartment-id is returning a list of db backups in that given compartment. Could you please check now and confirm? Thanks.

[KartikShrikantHegde]

Hi @dbarj , I am closing this ticket for now, please feel free to re-open the issue if you still face the issue. Thanks.