Forum Stats

  • 3,839,871 Users
  • 2,262,546 Discussions
  • 7,901,088 Comments

Discussions

Orphaned data in Oracle Database Backup Service

Simon_DBA
Simon_DBA Member Posts: 45 Bronze Badge
edited Apr 27, 2016 10:12PM in Database Cloud Service

Here's a scenario that's a problem with the Oracle Database Backup Service (ODBS).  This isn't a rant against Oracle - rather I'm just illustrating a possible configuration or sequence of events with the ODBS that could cause a serious issue given the current restrictions of the ODBS.

Months ago I created a database, backed it up to the Oracle Database Backup Service via the OPC RMAN module, deleted all backups, and removed the database.  Now months later I notice that the Oracle Database Backup Service still shows 12MB of storage being used.  Now I thought that I had properly deleted all of the backup files on the ODBS through RMAN.  At least RMAN didn't list any backups.  But something must still be there.

And that's the problem:  The Oracle Database Backup Service provides me no way of seeing what's using up the 12MB.  I can't see the backup piece or file name.  And similarly I can't delete it.  I contacted Oracle who said that I need to manipulate the files through RMAN.  But again, I can't catalog a SBT_TAPE backup piece so I can then delete it without knowing the piece name.  Hence I'm stuck.  Data backed up to the ODBS doesn't show in the Oracle Storage Cloud Service at all so I can't view or manipulate the file(s) there either.

And another interesting anomaly: last Tuesday it shows the space usage as dipping down from ~12MB to ~10.5MB.  Then last Wednesday it's back up to the ~12MB.  I'm clearly not accessing this file(s) so this also shows that Oracle's ability to monitor the space used is suspect.

Contacted the Oracle Cloud help who said that since I have a trial account I convert into a paid account so they could investigate the issue.  But sorry, that's not a very good trial as they're essentially saying to me "try our products for free and if they don't work, then pay us with a paid account and we'll look at why it doesn't work for you".  I equate it to "test drive this new car and if you can't work out how to turn on the air conditioning, just buy the car and then our mechanics will help you".  On that argument they said they would look into it and email me back but I'm yet to hear anything.

If this was an AWS S3 backup using Oracle Secure Backup I could still access the bucket via the AWS management console where I could see the RMAN backup piece name so I could catalog it with RMAN or just delete it right there from the AWS console.  But with the Oracle Database Backup Service there's no such option to view the details or manually delete the content so I'm stuck with the data.


Seems like how they've tightened down access to the ODBS storage through RMAN interfaces only poses some pretty serious problems.  It's certainly possible that a DBA backs up a database to this service, and decommissions the database prior to removing all of the ODBS backup data only to later discover that it's now orphaned.

Comments

  • Rituraj Jain-Oracle
    Rituraj Jain-Oracle Member Posts: 123
    edited Feb 11, 2016 5:18AM

    As per your description we understand that are using an Oracle cloud trial environment. Please visit https://cloud.oracle.com/home -> connect “Chat Now” and request the available agent to raise a SR on your reported issue as for that we need your trial details (like Username, Identity Domain and Order-ID). You may also share the reference of this OTN thread to the available agent to understand the issue. We will surely look into the issue and assist aptly.

  • Simon_DBA
    Simon_DBA Member Posts: 45 Bronze Badge
    edited Feb 11, 2016 9:31AM

    Actually I went through that process twice.  Went through the chat and requested an SR.  Was promised that someone would contact me back on this issue but nobody ever did.  Instead I was just sent a link to the main RMAN online documentation during the chat.

    So been there, tried that.  Have the chat details saved though I won't post the conversation to this public forum.  This was all before initiating this thread.

    It's only after trying the chat->SR process twice unsuccessfully did I come to this forum/posting instead.

  • Rituraj Jain-Oracle
    Rituraj Jain-Oracle Member Posts: 123
    edited Feb 23, 2016 12:58AM

    We would recommend you to start fresh and register for a new trial environment and check if the issue is now fixed.

  • brian_spendolini-Oracle
    brian_spendolini-Oracle Posts: 434 Employee
    edited Feb 23, 2016 6:58AM

    OK...lets get this sorted...

    To start, you can use the REST services for object storage to list the content of the backup container. How comfortable are you with the REST services for object store?

    Im going to also make this post visable to the ODBS PMs...see if they have any insight.

  • Sridhar.R-Oracle
    Sridhar.R-Oracle Member Posts: 18
    edited Feb 26, 2016 4:11PM

    We are working on getting an UI to browse objects, create container etc. In the meanwhile, you can see the list of objects in your container.

    1. Get the Auth token

    curl -v -s -X GET -H "X-Storage-User: <ServiceName>-<IDDomainname>:<uesrid>“  -H "X-Storage-Pass: <password>“   https://<IDDomainname>.storage.oraclecloud.com/auth/v1.0

    2. Copy AUTH Token and get the container list

    curl -v -X GET -H "X-Auth-Token: <AUTH Token>“ https://<IDDomainname>.storage.oraclecloud.com/v1/<ServiceName>-<IDDomainname>?limit=10

    3. Then you can list the objects in the container..

    curl -v -X GET -H "X-Auth-Token: <AUTH Token>“ https://<IDDomainname>.storage.oraclecloud.com/v1/<ServiceName>-<IDDomainname>/<containername>

    Alternative options are to use 3rd party tools like Cloudberry explorer etc.

    Sridhar

  • Simon_DBA
    Simon_DBA Member Posts: 45 Bronze Badge
    edited Feb 29, 2016 11:37AM

    ^ Aren't those commands for Cloud storage?  The issue I'm inquiring about is specific to ODBS storage only which does not appear under "Oracle Cloud Storage Service".   Just confirming - thanks.

  • Sridhar.R-Oracle
    Sridhar.R-Oracle Member Posts: 18
    edited Apr 27, 2016 10:12PM

    Sorry for the delayed reply. Yes. Behind the scene, the backup service uses storage cloud service (object storage). So, if you cannot see / delete from RMAN, you may have to run either CURL or Swift CLI commands to list objects.

    Simpler commands to list the objects would be :

    To list all the containers for an account:
    curl -v -u '[email protected]:myPassword -X GET https://myDomain.storage.oraclecloud.com/v1/myService-myDomain

    To list all the objects under a container:
    curl -v -u '[email protected]:myPassword -X GET https://myDomain.storage.oraclecloud.com/v1/myService-myDomain/myContainer

This discussion has been closed.