Oracle SYSAUX表空间的恢复(三)
ta/orcl/dt02.dbf ONLINE
7 /u01/oradata/orcl/dt03.dbf ONLINE
7 rows selected.
SQL> alter tablespace sysaux online;
Tablespace altered.
SQL> select file#,name,STATUS from v$datafile;
FILE# NAME STATUS
---------- -------------------------------------------------- -------
1 /u01/oradata/orcl/system01.dbf SYSTEM
2 /u01/oradata/orcl/undotbs01.dbf ONLINE
3 /u01/oradata/orcl/sysaux01.dbf ONLINE
4 /u01/oradata/orcl/users01.dbf ONLINE
5 /u01/oradata/orcl/dt01.dbf ONLINE
6 /u01/oradata/orcl/dt02.dbf ONLINE
7 /u01/oradata/orcl/dt03.dbf ONLINE
7 rows selected.
SQL> select * from t1;
ID
----------
1
2
3
4
5
8
9
10
8 rows selected.