云存储技术博客：光头老蒋

ram是oracle数据库备份里使用最多的热备方式，本文从结构上让操作者了解rman的备份机理，如何将目标数据库注册到rman数据库上

Target 数据库

  |

  |

  |

  |

  |

  |

 ▼

Rman 数据库

有关拓扑图的说明:

 下面的命令$ rman target internal/oracle@ora815 catalog rman/rman@orarman ;

表示在Target 数据库上运行RMAN命令,先连接数据库本身,然后将Target 数据库本身同RMAN数据库关联起来.然后再注册.注意次序不要搞混,是主动注册到RMAN数据库.而不是RMAN数据库来联系.

一 RMAN数据库上:

------------------------------------------------------------]

1.创建RMAN用户的表空间

SVRMGR> create tablespace rmantable

     2> datafile '/u01/oradata/ora815/rmantable.dbf' size 150m;

经验之谈：在oracle8.1.5中不能用catalog,rcvcat这种敏感字眼作为catalog所在的表空间名。

-----------------------------------------------------------

------------------------------------------------------------

2.创建RMAN 用户.

SVRMGR> create user rman identified by rman

     2> DEFAULT TABLESPACE rmantable

     3> TEMPORARY TABLESPACE temp

     4> QUOTA UNLIMITED ON rmantable;

Statement processed.

-------------------------------------------------------------

-------------------------------------------------------------

3.给RMAN用户授权.

SVRMGR> grant recovery_catalog_owner to rman;

语句已处理。

SVRMGR>grant connect,resource to rman;

Statement processed.

--------------------------------------------------------------

---------------------------------------------------------------

4.如果是8i:,则通过create catalog来实现。

$ rman catalog rman/rman;

Recovery Manager: Release 8.1.5.0.0 - Production

RMAN-06008: connected to recovery catalog database

RMAN-06428: recovery catalog is not installed

RMAN>connect  catalog rman/rman@orarman

说明: rman/rman@orarman orarman表示rman所在的本身数据库的名称.

RMAN|>create catalog tablespace rmantable;

RMAN-06431: recovery catalog created

--------------------------------------------------------------

5.如果是8.0.5:则

connect rman/rman;(注意必须以rman身份登录)

@../rdbms/admin/catrman.sql:

最后的执行结果是：

No errors for PACKAGE DBMS_RCVCAT

Statement processed.

No errors for PACKAGE BODY DBMS_RCVCAT

Statement processed.

No errors for PACKAGE DBMS_RCVMAN

Statement processed.

No errors for PACKAGE BODY DBMS_RCVMAN

----------------------------------------------

------------------------------------------------

二.在Target 数据库上将本身DB注册到RMAN 数据库上.

 rman  target internal/oracle@ora815 catalog rman/rman@orarman;

Recovery Manager: Release 8.1.5.0.0 - Production

RMAN-06005: connected to target database: ORA815 (DBID=1560757381)

RMAN-06008: connected to recovery catalog database

RMAN>

RMAN> register database;

RMAN-03022: compiling command: register

RMAN-03023: executing command: register

RMAN-08006: database registered in recovery catalog

RMAN-03023: executing command: full resync

RMAN-08029: snapshot controlfile name set to default value: ?/dbs/snapcf_@.f

RMAN-08002: starting full resync of recovery catalog

RMAN-08004: full resync complete