Oracle 学习之RMAN（十六）Catalog

658uhr

Catalog是一个独立的数据库， 它用来存储从目标数据库的控制文件中获取的RMAN 元数据。RMAN 将有关数据库结构、归档重做日志、备份集以及数据文件副本的信息从目标数据库的控制文件传播到恢复目录中。当要管理多个目标数据库时，应该使用目录。
  先看创建Catalog的步骤


1. 创建表空间

1 2 3 4 5

SQL> create tablespace rman_ts ; Tablespace created. SQL>

2. 创建Catalog Owner

1 2	SQL> CREATE USER rman IDENTIFIED BY rman DEFAULT TABLESPACE rman_ts QUOTA UNLIMITED ON rman_ts; User created.

3. 赋权限

1 2 3 4 5 6

SQL> GRANT recovery_catalog_owner TO rman; Grant succeeded. SQL> GRANT connect, resource TO rman; Grant succeeded.

4. 创建Catalog

现在target数据库配置一个catdb的连接字符串，指向catlog的数据库。

1 2 3 4 5 6 7 8 9 10 11

11gdg-> rman catalog rman/rman@catdb Recovery Manager: Release 11.2.0.3.0 - Production on Thu Jul 9 11:36:49 2015 Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved. connected to recovery catalog database RMAN> create catalog tablespace rman_ts; recovery catalog created

5.连接target数据库，使用Catalog 。

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23

11gdg-> rman target / catalog rman/rman@catdb Recovery Manager: Release 11.2.0.3.0 - Production on Thu Jul 9 11:52:30 2015 Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved. connected to target database: DEVDB (DBID=789087786, not open) connected to recovery catalog database RMAN> 11gdg-> rman target /                         Recovery Manager: Release 11.2.0.3.0 - Production on Thu Jul 9 11:52:53 2015 Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved. connected to target database: DEVDB (DBID=789087786, not open) RMAN> connect catalog rman/rman@catdb connected to recovery catalog database RMAN>

6. 注册目标数据库

1 2 3 4 5

RMAN> register database; database registered in recovery catalog starting full resync of recovery catalog full resync complete

未完待续......