Sunday, 28 May 2017

step by step RMAN Catalog creation and registering Database in RMAN Catalog

step by step RMAN Catalog creation and registering Database in RMAN Catalog

Basic Concepts for the Recovery Catalog:-The recovery catalog contains metadata about RMAN operations for each registered target database. When RMAN is connected to a recovery catalog, RMAN obtains its metadata exclusively from the catalog. 

The catalog includes the following types of metadata
1) Information about datafiles and archived redo log backup sets and backup pieces
2) Information about datafiles copies
3) Information about archived redo logs and their copies
4) Information about tablespaces and datafiles
5) Information about Stored scripts, which are named user-created
6) Information about RMAN configuration settings

Creating Catalog for RMAN :-
1) Connect to database :-
sqlplus sys/system as sysdba

2) Create tablespace for RMAN catalog :-
CREATE TABLESPACE RMAN
DATAFILE 'C:\oracle_db\oradata\RMAN01.DBF' SIZE 100M REUSE;

3) Create user for RMAN Schema (Catalog) :-
CREATE USER rman IDENTIFIED BY rman
TEMPORARY TABLESPACE temp
DEFAULT TABLESPACE rman
QUOTA UNLIMITED ON rman;

4) Grant Privs to RMAN catalog user:-
GRANT connect, resource, recovery_catalog_owner TO rman;

5) Connect RMAN from Command prompt :-
rman catalog=rman/rman

6) Create catalog:-
create catalog;

7) Exit from RMAN prompt
exit;

Registering a Database:-The first step in using a recovery catalog for a target database is registering the target database in the recovery catalog. 
  1. Start RMAN and connect to a target database and recovery catalog. The recovery catalog database must be open.
  • rman catalog=rman/rman target /
  1. Register the target database in the connected recovery catalog. RMAN creates rows in the catalog tables to contain information about the target database.
  • RMAN>register database;
  1. Verify that the registration was successful by running REPORT SCHEMA
  • RMAN>report schema;      

---Need to connect more db---
1) rman catalog=rman/rman target sys/sys as sysdba@ab1

register database;

exit;
2) rman catalog=rman/rman target sys/sys as sysdba@ab2

register database;

1 comment:

  1. Thanks for the given information you are providing content very usefull to users.
    Learn How to Work With Ref Cursor in ORACLE 12C For Beginner Actual cost of this course is 9,999/- But now Kuncham Software Solutions Pvt ltd is giving you Free access. Limited period offer Hurry-up Enroll Now at Udemy.


    Hurry-Up Enroll Now and get Free Access to the Entire Course


    ReplyDelete

Cloning database with RMAN

Below are the steps to clone production database(primedb) to UAT database(clonedb)   STEP1 :- Check the both servers are able to connect ...