博客
关于我
强烈建议你试试无所不能的chatGPT,快点击我
11g rman 配置catalog
阅读量:6817 次
发布时间:2019-06-26

本文共 2455 字,大约阅读时间需要 8 分钟。

1、官方文档

https://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmcatdb.htm#BRADV89656

2、配置步骤如下

--创建表空间create tablespace catalog datafile size 2G;SQL> create tablespace catalog datafile size 2G;Tablespace created.SQL> --创建用户CREATE USER rman IDENTIFIED BY rman   TEMPORARY TABLESPACE temp   DEFAULT TABLESPACE catalog   QUOTA UNLIMITED ON catalog;SQL> CREATE USER rman IDENTIFIED BY rman   2    TEMPORARY TABLESPACE temp   3    DEFAULT TABLESPACE catalog   4    QUOTA UNLIMITED ON catalog;User created.SQL> --授权GRANT RECOVERY_CATALOG_OWNER TO rman;--创建本地catalog$ rman catalog rman/rmanRecovery Manager: Release 11.2.0.4.0 - Production on Fri Mar 16 12:24:41 2018Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.connected to recovery catalog databaseRMAN> create catalog;recovery catalog created--注册数据库$ rman target / catalog rman@catalogRecovery Manager: Release 11.2.0.4.0 - Production on Fri Mar 16 12:27:31 2018Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.connected to target database: MNGDB (DBID=2724895043)recovery catalog database Password: connected to recovery catalog databaseRMAN> register database;database registered in recovery catalogstarting full resync of recovery catalogfull resync completeRMAN> RMAN> report schema;Report of database schema for database with db_unique_name MNGDBList of Permanent Datafiles===========================File Size(MB) Tablespace           RB segs Datafile Name---- -------- -------------------- ------- ------------------------1    1024     SYSTEM               YES     +DATA/mngdb/datafile/system.260.9700517852    1094     SYSAUX               NO      +DATA/mngdb/datafile/sysaux.261.9700517893    1355     UNDOTBS1             YES     +DATA/mngdb/datafile/undotbs1.262.9700517914    5        USERS                NO      +DATA/mngdb/datafile/users.264.9700517975    18100    MGMT_TABLESPACE      NO      +DATA/mngdb/datafile/mgmt_tablespace.266.9706592776    200      MGMT_AD4J_TS         NO      +DATA/mngdb/datafile/mgmt_ad4j_ts.267.9706592797    100      MGMT_ECM_DEPOT_TS    NO      +DATA/mngdb/datafile/mgmt_ecm_depot_ts.268.970659279List of Temporary Files=======================File Size(MB) Tablespace           Maxsize(MB) Tempfile Name---- -------- -------------------- ----------- --------------------1    512      TEMP                 32767       +DATA/mngdb/tempfile/temp.263.970051791RMAN>

转载于:https://blog.51cto.com/roidba/2088550

你可能感兴趣的文章
ubuntu 修改系统时间
查看>>
Struts2页面到action的三种传值方式
查看>>
【算法导论】插入排序
查看>>
html5定位getLocation()
查看>>
centos7生产环境下openssh升级
查看>>
[原创]Win2003+IE8+VS2005不能进入调试状态
查看>>
[HNOI2004]宠物收养场
查看>>
BZOJ3781:小B的询问(莫队)
查看>>
Ruby实现wordCounter
查看>>
SOAP Services for Python
查看>>
js判断处理undefined类型的数据
查看>>
经验&&bug
查看>>
【leetcode】96. Unique Binary Search Trees
查看>>
【leetcode】552. Student Attendance Record II
查看>>
Hibernate 中upate,savaOrUpdate,merge的区别
查看>>
使用ELK构建分布式日志分析系统
查看>>
PHP遍历指定目录,并存储目录内所有文件属性信息
查看>>
VMware+centos7克隆多个虚拟机
查看>>
iOS第三方分享-ShareSDK
查看>>
[CodeForces954G]Castle Defense(二分答案+差分)
查看>>