Experience: is what you get soon after you need it.

Experience: is what you get soon after you need it.

Rasul Allah (sal Allahu alaihi wa sallam) said: "Restore the trusts of those who trust you, and deal not falsely with him who deals falsely with you." [Abu Dawud, Tirmidhi]

Search This Blog

Tuesday, August 11, 2015

Create RMAN recovery catalog


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: