一、创建表空间、用户，授权

二、创建

一、创建表空间、用户，授权

SQL> create tablespace rman_ts datafile '/home/oracle/oracle/product/10.2.0/oradata/orcl/rmants.dbf' size

20M;

Tablespace created.

SQL> create user rman identified by rman default tablespace rman_ts quota unlimited on rman_ts;

User created.

SQL> grant connect,resource,recovery_catalog_owner to rman;

Grant succeeded.

二、创建

[oracle@localhost ~]$ rman catalog rman/rman

Recovery Manager: Release 10.2.0.1.0 - Production on Sat Feb 6 23:19:10 2010

Copyright (c) 1982, 2005, Oracle. All rights reserved.

connected to recovery catalog database

RMAN> create catalog tablespace rman_ts;

recovery catalog created

[oracle@localhost ~]$ set oracle_sid=orcl
[oracle@localhost ~]$ rman target / catalog rman/rman

Recovery Manager: Release 10.2.0.1.0 - Production on Sat Feb 6 23:24:55 2010

Copyright (c) 1982, 2005, Oracle. All rights reserved.

connected to target database: ORCL (DBID=1230783748)
connected to recovery catalog database

RMAN> register database;

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

RMAN> report schema;

Report of database schema

List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 480 SYSTEM YES /home/oracle/oracle/product/10.2.0/oradata/orcl/system01.dbf
2 25 UNDOTBS1 YES /home/oracle/oracle/product/10.2.0/oradata/orcl/undotbs01.dbf
3 260 SYSAUX NO /home/oracle/oracle/product/10.2.0/oradata/orcl/sysaux01.dbf
4 56 USERS NO /home/oracle/oracle/product/10.2.0/oradata/orcl/users01.dbf
5 2 UNDO_SMALL YES /home/oracle/oracle/product/10.2.0/oradata/orcl/undo_small.dbf
6 20 RMAN_TS NO /home/oracle/oracle/product/10.2.0/oradata/orcl/rmants.dbf

List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 20 TEMP 32767 /home/oracle/oracle/product/10.2.0/oradata/orcl/temp01.dbf

RMAN>