设为首页 加入收藏

TOP

OCM_Session3_1_CreateanRMANCatalog(一)
2014-11-24 03:15:48 来源: 作者: 【 】 浏览:7
Tags:OCM_Session3_1_CreateanRMANCatalog

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
首页 上一页 1 2 下一页 尾页 1/2/2
】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
分享到: 
上一篇OCM_Session7_11_安装oracle软件 下一篇Solaris11配置静态IP

评论

帐  号: 密码: (新用户注册)
验 证 码:
表  情:
内  容:

·C++中智能指针的性能 (2025-12-25 03:49:29)
·如何用智能指针实现c (2025-12-25 03:49:27)
·如何在 C 语言中管理 (2025-12-25 03:20:14)
·C语言和内存管理有什 (2025-12-25 03:20:11)
·为什么C语言从不被淘 (2025-12-25 03:20:08)