Catalog Backup to another server?

Question

We are trying to copy the catalog for the OBIEE 11g from the production to a dev environment; Does anyone suggest  any recommended method? We want to make sure the security structure stays intact. Linux copy process seems to be working. However, when I try to replace existing users it's failing. Also, Oracle don't recommend using that process. Using Catalog Manager copy/Paste generates  Error Codes: C64RS3Z2

thanks,

Abu

[Deleted User] · Answer

Runcat command line - archive function.

runcat.sh -cmd archive -help

Geoff Winkworth · Answer

To what extent exactly are you looking to replicate the environments?  Are you really trying to pull users across as well?  And you say Archive / Unarchive does not meet your needs?

We've done piecemeal copying behind the scenes in the past, but it was only when we were in a mixed 12.2.1.0 / 12.2.1.2 environment and users needed to move content from the newer environment to the older one.  Other than that, when it comes to moving in bulk from development to production, we've always used Archive / Unarchive.

Charles M · Answer

Hi abuK,

Could you use rsync (rsync -a)?

Also, are you using an OS method like: tar czvpf?

Regards,

Charles