网创优客建站品牌官网
为成都网站建设公司企业提供高品质网站建设
热线:028-86922220
成都专业网站建设公司

定制建站费用3500元

符合中小企业对网站设计、功能常规化式的企业展示型网站建设

成都品牌网站建设

品牌网站建设费用6000元

本套餐主要针对企业品牌型网站、中高端设计、前端互动体验...

成都商城网站建设

商城网站建设费用8000元

商城网站建设因基本功能的需求不同费用上面也有很大的差别...

成都微信网站建设

手机微信网站建站3000元

手机微信网站开发、微信官网、微信商城网站...

建站知识

当前位置:首页 > 建站知识

11grman配置catalog

1、官方文档

成都创新互联公司是一家以网站建设、网页设计、品牌设计、软件运维、成都网站推广、小程序App开发等移动开发为一体互联网公司。已累计为公路钻孔机等众行业中小客户提供优质的互联网建站和软件开发服务。

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> 

分享标题:11grman配置catalog
URL分享:http://bjjierui.cn/article/iepspj.html

其他资讯