ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 创建恢复目录

创建恢复目录

Linux操作系统 作者:lllllcheng 时间:2016-01-12 00:22:54 0 删除 编辑

    Creating recovery catalog is a 3 step process .The recovery catalog is stored in the default tablespace of the recovery catalog schema. SYS cannot be the owner of the recovery catalog.

1. Creating the Recovery Catalog Owner
2. Creating the Recovery Catalog
3. Registering the target database

恢复目录数据库所需空间大小:
Size of recovery catalog schema depends on
a) The number of databases monitored by the catalog.
b) The rate at which archived redo log generates in the target database
c) The number of backups for each target database
d) RMAN stored scripts stored in the catalog

Typical Recovery Catalog Space Requirements for 1 Year:
SYSTEM tablespace:90 MB
Temp tablespace:5 MB
Rollback or undo tablespace:5 MB
Recovery catalog tablespace:15 MB for each database registered in the recovery catalog
Online redo logs:1 MB each (3 groups, each with 2 members)

1、创建恢复目录用户
恢复目录数据库上操作:
[oracle@wjw]$ sqlplus / as sysdba;
SQL> create tablespace catalog datafile '/u01/app/oracle/oradata/orcl/catalog01.dbf' size 2g;
SQL> create user rman identified by rman default tablespace catalog temporary tablespace temp quota unlimited on catalog;
SQL> grant connect,resource,recovery_catalog_owner to rman;

2、创建恢复目录
目标数据库上操作:
[oracle@source ~]$ cd $ORACLE_HOME/network/admin
[oracle@source admin]$ vi tnsnames.ora
内容如下:
catadb =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.2.117)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )
[oracle@source admin]$ rman catalog rman/rman@catadb
恢复管理器: Release 11.2.0.2.0 - Production on 星期一 11月 19 20:07:48 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
连接到恢复目录数据库
RMAN> create catalog;
恢复目录已创建

3、注册目标数据库
目标数据库上操作:
[oracle@source admin]$ rman target / catalog rman/rman@catadb
恢复管理器: Release 11.2.0.2.0 - Production on 星期一 11月 19 20:11:26 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
已连接到目标数据库: LAU (DBID=1840982623)
连接到恢复目录数据库
RMAN> register database;
注册在恢复目录中的数据库
正在启动全部恢复目录的 resync
完成全部 resync

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

请登录后发表评论 登录
全部评论

注册时间:2015-12-02

  • 博文量
    41
  • 访问量
    119982