Oracle Communities

Oracle Analytics and AI

Child Item

Production Catalog Backup Process

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

Find more posts tagged with

Home and Catalog

Administration

Needs Votes

Status: Needs Votes

Comments

Alan Lee - Oracle-Oracle

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

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

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

@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?