rman catalog配置简要笔记

最新推荐文章于 2025-08-09 18:20:04 发布

weixin_33962621

最新推荐文章于 2025-08-09 18:20:04 发布

阅读量53

点赞数

文章标签：数据库网络

本文详细介绍了Oracle数据库的服务端配置，包括创建表空间、用户、分配配额及授权，以及客户端配置如tnsname.ora文件的设置。通过示例RMAN命令展示了如何连接目标数据库和恢复目录数据库，提供了从服务端到客户端的完整配置流程。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

服务端配置：

SQL> create tablespace tbs_rman datafile 'H:\oradata\test\tbs_rman.dbf' size 20m autoextend on;
 
Tablespace created
 
SQL> create user rman identified by oracle default tablespace tbs_rman temporary tablespace temp;
 
User created
 
SQL> alter user rman quota unlimited on tbs_rman;
 
User altered
 
SQL> grant recovery_catalog_owner to rman;
 
Grant succeeded

客户端配置：

# tnsname.ora
rmandb =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.128.1)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = test)
     )
   )

客户端登陆：

[oracle@rhel5 admin]$ rman target / catalog rman/oracle@rmandb

Recovery Manager: Release 10.2.0.1.0 - Production on Tue Aug 6 14:42:32 2013

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

connected to target database: ORCL (DBID=1349938074)
connected to recovery catalog database

RMAN>