How to restore datasets/projects deleted from OAC?

Chethana Kumari-Oracle

Summary

How to restore datasets/projects deleted from OAC?

Content

Some of the datasets/projects that were rarely used were deleted from 'Dataset Management'->Storage->Delete All

Apparently, this needs to be restored back now, as it is required for some reasons.

Is there a way to restore back these deleted datasets/projects in OAC, as a Service Administrator?

Please let me know.

 

Thanks,

Chethana

Aman Jain-Oracle

Hello Chethana,

You can restore your instance snapshot (Console -> Snapshots) which was created before this deletion, you will get all your content back (the instance will be the same as when the snapshot was taken).

Hope this helps!

Best Regards,

Aman Jain

Chethana Kumari-Oracle

Thanks Aman. Unfortunately, I have'nt taken any snapshot of the instance before deleting the datasets and projects.

This means I would not be able to restore, right?

Regards,

Chethana

Christian Berg -Oracle

Exactly. No backups mean that it's all gone.

Be mindful that "cloud" doesn't mean you don't have to think about the usual management tasks like backups, snapshots etc.

Jean-Pierre Hoedenaeken

Hi,

Indeed we have to manage backups to be safe, but what is also needed is to restore one dataset and not the entire snapshot ...

Moreover that functionnality is also relevant to promote a dataset from DEV to PRD.

Does anyone have a solution for that need please ?

Jean-Pierre

Michal Zima

@Jean-Pierre Hoedenaeken The only possibility (not very handy) is to backup individual data sets via DVA package (export of DV workbook) - this is meant for backup of DV workbook, but this backup (DVA binary file) - contains also all data sets, used by this DV workbook - their definitions, for file-based data sets also the files itself, for DB data sets also definitions of corresponding connections. So you can use this (as a kind of workaround) to backup data sets (you just need to create some "dummy" DV workbook, include corresponding data sets and then export to DVA package) - quite clumsy.....

This "functionality" should be (my opinion) part (meaning export/backup of individual data sets, including also content of file-based data sets) of long-promised Rest API for DV (or OAC/OAS whatever it will be called), which is still just "on the roadmap" , but no specific information about availability of this API yet.. We are calling (we are OAS customer) for it for long time - hopefully this will become reality soon (at least in OAC) and will provide rich functionality for all governance tasks (usually automated or semi-automated).

Jean-Pierre Hoedenaeken

Thanks Michal,

I suppose that furthermore we have to create the datasource connection under the exact same name ?

Jean-Pierre

Michal Zima

Do you mean on "target" environment, where you are about to import/restore DVA package ? If this is what you mean by your question, than no - import of DVA package also "restores" the definition of corresponding connection (used by data sets in DVA package).

Jean-Pierre Hoedenaeken

Indeed, both the connection definition and the dataset is imported inthe target environment.

So this workarround does the job.

Thanks again Michal.

Jean-Pierre Hoedenaeken

I see that the "Export" functionnality is also available on a "Folder" ...

Does that mean that all the content of the folder could be exported and the imported in the target environment, even "Classics" artifacts like Dashboards, Prompts, Requests, Agents, .... ?

Gianni Ceresa

The "Export" seems to be a hybrid between DV export and catalog archive. If you do export from Catalog in DV you get a file containing a catalog archive (the same good old archive that exist for more than 10 years) for everything that is just part of the catalog (folders, DV workbooks, analysis, dashboards, agents etc.) and the DV pieces like datasets, connections etc.

The catalog archive is really just that, you can even import it with Catalog Manager (the client) or in Catalog Manager in "classic" Answers if you want.