在RMAN中使用恢复目录
创建恢复目录及使用恢复目录进行备份
有以下步骤:
--1.先进行单独表空间的创建
CREATE TABLESPACE reccat
DATAFILE '/oratest/oracle/oradata/oratest/reccat01.dbf' SIZE 500M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128k
SEGMENT SPACE MANAGEMENT AUTO;
--2.专有用户的创建
CREATE USER rcat IDENTIFIED BY foo
TEMPORARY TABLESPACE temp
DEFAULT TABLESPACE reccat
QUOTA UNLIMITED ON reccat;
--3.赋予创建用户权限
GRANT RECOVERY_CATALOG_OWNER TO rcatuser;
GRANT CREATE SESSION TO rcatuser;
--4.用创建的用户连接rman ,并创建恢复目录对象
bash-3.00$ rman catalog rcat/foo
Recovery Manager: Release 10.2.0.4.0 - Production on Wed Dec 16 19:03:17 2015
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to recovery catalog database
--5.运行创建目录命令
RMAN> create catalog;
recovery catalog created
RMAN>
--6.检验下成果
$ sqlplus rcat/foo
SQL*Plus: Release 10.2.0.4.0 - Production on Wed Dec 16 19:04:50 2015
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
rcat@oratest> select table_name from user_tables;
TABLE_NAME
------------------------------
DB
NODE
CONF
DBINC
CKP
TS
TSATT
DF
DFATT
ROUT
RCVER
TF
TFATT
OFFR
RR
RT
ORL
RLH
AL
BS
BP
BCF
CCF
XCF
BSF
BDF
CDF
XDF
BRL
BCB
CCB
SCR
SCRL
CONFIG
XAL
RSR
FB
GRSP
38 rows selected.
rcat@oratest>
--7.在目标数据库上远端的恢复目录数据库注册
C:\app\oracle\product\12.1.0\dbhome_1\BIN>rman target / catalog rcat/foo@192.168.1.250/oratest
恢复管理器: Release 12.1.0.2.0 - Production on 星期三 12月 16 19:07:58 2015
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
已连接到目标数据库: CYANG (DBID=3752195400)
连接到恢复目录数据库
PL/SQL 程序包RCAT.DBMS_RCVCAT版本10.02.00.04 (RCVCAT数据库中) 太低
RMAN> register database;
--8.进行备份操作
$rman target / catalog rcat/foo@192.168.1.250/oratest
RMAN>backup database;
清理远端的恢复目录
--方法1:删除恢复目录
bash-3.00$ rman catalog rcat/foo
Recovery Manager: Release 10.2.0.4.0 - Production on Wed Dec 16 19:23:33 2015
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to recovery catalog database
RMAN> drop catalog;
recovery catalog owner is RCAT
enter DROP CATALOG command again to confirm catalog removal
RMAN> drop catalog;
recovery catalog dropped
RMAN> exit
Recovery Manager complete.
bash-3.00$
--方法2:直接删除用户关联的对象并删除用户,这样更彻底
$ sqlplus "/ as sysdba"
sys@oratest> drop user rcat cascade;
User dropped.
sys@oratest>