OCM_Session3_1_Create an RMAN Catalog

• 
  1. Create an RMAN Catalog
•  1.1 Create a tablespace in your EMREP database called RC_DATA.
•   1.1.1 Make it locally managed.
•   1.1.2 Create it with one datafile of size 100MB.

参考联机文档：

Backup and Recovery Advanced User's Guide==>10 Managing the Recovery Catalog

http://docs.oracle.com/cd/B19306_01/backup.102/b14191/rcmcatdb.htm#i1011365

创建一个表空间名RC_DATA在EMREP数据库里，本地管理，文件大小100M

[oracle@ocm2 ~]$ export ORACLE_SID=EMREP

[oracle@ocm2 ~]$ sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Mar 21 11:35:42 2014

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

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, Oracle Label Security, OLAP and Data Mining options

SQL>  create tablespace rc_data datafile '/u01/app/oracle/oradata/EMREP/rc_data01.dbf' size 100m 

  2  extent management local;

Tablespace created.

• 1.2 Create a user named RC_ADMIN with password RC_ADMIN in your EMREP
•   1.2.1 The user must have a default tablespace of RC_DATA.
•   1.2.2 Give the user the ability to manage a Recovery Catalog.

创建一个用户名RC_ADMIN，密码RC_ADMIN在EMREP数据库里，默认表空间是RC_DATA,并且给这个用户管理恢复目录的权限

SQL>   create user RC_ADMIN identified by RC_ADMIN default tablespace RC_DATA;

User created.

SQL>  grant connect,recovery_catalog_owner to RC_ADMIN;

Grant succeeded.

• 1.3 Create a Recovery Catalog
•   1.3.1 Create the catalog in the EMREP database owned by RC_ADMIN
•   1.3.2 Register the PROD database with the catalog

在EMREP数据库里创建一个目录，所有者为rc_admin，并将PROD数据库注册到这个目录里。在创建目录时，注意表空间的使用权限为quota unlimited。

[oracle@ocm2 ~]$  rman catalog rc_admin/rc_admin

Recovery Manager: Release 10.2.0.1.0 - Production on Fri Mar 21 12:08:14 2014

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

connected to recovery catalog database

RMAN> create catalog;

ORACLE error from recovery catalog database: ORA-01950: no privileges on tablespace 'RC_DATA'

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-06433: error installing recovery catalog

RMAN> exit

Recovery Manager complete.

[oracle@ocm2 ~]$ sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Mar 21 12:20:38 2014

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

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, Oracle Label Security, OLAP and Data Mining options

SQL>   alter user rc_admin quota unlimited on RC_DATA;

User altered.

SQL> exit

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, Oracle Label Security, OLAP and Data Mining options

[oracle@ ocm2  ~]$ rman catalog rc_admin/rc_admin

Recovery Manager: Release 10.2.0.1.0 - Production on Fri Mar 21 12:21:25 2014

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

connected to recovery catalog database

RMAN>   create catalog;

recovery catalog created

RMAN> 

连接目标数据库和恢复目录数据库：

[oracle@ ocm2  admin]$  rman target sys/oracle@prod catalog rc_admin/rc_admin@emrep

Recovery Manager: Release 10.2.0.1.0 - Production on Fri Mar 21 12:44:20 2014

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

connected to target database: PROD (DBID=254361867)

connected to recovery catalog database

RMAN>   register database;

database registered in recovery catalog

starting full resync of recovery catalog

full resync complete

RMAN> 

RMAN> report schema;

starting full resync of recovery catalog

full resync complete

Report of database schema

List of Permanent Datafiles

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

File Size(MB) Tablespace           RB segs Datafile Name

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

1    325      SYSTEM               YES     /u01/app/oracle/oradata/PROD/Disk1/system01.dbf

2    116      UNDOTBS1             YES     /u01/app/oracle/oradata/PROD/Disk1/undotbs01.dbf

3    325      SYSAUX               NO      /u01/app/oracle/oradata/PROD/Disk1/sysaux01.dbf

4    400      EXAMPLE              NO      /u01/app/oracle/oradata/PROD/Disk1/example01.dbf

5    40       INDX                 NO      /u01/app/oracle/oradata/PROD/Disk1/indx01.dbf

6    10       TOOLS                NO      /u01/app/oracle/oradata/PROD/Disk1/tools01.dbf

7    48       USERS                NO      /u01/app/oracle/oradata/PROD/Disk1/users01.dbf

8    48       OLTP                 NO      /u01/app/oracle/oradata/PROD/Disk1/oltp01.dbf

List of Temporary Files

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

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

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

1    20       TEMPTS1              20          /u01/app/oracle/oradata/PROD/Disk1/temp01.dbf

2    20       TEMP1                20          /u01/app/oracle/oradata/PROD/Disk1/temp11.dbf

3    20       TEMP2                20          /u01/app/oracle/oradata/PROD/Disk1/temp12.dbf

RMAN>