ORACLE使用RMAN对SYSTEM表空间进行介质恢复(三)
e opened
RMAN> exit
Recovery Manager complete.
########################################################################
6.登陆数据库，查看数据是否正常
[oracle@bys001 bys1]$ sqlplus / as sysdba
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SYS@bys1>select open_mode from v$database;
OPEN_MODE
--------------------
READ WRITE
SYS@bys1>conn bys/bys
Connected.
可以看到，备份的SYSTEM表空间之后的创建表空间、建表插入数据的操作产生的数据都正常。
BYS@bys1>select count(*) from test5;
COUNT(*)
----------
4
BYS@bys1>
col file_name for a40
BYS@bys1>select file_name,tablespace_name,bytes/1024/1024 m from dba_data_files union select file_name,tablespace_name,bytes/1024/1024 m from dba_temp_files;
FILE_NAME TABLESPACE_NAME M
---------------------------------------- ------------------------------ ----------
/u01/oradata/bys1/example01.dbf EXAMPLE 100
/u01/oradata/bys1/rmantest.dbf RMANTEST 10
/u01/oradata/bys1/sysaux01.dbf SYSAUX 620
/u01/oradata/bys1/system01.dbf SYSTEM 690
/u01/oradata/bys1/temp01.dbf TEMP 771
/u01/oradata/bys1/undotbs01.dbf UNDOTBS1 125
/u01/oradata/bys1/users01.dbf USERS 1703.75