>  Operating System
>  VMWARE
>  Installations - Apps11i
>  R12 Topics
>  Installations - Apps R12
>  Patching
>  Cloning
>  Oracle Apps Upgrades
>  System Administration - R11/R12
>  Advance Features - Oracle Apps R12
>  Want to Become an Apps DBA ?
>  Certification - Apps DBA
>  Apps Performance
>  Oracle Apps DBA Interview Questions
>  Apps Day to Day Queries

Home

Username

Password

Remember Me







Installation
RMAN - Backup & Recovery
Replication
Convert DB Character Set
DATAPUMP
Recoveries
Oracle 11g Topics
Oracle 11g DBA course

   Installation

1 - RMAN Setup and Configuration

RMAN Setup and Configuration
----------------------------


Configure the Database for RMAN Operations
------------------------------------------

Set Up the Database User in the target database
-----------------------------------------------

create user backup_admin identified by backup_admin default tablespace users;
grant sysdba to backup_admin;


Creating the Recovery Catalog
-----------------------------

Creating the Recovery Catalog User
----------------------------------

create user rcat_user identified by rcat_user default tablespace users;

grant connect,resource,recovery_catalog_owner to rcat_user;


Creating the Recovery Catalog Schema Objects
--------------------------------------------

Step 1. Connect to the recover catalog with RMAN:

rman catalog=rcat_user/rcat_user@reco

Step 2. Issue the create catalog command from the RMAN prompt:

create catalog;

Register your database in the recovery catalog
----------------------------------------------

Step 1: Using RMAN, sign into the database and the recover catalog at the same time

ORACLE_SID=HMDEV; export ORACLE_SID
rman catalog=rcat_user/rcat_user@RECO target=backup_admin/backup_admin

or
ORACLE_SID=RECO; export ORACLE_SID
rman catalog=rcat_user/rcat_user target=backup_admin/backup_admin@HMDEV

Recovery Manager: Release 9.2.0.1.0 - 64bit Production

Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

connected to target database: RECO (DBID=1308910273)
connected to recovery catalog database

Step 2: Register the database with the recovery catalog

RMAN> register database

Errors Faced
-------------------
Delete the recovery catalog database, after somedays created a new database, but
was not able to take backup,

I was getting ora-1580 error

Solution - unregister database
select * from rc_database;
execute dbms_rcvcat.unregisterdatabase (db_key, db_id)

Refer Note:1058332.6

Created on 05/29/2008 08:17 PM by akr14feb
Updated on 05/29/2008 08:25 PM by akr14feb
 Printable Version