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

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

****************I am authoring a Book on Oracle Database Cloud Services.......More details to follow.***************

Title : Oracle Database Cloud Revealed
Publisher : Apress
Release Date : June-2018

**********************************************************************************


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]


I am certified Oracle Cloud Architect:
Oracle Cloud Infrastructure 2018 Certified Architect Associate
Oracle Cloud Infrastructure Classic 2018 Certified Architect Associate

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: