Production Catalog Backup Process — Oracle Analytics

Oracle Analytics Cloud and Server Idea Lab

Home› Oracle Analytics› Oracle Analytics Idea Labs› Oracle Analytics Cloud and Server Idea Lab

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Production Catalog Backup Process

Needs Votes
174
Views
4
Comments
Anaise Higgins - Oracle
Anaise Higgins - Oracle Rank 4 - Community Specialist
in Oracle Analytics Cloud and Server Idea Lab

Description

Be able to schedule a process to backup the Production Catalog and then restore from a previous backup. Currently, this backup process is being done weekly manually. Ideally, this would be an automatic process.

Use Case and Business Need

Needed to keep track of items in the catalog and restore any projects that may have been removed/deleted but are actually needed.

Original Idea Number: ad7ed21053

Tagged:
4
Up
4 votes

Needs Votes · Last Updated

Comments

  • Alan Lee - Oracle-Oracle
    Alan Lee - Oracle-Oracle Mod

    Have you looked at runcat command line to automate backup? This is available in the administration client download and runcat -help will list specific operations

  • Adam Bloom-Oracle
    Adam Bloom-Oracle Mod

    Snapshots are your best approach for a full backup and restore.  OAS has command line scripts that you can use to automate these.  OAC has a Data Migration Utility (and a REST API in the works).   However, if you need to be more granular about what to backup or restore you might look at the Catalog Manager's command line (runcat) as mentioned by Alan.

  • MaartenDIF
    MaartenDIF Rank 4 - Community Specialist

    We had a couple of incident in the last months. Among others, there was an occasion where a folder was moved (breaking DM/Report links) and on another occasion an entire folder was deleted. Fortunately we could restore it using the Archive/Unarchive function using our TEST environment.

    This made us realise how fragile this setup is. If an entire folder disappears and we cannot restore it within half a day, results could be a catastrophe for the operations.

    We'd love to automate this process.

    Slightly off-topic: Is there also other Oracle users who might want to share their current workaround on how they do version management and fall-back scenarios without this feature built-in?

  • MaartenDIF
    MaartenDIF Rank 4 - Community Specialist

    @Adam Bloom-Oracle is there any documentation available on those OAS command line scripts or OAC functionality? Is this included without any additional license requirements?