HOWTO - restore and recover database in Oracle Database Cloud Service.
Luke Martin Feldman
![Luke Martin Feldman]()
Luke Martin Feldman
Senior OCI Cloud Evangelist | DevOps | Terraform | Multicloud
DBA knows that monitoring and backups are most important things in his work. For that reason in my journey to Oracle Database Cloud Service within Oracle Public Cloud sooner or later I should explore the question of restore & recovery procedures. I think today I would like to show how to do it in scenario of single instance in cloud. :-)
STEP 1. First you need to make SSH session to a VM where database has been deployed and with the usage of dbaascli utility with the command orec --args list you should check if you have any backups available for your usage:
STEP 2. Next you should execute command orec --args latest to have your database restored to the latest backup you have:
That is all for tonight! Stay tuned :-)
CX/EX nerd, transforming & fixing broken systems with empathy, storytelling, analytics, agility, creativity, and digital transformation. Boosting human and customer-centricity | Medallia Certified
8 年Hi Syed, just want to add few points on the context. All the crucial commands needs root/super user access to perform those activities. The very reason for that is its highly critical and complex. Most important part is we are dealing with clients data so mostly we rely on admins for these task. That's one of the reason why DBA are hired after great thought process and one of the factor is reliability. One mistake can make huge impact in the system. Abhinivesh Jain I think the only reason which I can think of why they would not provide these commands is for keeping difference between cloud and premises platform. There should be some difference which they can base to grab business, projects, make company to adopt new platform and in the end increase business and revenue ultimately. Just an thought :) Hope this was helpful! Cheers! Sandip
Principal Architect- AWS | AWS Ambassador | 13x AWS Certified
8 年This is good. I think Oracle should introduce such simple recovery commands for non-cloud databases as well.
for restore and recovery, connect to the VM machine as opc user and then do sudo -s to get root access.
I just tried other commands like database bounce, listener status etc, it worked fine with oracle user. I guess few commands needs root access
Senior OCI Cloud Evangelist | DevOps | Terraform | Multicloud
8 年True and it is a little bit strange ;-)