/u01/app/oracle/oradata/HOEGH/users01.dbf 4 USERS AVAILABLE ONLINE
/u01/app/oracle/oradata/HOEGH/undotbs01.dbf 3 UNDOTBS1 AVAILABLE ONLINE
/u01/app/oracle/oradata/HOEGH/sysaux01.dbf 2 SYSAUX AVAILABLE ONLINE
/u01/app/oracle/oradata/HOEGH/system01.dbf 1 SYSTEM AVAILABLE SYSTEM
/u01/app/oracle/oradata/HOEGH/TEST101.dbf 5 TEST1 AVAILABLE ONLINE
/u01/app/oracle/oradata/HOEGH/TEST201.dbf 6 TEST2 AVAILABLE ONLINE
/u01/app/oracle/oradata/HOEGH/TEST301.dbf 7 TEST3 AVAILABLE ONLINE
/u01/app/oracle/oradata/HOEGH/test.dbf 8 TEST AVAILABLE ONLINE
8 rows selected.
SYS@HOEGH>
?
5.重启数据库
在进行上述操作后，重启数据库，确保数据库能够正常打开。
SYS@HOEGH>
?
SYS@HOEGH>shut immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS@HOEGH>
SYS@HOEGH>
SYS@HOEGH>startup
ORACLE instance started.
Total System Global Area 941600768 bytes
Fixed Size 1348860 bytes
Variable Size 511707908 bytes
Database Buffers 423624704 bytes
Redo Buffers 4919296 bytes
Database mounted.
Database opened.
SYS@HOEGH>