当前位置:操作系统 > Unix/Linux >>

rman catalog配置简要笔记

rman catalog配置简要笔记
 
服务端配置:
[sql] 
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  

 

客户端配置:
[sql] 
# tnsname.ora  
rmandb =  
  (DESCRIPTION =  
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.128.1)(PORT = 1521))  
    (CONNECT_DATA =  
      (SERVER = DEDICATED)  
      (SERVICE_NAME = test)  
     )  
   )  

 

客户端登陆:
[sql] 
[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>   

 

 
CopyRight © 2022 站长资源库 编程知识问答 zzzyk.com All Rights Reserved
部分文章来自网络,