mount状态下表空间情报试验

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.

Total System Global Area  814227456 bytes
Fixed Size                  2257640 bytes
Variable Size             528485656 bytes
Database Buffers          281018368 bytes
Redo Buffers                2465792 bytes
Database mounted.
SQL>

此时，执行RMAN:

[oracle@localhost ~]$ rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Fri Apr 4 22:35:41 2014

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ORCL (DBID=1370687811, not open)

RMAN> report schema;

Report of database schema for database with db_unique_name ORCL

List of Permanent Datafiles
===========================
File Size(MB) Tablespace           RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1    740      SYSTEM               ***     /u01/app/oracle/oradata/orcl/system01.dbf
2    520      SYSAUX               ***     /u01/app/oracle/oradata/orcl/sysaux01.dbf
3    50       UNDOTBS1             ***     /u01/app/oracle/oradata/orcl/undotbs01.dbf
4    5        USERS                ***     /u01/app/oracle/oradata/orcl/users01.dbf

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

RMAN> 

本文转自健哥的数据花园博客园博客，原文链接：http://www.cnblogs.com/gaojian/p/3646355.html，如需转载请自行联系原作者