Re: Question: RMAN Configuration

BD wrote:
> Hi all.
>
> I am attempting to use RMAN under 9.2.0.4 to back up dbs under both
> 9.2.0.4 and 8.1.7.4. At this point, the two dbs are on the same
> physical server (AIX 5.2), but the intent is to do this across the
> network with one central catalog. Working across versions like this may
> be my error. However - assuming this is do-able, I'd like to outline
> the process I took with configuring RMAN, in hopes that someone can
> spot my error/omission.
>
> Here's what I did:
>
> IN CATALOG DB (9.2.0.4):
> -Created tablespace, user, catalog as documented.
> -Granted CONNECT, RESOURCE, RECOVERY_CATALOG_OWNER to RMAN user
> -Created the catalog as documented
> -Registered the current local database, with
> "rman target / catalog rman/<pwd>@CATDB"
>
> IN TARGET DB (8.1.7.4):
> -Recreated password file with orapwd
> -Set REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE in init file, restarted
> -Created user rman
> -Granted RESOURCE, CREATE_SESSION, SYSDBA to rman
> -Confirmed status of password file with:
>
> select * from v$pwfile_users;
> USERNAME SYSDB SYSOP
> ------------------------------ ----- -----
> INTERNAL TRUE TRUE
> SYS TRUE TRUE
> RMAN TRUE FALSE
>
> IN CATALOG DB:
> -Attempted to connect, with:
> Catalog: rman target rman/<pwd>@TARGET catalog rman/<pwd>@CATDB
>
> RESULT:
> ORA-01031: insufficient privileges
>
> I've been scouring the group for threads on this topic, and am finding
> no further insights.
>
> Can anyone see my error? Is it as simple rman not being 'backward
> compatible' between 9i and 8i?
>
> Many thanks!!
>
> BD

Hi,

Have you tried connecting to target DB as user sys?

rman target sys/<pwd>@TARGET catalog rman/<pwd>@CATDB

HTH
Jorge Received on Fri Jul 08 2005 - 20:20:08 CDT