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 dat |