您好,登录后才能下订单哦!
密码登录
登录注册
点击 登录注册 即表示同意《亿速云用户服务条款》
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/rman
Recovery Manager: Release 11.2.0.4.0 - Production on Fri Mar 16 12:24:41 2018
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to recovery catalog database
RMAN> create catalog;
recovery catalog created
--注册数据库
$ rman target / catalog rman@catalog
Recovery Manager: Release 11.2.0.4.0 - Production on Fri Mar 16 12:27:31 2018
Copyright (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 database
RMAN> register database;
database registered in recovery catalog
starting full resync of recovery catalog
full resync complete
RMAN>
RMAN> report schema;
Report of database schema for database with db_unique_name MNGDB
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 1024 SYSTEM YES +DATA/mngdb/datafile/system.260.970051785
2 1094 SYSAUX NO +DATA/mngdb/datafile/sysaux.261.970051789
3 1355 UNDOTBS1 YES +DATA/mngdb/datafile/undotbs1.262.970051791
4 5 USERS NO +DATA/mngdb/datafile/users.264.970051797
5 18100 MGMT_TABLESPACE NO +DATA/mngdb/datafile/mgmt_tablespace.266.970659277
6 200 MGMT_AD4J_TS NO +DATA/mngdb/datafile/mgmt_ad4j_ts.267.970659279
7 100 MGMT_ECM_DEPOT_TS NO +DATA/mngdb/datafile/mgmt_ecm_depot_ts.268.970659279
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 512 TEMP 32767 +DATA/mngdb/tempfile/temp.263.970051791
RMAN>
免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。