创建恢复目录的步骤（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博客

创建恢复目录的步骤

最新文章