Wednesday, January 7, 2009

RMAN-06426: RECOVERY_CATALOG_OWNER role must be granted to user

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

No comments:

Post a Comment