Oracle Communities

Oracle Analytics and AI

Child Item

Restore a Catalog Folder from Snapshot

Hello,

Is there a way to restore a specific folder from an OAC Snapshot? While we understand that it's possible to restore the entire catalog, our users are specifically asking if it's possible to restore just a single folder in case something happens to it.

Thanks,

Subhakara

Find more posts tagged with

Oracle Analytics Cloud

Workbooks and Reports

OAC export

Accepted answers

SteveF-Oracle

To add further, the supported steps for moving individual catalog objects are documented here:

Note: This is not specifically "restore a specific folder from an OAC Snapshot", rather a method that individual catalog objects can be moved. When moving entire folders, be mindful of size.

Migrate Content to Other Catalogs
CLI Example: Unarchive a Catalog Archive

Helpful blog
https://blogs.oracle.com/analytics/post/incremental-migration-of-catalog-objects-in-oracle-analytics

All comments

Sumanth V -Oracle

@Subhakara Netala-Oracle - We have the following options to back up specific catalog folders:

Backup of Individual Catalog Folders:
- It is possible to take a backup of a specific catalog folder directly. This ensures that only the required folder is backed up without the need to back up the entire catalog.
Extracting Content from a BAR File (Not Oracle-Recommended):
- By unzipping the BAR file, you can access the catalog content.
- The required folder can be downloaded from the extracted content and imported back into the system if necessary.
- Note: This method is not recommended by Oracle, and caution should be exercised during implementation.

Subhakara Netala-Oracle

Thanks @Sumanth V -Oracle. Is there any doc or do you have steps to extract content from a bar file? We would like to give a try this even though it is not recommended.

[Deleted User]

Hi Subhakara,

You can extract the catalog in full fil format using the command documented here since the RPD or catalog extraction requires the whole BAR/snapshot to be decompressed:

https://docs.oracle.com/en/applications/business-intelligence-applications/103/upgrade-guide/upgrade-repository.html

From there you have a standard catalog against which you can for example run the runcat command line as desired.

Michal Zima

Hi @Subhakara Netala-Oracle , just one adding to @Sumanth V -Oracle and @Christian Berg-0racle : After extracting complete catalog from BAR file, you can open it using Catalog Manager GUI (you need to use version of client sw, which still have it) , then create archive for particular folder (File → Archive) of catalog and then apply this archive (againg using Catalog Manager GUI with online connections) to target OA environment

SteveF-Oracle

Migrate Content to Other Catalogs
CLI Example: Unarchive a Catalog Archive

Helpful blog
https://blogs.oracle.com/analytics/post/incremental-migration-of-catalog-objects-in-oracle-analytics

Subhakara Netala-Oracle

Thank you all for your suggestions. We will check.

[Deleted User]

https://community.oracle.com/products/oracleanalytics/discussion/comment/63237#Comment_63237

Thanks @Michal Zima I also keep an client tools install around for that reason. But the command line does it all as well.

Cheers!

[Deleted User]

https://community.oracle.com/products/oracleanalytics/discussion/comment/63247#Comment_63247

That's the unfortunate disadvatange of REST vs the original APIs: Everything has to be online. You can't simply go into one of your backups and grab something of a folder or object has been deleted/corrupted/… You always have to have the whole snapshot running in some instance.

Runcat was much more simple, direct, and to the point with one single command that had 150 functions.