Create catalog user in the RMAN catalog
[oracle@collabn1 config]$ sqlplus sys@prod1 as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Tue Aug 4 14:17:46 2015
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> select name,open_mode from v$database;
NAME OPEN_MODE
--------- --------------------
PROD1 READ WRITE
SQL> create user rcuser identified by rcuser;
User created.
SQL> create tablespace rcts datafile '+DATA2' size 100m autoextend on next 1m maxsize 1g;
Tablespace created.
SQL> grant recovery_catalog_owner to rcuser;
Grant succeeded.
SQL> alter user rcuser default tablespace rcts;
User altered.
SQL> alter user rcuser quota unlimited on rcts;
User altered.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
Connect to catalog & Target database:
[oracle@collabn1 config]$ rman
Recovery Manager: Release 11.2.0.1.0 - Production on Tue Aug 4 14:22:45 2015
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
RMAN> connect catalog rcuser/rcuser@prod1
connected to recovery catalog database
Create catalog:
RMAN> create catalog;
recovery catalog created
RMAN> connect target system/XXXXXX@orcl
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
ORA-01031: insufficient privileges
RMAN> connect target /
connected to target database: ORCL (DBID=1414564590)
RMAN> register database;
database registered in recovery catalog
starting full resync of recovery catalog
full resync complete
No comments:
Post a Comment