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>