Thursday, July 7, 2011

ORACLE RMAN: HOW TO CONNECT, CONFIGURE AND WORK

Follow the steps to connect, configure and work with RMAN:
--------------------------------------------------------------
set ORACLE_HOME
set ORACLE_SID

When no catelog used (i.e no catalog but control file):

At command prompt:
--------------------
rman target sys@ORCL


Recovery Catalog configuration:
connect as Sys as sysdba
1. Create a tablespace

CREATE SMALLFILE TABLESPACE rman_tbs DATAFILE ‘D:\ORACLE\..\rman_tbs.dbf’ SIZE 100M EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

2. CREATE USER rman IDENTIFIED BY rman DEFAULT TABLESPACE rman_tbs

Grant connect, resource , recovery_catalog_owner to rman;

3. Create a Recovery Catalog
at cmd command prompt
----------------------
rman catalog=rman/rman@ORCL

CREATE CATALOG;

EXIT;

4. Register Database:
- Each database must be registered only once

rman catalog=rman/rman@orcl target=sys@orcl

register database;


How to connect catalog schema:
rman catalog=rman/rman@orcl target=sys@orcl

target points to the database you are about run RMAN commands on/against.

5. Connect rman client first then connect desired database at rman command prompt

at command prompt:
-------------------
rman catalog=rman/rman@orcl

Recovery Manager: Release 10.2.0.3.0 - Production on Fri Jul 8 05:50:21 2011

Copyright (c) 1982, 2005, Oracle. All rights reserved.

connected to recovery catalog database

RMAN> connect target sys@orcl

target database Password:
connected to target database: ORCL (DBID=1876906721)

RMAN> report schema;
.... output would be listed....

In Summary:

1. When no catelog used (i.e no catalog but control file):
At command prompt:
--------------------
rman target sys@ORCL

2. When Recovery catalog used:
rman catalog=rman/rman@orcl target=sys@orcl

Hope it helps.. -- Have a fun in working in Oracle Technologies-- Cheers--

ORACLE RMAN: HOW TO CONNECT, CONFIGURE AND WORK

Follow the steps to connect, configure and work with RMAN:
--------------------------------------------------------------
set ORACLE_HOME
set ORACLE_SID

When no catelog used (i.e no catalog but control file):

At command prompt:
--------------------
rman target sys@ORCL


Recovery Catalog configuration:
connect as Sys as sysdba
1. Create a tablespace

CREATE SMALLFILE TABLESPACE rman_tbs DATAFILE ‘D:\ORACLE\..\rman_tbs.dbf’ SIZE 100M EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

2. CREATE USER rman IDENTIFIED BY rman DEFAULT TABLESPACE rman_tbs

Grant connect, resource , recovery_catalog_owner to rman;

3. Create a Recovery Catalog
at cmd command prompt
----------------------
rman catalog=rman/rman@ORCL

CREATE CATALOG;

EXIT;

4. Register Database:
- Each database must be registered only once

rman catalog=rman/rman@orcl target=sys@orcl

register database;


How to connect catalog schema:
rman catalog=rman/rman@orcl target=sys@orcl

target points to the database you are about run RMAN commands on/against.

5. Connect rman client first then connect desired database at rman command prompt

at command prompt:
-------------------
rman catalog=rman/rman@orcl

Recovery Manager: Release 10.2.0.3.0 - Production on Fri Jul 8 05:50:21 2011

Copyright (c) 1982, 2005, Oracle. All rights reserved.

connected to recovery catalog database

RMAN> connect target sys@orcl

target database Password:
connected to target database: ORCL (DBID=1876906721)

RMAN> report schema;
.... output would be listed....

In Summary:

1. When no catelog used (i.e no catalog but control file):
At command prompt:
--------------------
rman target sys@ORCL

2. When Recovery catalog used:
rman catalog=rman/rman@orcl target=sys@orcl

Hope it helps.. -- Have a fun in working in Oracle Technologies-- Cheers--