MAN catalog恢复目录:
当没有恢复目录的时候，RMAN相关的备份信息，比如归档路径、备份集路径等均存在目标数据库的控制文件，但是控制文件并不能无限增长，而且控制文件也不仅仅是用来存储与备份相关的信息，因此RMAN也有一个专门存放备份信息的地方。当待备份的数据库注册到恢复目录之后，RMAN相关的信息除了保存在控制文件中外（只保存一部分），更加详细的信息就被存在恢复目录中。
注意：不要将恢复目录数据库放到目标数据库中。
1.1. 创建恢复目录所有者默认表空间
SYS@ORA11GR2>create tablespace ts_catalog datafile '/u01/app/oracle/oradata/ORA11GR2/ts_catalog.dbf' size 15m;
Tablespace created.
1.2. 创建恢复目录所有者
——创建用户rcowner并授予RECOVERY_CATALOG_OWNER角色
SYS@ORA11GR2>create user rcowner identified by oracle temporary tablespace temp default tablespace ts_catalog quota unlimited on ts_catalog;
User created.
SYS@ORA11GR2>grant recovery_catalog_owner to rcowner;
Grant succeeded.
——回到操作系统创建本库自己的tnsnames.ora
[oracle@wang ~]$ cd /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/
[oracle@wang admin]$ ls
listener.ora samples shrept.lst
[oracle@wang admin]$ vi tnsnames.ora
ora=
(description=
(address=(protocol=tcp)(host=wang)(port=1521))
(connect_data=
(service_name=ORA11GR2)))
"tnsnames.ora" [New] 5L, 118C written
[oracle@wang admin]$
——测试tns：
[oracle@wang admin]$ tnsping ora
TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 28-SEP-2016 23:35:29
Copyright (c) 1997, 2013, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (description= (address=(protocol=tcp)(host=wang)(port=1521)) (connect_data= (service_name=ORA11GR2)))
OK (50 msec)
[oracle@wang admin]$
1.3. 创建恢复目录
[oracle@wang admin]$ rman catalog rcowner/oracle@ora
（登录恢复目录数据库）
Recovery Manager: Release 11.2.0.4.0 - Production on Wed Sep 28 23:38:37 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to recovery catalog database
——创建恢复目录
RMAN> create catalog;
recovery catalog created
注 create catalog的动作是在rcowner用户下创建了恢复目录相关的表，表的默认表空间使用的就是用户的默认表空间，如果，相关表指定其他表空间，那么在执行创建的时候加上指定表空间名称create catalog tablespacets_name;
1.4. 注册目标数据库
1) 在恢复目录中注册目标数据库
[oracle@wang ~]$ rman target / catalog rcowner/oracle@ora
(此步骤我是注册本地的数据库到恢复目录中去)
【当要注册目标数据库到远程恢复目录中去时，1.要配置tns连接网络；2.执行rman target sys/oracle@ora11gr2 catalog rcowner/oracle@orcl，使用 RMAN 连接到目标数据库（要注册的数据库）和恢复目录数据库以及注册到远程恢复目录时，必须要加上账号密码，且要配置好本机及远程的tns及别名】
Recovery Manager: Release 11.2.0.4.0 - Production on Thu Sep 29 06:47:48 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORA11GR2 (DBID=237843809)
connected to recovery catalog database
RMAN> register database;
database registered in recovery catalog
starting full resync of recovery catalog
full resync complete
2) 查看已注册的目标库
[oracle@wang ~]$ sqlplus rcowner/oracle@ora
SQL*Plus: Release 11.2.0.4.0 Production on Thu Sep 29 06:56:22 2016
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
RCOWNER@ora>select * from rc_database;
DB_KEY DBINC_KEY DBID NAME RESETLOGS_CHANGE# RESETLOGS_TIME
---------- ---------- ---------- -------- ----------------- -------------------
1 2 237843809 ORA11GR2 1256742 2016-09-23 15:29:09
3) 从恢复目录中注销目标数据库
[oracle@wang ~]$ rman target / catalog rcowner/oracle@ora
Recovery Manager: Release 11.2.0.4.0 - Production on Thu Sep 29 06:59:32 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORA11GR2 (DBID=237843809)
connected to recovery catalog database
RMAN> unregister database;
database name is "ORA11GR2" and DBID is 237843809
Do you really want to unregister the database (enter YES or NO)? yes
database unregistered from the recovery catalog
?——再次查看已注册的目标数据库
[oracle@wang ~]$ sqlplus rcowner/oracle@ora
SQL*Plus: Release 11.2.0.4.0 Production on Thu Sep 29 07:01:40 2016
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
RCOWNER@ora>select * from rc_database;
no rows selected（没有已注册的数据库信息）
1.5. 手动重新同步恢复目录
1）先要将目标数据库与恢复目录数据库连接起来
[oracle@wang ~]$ rman target / catalog rcowner/oracle@ora
Recovery Manager: Release 11.2.0.4.0 - Production on Thu Sep 29 07:11:19 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORA11GR2 (DBID=237843809)
connected to recovery catalog database
RMAN> register database;（注册数据库）
database registered in recovery catalog
starting full resync of recovery catalog
full resync complete
RMAN>
——查看：
[oracle@wang ~]$ sqlplus rcowner/oracle@ora
SQL*Plus: Release 11.2.0.4.0 Production on Thu Sep 29 07:16:50 2016
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
RCOWNER@ora>select * from rc_database;
DB_KEY DBINC_KEY DBID NAME RESETLOGS_CHANGE# RESETLOGS_TIME
---------- ---------- ---------- -------- ----------------- -------------------
272 273 237843809 ORA11GR2 1256742 2016-09-23 15:29:09
2)手动重新同步恢复目录：
RMAN> resync catalog;
starting full resync of recovery catalog
full resync complete