Error Description
Whenever you try to create recovery catalog in rman with a user other than RECOVERY_CATALOG_OWNER role owner it fails with RMAN-06426: RECOVERY_CATALOG_OWNER role must be granted to user SHAIK.
-bash-3.00$ rman target sys/@moon:/SHAIK.MOON.SHAIK.NET catalog shaik/a
Recovery Manager: Release 10.2.0.1.0 - Production on Mon Aug 4 05:15:32 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
target database Password:
connected to target database: SHAIK(DBID=2855033675)
connected to recovery catalog database
RMAN> create catalog;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-06426: RECOVERY_CATALOG_OWNER role must be granted to user SHAIK
Cause of The Problem
The userid that was supplied in the CATALOG connect string does not have the RECOVERY_CATALOG_OWNER role granted as a DEFAULT role.
Solution of The Problem
Grant the RECOVERY_CATALOG_OWNER role to the user SHAIK in the recovery catalog database. Here from the rman connection string we see the recovery catalog database is the local database. So in the local database issue as a sys user,
SQL> grant RECOVERY_CATALOG_OWNER to SHAIK;
Grant succeeded.
Now create catalog by,
RMAN> create catalog;
recovery catalog created
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment