creating catalog database and registering databases to catalog

Create catalog database and configure the network in between the catalog and database you wish to register in the database



1. Here i have already created the database
    Name:CATALOG

ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1
ORACLE_BASE:/u04/app/oracle/oradata/
FRA: /u04/app/oracle/fast_recovery_area/


SQL> select name from v$database;

NAME
---------
CATALOG



2. Create a tablespace for the RMAN user:

 SQL> create tablespace cattb datafile '/u04/app/oracle/oradata/CATALOG/datafile/cattb01.dbf' size 1G;

Tablespace created.



3. Create an USER with default tablespace CATTB with unlimited quota on that tablespace:

SQL> create user rman identified by oracle temporary tablespace temp default tablespace cattb quota unlimited on cattb;

User created.



4. Grant the RECOVERY_CATALOG_OWNER role to the schema owner. This role provides the user with all privileges required to maintain and query the recovery catalog.

SQL> grant recovery_catalog_owner to rman;

Grant succeeded.



5. Connect to catalog database from target database from RMAN prompt

[oracle@localhost oracle]$ rman target / catalog rman/oracle@to_catalog

Recovery Manager: Release 12.1.0.2.0 - Production on Mon Oct 16 21:15:32 2017

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

connected to target database: ORCL (DBID=1479262473)
connected to recovery catalog database



6. Create catalog database if  not yet created

RMAN> create catalog;

recovery catalog created



7. Register the database to catalog

 RMAN> register database;

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


##Now all  the details of the backups of the registered database are stored in views created under the RMAN user in the catalog database##

Comments

Post a Comment

Popular posts from this blog

Oracle Database Client(12.1.0.2.0) Installation for Microsoft Windows(x64)

Image
Step1) Download Oracle Client 12C from below link http://www.oracle.com/technetwork/database/enterprise-edition/downloads/database12c-win64-download-2297732.html Oracle Database Client (12.1.0.2.0) for Microsoft Windows (x64) winx64_12102_client.zip  (64-bit) (925,039,944 bytes) Oracle Database Client (12.1.0.2.0) for Microsoft Windows (32-bit) winnt_12102_client32.zip  (32-bit) (902,922,170 bytes)  chose the one based on your laptop Step2) Extract the downloaded file Oracle 12c 64 bit client has now been extracted. Double click ‘setup.exe’. This may test your patience, let it work! (Sometimes a minute or less can seem like an eternity). Don’t touch anything! Administrator: Enables applications to connect to an Oracle database on the local system or on a remote system. It provides tools that let you administer
Read more

configuring goldengate

configuring goldengate Pre req:  Install Goldengate software on both the servers golden gate home: /u02/app/goldengate Update bash_profile on both Source and Target side [oracle@localhost ~]$ vi .bash_profile if [ -f ~/.bashrc ]; then         . ~/.bashrc fi # User specific environment and startup programs export ORACLE_SID=test export ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1 export GRID_HOME=/u01/app/oracle/product/12.1.0/grid export LD_LIBRARY_PATH=$ORACLE_HOME/lib export PATH=$ORACLE_HOME/bin:$PATH: export PATH=$GRID_HOME/bin:$PATH: export PATH=$ORACLE_HOME/OPatch:$PATH: PATH=$PATH:$HOME/bin export PATH export GGS_HOME=/u02/app/goldengate alias ggn='cd ${GGS_HOME}' alias ggsci='cd ${GGS_HOME}/ggsci' export LD_LIBRARY_PATH=$GGS_HOME:$ORACLE_HOME/lib:/lib:/usr/lib ".bash_profile" 25L, 684C                                     24,1          75% Source db_name: TEST target db_name: CLONE 1. check for
Read more

sample extract,pump and replicate(goldengate)

NAMING CONVENTION should be followed in any environment we are Implementing GoldenGate# E starts with Extract  P starts with Pump R starts with Replicat  Here we are taking extract: EWORK pump: PWORK replicat:RWORK ###we are replicating schema pavan(including all tables)### goldengate home:'/u02/app/goldengate' source side:  test GGSCI (localhost.localdomain) 2> start mgr Manager started. GGSCI (localhost.localdomain) 1> dblogin userid ogg_user@test password oracle; Successfully logged into database. GGSCI (localhost.localdomain as ogg_user@test) 2> add schematrandata pavan allcols 2017-10-09 14:22:20  INFO    OGG-01788  SCHEMATRANDATA has been added on schema pavan. 2017-10-09 14:22:20  INFO    OGG-01976  SCHEMATRANDATA for scheduling columns has been added on schema pavan. 2017-10-09 14:22:21  INFO    OGG-01977  SCHEMATRANDATA for all columns has been added on schema pavan. Configuring Extract: GGSCI (local
Read more