备份与恢复系列 七 RMAN 创建catalog

在生产环境中我们会接触到NBU，一个强大的工具，可以同时管理多个数据库的备份与恢复。在接触NBU之前我们先来了解一下如何创建一个catalog来保存备份信息。掌握了catalog之后再了解NBU怎样管理备份信息就容易的多。

创建catalog
1 准备catalog数据库
2 创建恢复管理器目录
3 注册PRACTICE数据库
4 为目录再同步控制文件

1 准备catalog数据库
1-添加tnsnames.ora
vi /u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora

practice=
  (description=
   (address=(protocol=tcp)(host=192.168.1.112)(port=1521))
   (connect_data=
     (server=dedicated)
     (service_name=practice)
   ))

rcat=
  (description=
   (address=(protocol=tcp)(host=192.168.1.113)(port=1521))
   (connect_data=
     (server=dedicated)
     (service_name=rcat)
   ))


2-启动监听器
lsnrctl start

3-创建用户表空间和用户
CREATE TABLESPACE CATTBS
DATAFILE '/oradata/RCAT/cattbs01.dbf'
SIZE 20M autoextend on;

CREATE USER rmanadmin IDENTIFIED BY rmanadmin
TEMPORARY TABLESPACE temp
DEFAULT TABLESPACE cattbs
QUOTA UNLIMITED ON cattbs;

recovery_catalog_owner是catalog的所有者
GRANT connect, recovery_catalog_owner TO rmanadmin;

2 创建恢复管理器目录

rman catalog  rmanadmin/rmanadmin@rcat

RMAN> create catalog tablespace cattbs;
RMAN> exit

3 注册PRACTICE数据库
$ rman target sys/oracle@practice catalog  rmanadmin/rmanadmin@rcat

RMAN> register database;

目录已经创建成功，查看已经注册的数据库
RMAN> list incarnation;

查看目前存储在catalog中的practice数据库的注册信息
RMAN> report schema;

4 为catalog同步控制文件

$ rman target sys/oracle@practice catalog  rmanadmin/rmanadmin@rcat
RMAN> set snapshot controlfile name to '/oradata/PRACTICE/snap_PRACTICE.ctl';

executing command: SET CSNAPSHOT
new RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oradata/PRACTICE/snap_PRACTICE.ctl';
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete

RMAN> resync catalog;

starting full resync of recovery catalog
full resync complete

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29047826/viewspace-1252610/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29047826/viewspace-1252610/