1、创建rman用户及相应的tablespace SQL> conn sys/admin@redhat_db as sysdba 已连接。 SQL> set wrap off SQL> set linesize 1000 SQL> set timing on SQL> select * from v$version; BANNER ------------------------------------------------------------------------------- Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production PL/SQL Release 9.2.0.4.0 - Production CORE 9.2.0.3.0 Production TNS for Linux: Version 9.2.0.4.0 - Production NLSRTL Version 9.2.0.4.0 - Production 1、创建rman用户及相应的tablespace SQL> conn sys/admin@redhat_db as sysdba 已连接。 SQL> set wrap off SQL> set linesize 1000 SQL> set timing on SQL> select * from v$version; BANNER ------------------------------------------------------------------------------- Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production PL/SQL Release 9.2.0.4.0 - Production CORE 9.2.0.3.0 Production TNS for Linux: Version 9.2.0.4.0 - Production NLSRTL Version 9.2.0.4.0 - Production 已用时间: 00: 00: 00.01 SQL> create tablespace ts_backup 2 datafile '/u01/oracle/oradata/test/ts_backup01.dbf' size 50m; 表空间已创建。 已用时间: 00: 00: 11.07 SQL> create user rman 2 identified by rman 3 default tablespace ts_backup 4 temporary tablespace temp; 用户已创建 已用时间: 00: 00: 00.02 SQL> grant connect,resource,recovery_catalog_owner to rman; 授权成功。 已用时间: 00: 00: 00.02 SQL> 2、telnet到catalog服务器 Red Hat Linux release 9 (Shrike) Kernel 2.4.20-8 on an i686 login: oracle Password: Last login: Thu Jun 23 15:49:04 on :0 -bash: ss#: command not found [oracle@Harrison oracle]$ rman Recovery Manager: Release 9.2.0.4.0 - Production Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved. RMAN> connect catalog rman/rman connected to recovery catalog database recovery catalog is not installed RMAN> create catalog tablespace ts_backup/*创建恢复目录模式对象*/ recovery catalog created RMAN> exit Recovery Manager complete. [oracle@Harrison oracle]$ rman target sys/admin@harrison catalog rman/rman@redhat_db
Recovery Manager: Release 9.2.0.4.0 - Production Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved. connected to target database: GLEDESON (DBID=2735459423) connected to recovery catalog database RMAN> register database;/*使用恢复目录注册数据库*/ database registered in recovery catalog starting full resync of recovery catalog full resync complete RMAN> |