ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 创建恢复目录的步骤

创建恢复目录的步骤

原创 Linux操作系统 作者:ljm0211 时间:2012-07-02 19:51:33 0 删除 编辑
创建恢复目录的步骤(rman=recovery manager)

D:/>sqlplus/nolog

SQL*Plus: Release 9.2.0.1.0 - Production on Thu Nov 2 09:56:06 2006

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL> conn sys/pwd@rman as sysdba; --rman是目录数据库
Connected.
SQL> drop user rman cascade;

User dropped.

SQL> create tablespace rmants datafile 'd:/oracle/oradata/rman/rmants.ora' size 20M;

--表空间名字不能使用(保留字)'rman'

Tablespace created.

SQL> create user rman identified by rman default tablespace rmants temporary tablespace
temp quota unlimited on rmants;

User created.

SQL> grant connect,resource,recovery_catalog_owner to rman;

Grant succeeded.

SQL> exit
D:/>rman catalog rman/rman@rman

Recovery Manager: Release 9.2.0.1.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

connected to recovery catalog database
recovery catalog is not installed

RMAN> create catalog tablespace rmants;

recovery catalog created

RMAN> connect target sys/pwd@tti --tti是目标数据库,也就是需要使用恢复目录管理的数据库

connected to target database: TTI (DBID=1491024811)

RMAN> register database;

database registered in recovery catalog
starting full resync of recovery catalog
full resync complete

RMAN>

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

下一篇: RMAN命令详解
请登录后发表评论 登录
全部评论

注册时间:2009-05-14

  • 博文量
    272
  • 访问量
    436855