当前位置:Gxlcms > mysql > 创建RMANcatalog实现物理备份

创建RMANcatalog实现物理备份

时间:2021-07-01 10:21:17 帮助过:20人阅读

使用catalog database存储rman备份的元数据在生产环境中十分常见,且安全性高。可以将grid control的reponsitory database与cata

1. 场景描述;
catalog database 192.168.1.206:1521 grid
target database 192.168.1.201:1521 ql
2. 在catalog database上创建rman表空间

SQL> create tablespace rman datafile '/u01/app/Oracle/oradata/gird/rman.dbf' size 500m autoextend on next 100m maxsize unlimited;
Tablespace created.

3. 在catalog database上创建rman用户

SQL> create user rman identified by rman default tablespace rman quota 500m on rman;
User created.

4. 在catalog database上对rman用户赋予权限
SQL> grant connect,resource to rman;
Grant succeeded.
SQL> grant recovery_catalog_owner to rman;
Grant succeeded.

5. 在target database上修改tnsname.ora
[oracle@test admin]$ more tnsnames.ora
RMAN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.206)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = gird.57ql.com)
)
)
6. 注册数据库

[oracle@test /]$ rman target / catalogrman/rman@rman;
Recovery Manager: Release 11.2.0.3.0 - Production on Mon Sep 3 16:12:41 2012
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: QL (DBID=2286587371)
connected to recovery catalog database

RMAN> create catalog tablespace "RMAN";
recovery catalog created

RMAN> register database;
database registered in recovery catalog
starting full resync of recovery catalog
full resync complete

7. 备份数据库
RMAN> backup database;
Finished Control File and SPFILE Autobackup at 03-SEP-12
RMAN> exit

8. 小结
使用catalog database存储rman备份的元数据在生产环境中十分常见,,且安全性高。可以将grid control的reponsitory database与catalog database整合在一起。

linux

人气教程排行