本文共 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