Creating a Recovery Catalog

                                      Creating a Recovery Catalog

·         Create a small database using DBCA

·         export ORACLE_SID=RMAN

[oracle@mydb ~]$ sqlplus '/as sysdba'

SQL*Plus: Release 11.2.0.1.0 Production on Tue Aug 27 11:28:27 2013

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

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select name from v$database;

NAME

---------

RMAN

·         SQL> create user rman identified by rman default tablespace users temporary tablespace temp;

User created.

·         SQL> grant resource,connect to rman;

Grant succeeded.

·         SQL> GRANT RECOVERY_CATALOG_OWNER TO rman;

Grant succeeded.

·         SQL> alter user rman quota unlimited on users;

User altered.

·         connect to recovery catalog database

[oracle@mydb ~]$ rman catalog rman@RMAN

Recovery Manager: Release 11.2.0.1.0 - Production on Tue Aug 27 11:36:59 2013

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

recovery catalog database Password:

connected to recovery catalog database

·         create catalog;

RMAN> create catalog;

recovery catalog created

·         Connect to both rman database and target database

export ORACLE_SID=ORCL

[oracle@mydb ~]$ rman catalog rman@RMAN target /

Recovery Manager: Release 11.2.0.1.0 - Production on Tue Aug 27 11:39:27 2013

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

connected to target database: ORCL (DBID=1348721365)

recovery catalog database Password:

connected to recovery catalog database

·         register database;

RMAN> register database;

database registered in recovery catalog

starting full resync of recovery catalog

full resync complete

RMAN> report schema;

Report of database schema for database with db_unique_name ORCL

List of Permanent Datafiles

===========================

File Size(MB) Tablespace           RB segs Datafile Name

---- -------- -------------------- ------- ------------------------

1    740      SYSTEM               YES     /u01/app/oracle/oradata/ORCL/system01.dbf

2    580      SYSAUX               NO      /u01/app/oracle/oradata/ORCL/sysaux01.dbf

3    100      UNDOTBS1             YES     /u01/app/oracle/oradata/ORCL/undotbs01.dbf

4    6        USERS                NO      /u01/app/oracle/oradata/ORCL/users01.dbf

5    100      EXAMPLE              NO      /u01/app/oracle/oradata/ORCL/example01.dbf

List of Temporary Files

=======================

File Size(MB) Tablespace           Maxsize(MB) Tempfile Name

---- -------- -------------------- ----------- --------------------

1    37       TEMP                 32767       /u01/app/oracle/oradata/ORCL/temp01.dbf