Database Backup and Recovery (MOSC)

MOSC Banner

RMAN Catalog 12.1 cannot be exported without EXEMPT ACCESS POLICY

edited Oct 24, 2014 10:03AM in Database Backup and Recovery (MOSC) 3 commentsAnswered

RMAN:  12.1.0.2

Database 12.1.0.2

I created the RMAN Catalog 12.1 in its own schema (RMAN_CAT_12) in a 12.1.0.2 database with the CREATE CATALOG command.  It's working well.

I run nightly exports of the entire database.

Now that I've added the catalog to this database, the expdp fails with multiple ORA-39181: Only partial table data may be exported due to fine grain access control on "RMAN_CAT_12".<object>.

Talks about how to get around this by granting system privilege EXEMPT ACCESS POLICY to the user exporting the schema. 

The exports are done as SYSTEM, so I did so.  It now works. 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center