服务器 频道

配置RMAN恢复目录

  【IT168 服务器学院】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>
  

0
相关文章