ITPub博客

首页 > 数据库 > Oracle > 配置RMAN恢复目录

配置RMAN恢复目录

原创 Oracle 作者:luckstarcn 时间:2006-01-23 11:58:09 0 删除 编辑

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>

[@more@]

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/80489/viewspace-813663/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
  • 博文量
    3
  • 访问量
    8658