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>
mount状态下表空间情报试验,布布扣,bubuko.com
原文:http://www.cnblogs.com/gaojian/p/3646355.html