建立rman catalog

最新推荐文章于 2025-09-11 20:53:34 发布

转载最新推荐文章于 2025-09-11 20:53:34 发布 · 86 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/evancao350/p/4193054.html

文章标签：

#数据库

本文详细介绍了在Oracle数据库环境中创建表空间、用户、设置权限，并通过RMAN工具进行catalog数据库的创建、注册、同步、删除数据等关键操作。此外，还展示了如何利用RMAN创建虚拟目录，实现权限控制和资源管理。通过实操步骤和关键代码片段，为数据库管理员提供了全面的指南。

1.创建表空间

SQL> create tablespace rc_data datafile '/orcl_backup/rc_dbf/rc_data01.dbf' size 50M;

2.创建一个用户，

SQL> create user rc_admin identified by rc_admin default tablespace rc_data;

User created.

3.设置权限

SQL> grant connect,resource,recovery_catalog_owner to rc_admin;

Grant succeeded.

4.连接到catalog，创建catalog

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

Recovery Manager: Release 11.2.0.3.0 - Production on Mon Dec 29 17:20:11 2014

connected to recovery catalog database

RMAN> create catalog;

recovery catalog created

6.连接到目标库，进行注册

RMAN> connect target sys/a123456

connected to target database: ORCL (DBID=1389657672)

RMAN> register database;

database registered in recovery catalog
starting full resync of recovery catalog
full resync complete

手工同步

RMAN> resync catalog;

starting full resync of recovery catalog
full resync complete

删除数据

UNREGISTER DATABASE;

更新Recovery Catalog

RMAN> UPGRADE CATALOG;

recovery catalog upgraded to version 11.02.00.03
DBMS_RCVMAN package upgraded to version 11.02.00.03
DBMS_RCVCAT package upgraded to version 11.02.00.03

查list incarnation

RMAN> list incarnation
2> ;

List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1 16 ORCL 1389657672 PARENT 1 17-SEP-11
1 368 UNKNOWN 1389657672 ORPHAN 947455 16-OCT-14
1 2 ORCL 1389657672 CURRENT 995548 25-OCT-14

CATALOG的新特性：虚拟专用恢复目录（在10g及之前版本没办法控制catalog的权限）

1.新建表空间
SQL> create tablespace virtual_tp datafile '/orcl_backup/rc_dbf/virtual01.dbf' size 50m;

Tablespace created.

2.用基于恢复目录给v_user1用户授权

SQL> create user v_user1 identified by v_user1 default tablespace virtual_tp;

User created.

SQL> grant recovery_catalog_owner to v_user1;

Grant succeeded.

3.创建虚拟目录

[oracle@evancao ~]$ rman catalog rc_admin/rc_admin;

Recovery Manager: Release 11.2.0.3.0 - Production on Mon Dec 29 18:35:03 2014

connected to recovery catalog database