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 - Production1、创建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]$ rmanRecovery Manager: Release 9.2.0.4.0 - ProductionCopyright (c) 1995, 2002, Oracle Corporation. All rights reserved.RMAN> connect catalog rman/rmanconnected to recovery catalog database recovery catalog is not installed
RMAN> create catalog tablespace ts_backup/*创建恢复目录模式对象*/recovery catalog createdRMAN> exit Recovery Manager complete. [oracle@Harrison oracle]$ rman target sys/admin@harrison catalog rman/rman@redhat_dbRecovery Manager: Release 9.2.0.4.0 - ProductionCopyright (c) 1995, 2002, Oracle Corporation. All rights reserved.connected to target database: GLEDESON (DBID=2735459423) connected to recovery catalog databaseRMAN> register database;/*使用恢复目录注册数据库*/database registered in recovery catalog starting full resync of recovery catalog full resync completeRMAN>
|