RMAN CATALOG CREATION IN TARGET DATABASE.

RMAN CATALOG CREATION IN TARGET DATABASE.


1) Configure LISTENER & TNSNAME


2) Create Tablespace and RMAN user


SQL> create tablespace rmantbs datafile '/u01/PRD/datafiles/PRD/rmantbs.dbf' size 100m autoextend on;

Tablespace created.

SQL> create user rmanusr identified by rmanusr default tablespace rmantbs temporary tablespace temp quota unlimited on rmantbs;

User created.

SQL> select distinct username, default_tablespace from dba_users;

USERNAME                       DEFAULT_TABLESPACE
------------------------------ ------------------------------
RMANUSR                        RMANTBS

3) Grant priveleges to RMAN user


SQL> grant connect, resource to rmanusr;
SQL> grant create session to rmanusr;
SQL> grant recovery_catalog_owner to rmanusr;


4) connect to catalog through OS 

$ rman target PRD catalog rmanusr/rmanusr@PRD

Recovery Manager: Release 11.2.0.1.0 - Production on Sun Jun 4 18:58:43 2017

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

target database Password: / as sysdba

connected to target database: PRD (DBID=3168128148)
connected to recovery catalog database

RMAN>

5) Create catalog database.

RMAN> create catalog;

recovery catalog created

6) Register target database

RMAN> register database;

database registered in recovery catalog
starting full resync of recovery catalog
full resync complete


7) Enable block changing tracker

SQL> col status format A8
SQL> COL FILENAME FORMAT A60
SQL>
SQL> SELECT STATUS, FILENAME FROM V$BLOCK_CHANGE_TRACKING;

STATUS   FILENAME
-------- ------------------------------------------------------------
DISABLED

SQL>
SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE '/u01/PRD/datafiles/PRD/BCT.log';

Database altered.

SQL> SELECT STATUS, FILENAME FROM V$BLOCK_CHANGE_TRACKING;

STATUS   FILENAME
-------- ------------------------------------------------------------
ENABLED  /u01/PRD/datafiles/PRD/BCT.log