SQL> shutdown immediate; 關閉數據庫
步驟閱讀
6啟動數據庫到mount狀態
SQL> startup mount;
步驟閱讀
步驟閱讀
7更改數據文件、臨時文件、日志文件位置
alter database rename file '/u01/app/oracle/product/10.2.0/db_1/oradata/orcl/system01.dbf'to '/oradata/orcl/system01.dbf';
alter database rename file'/u01/app/oracle/product/10.2.0/db_1/oradata/orcl/undotbs01.dbf' to'/oradata/orcl/undotbs01.dbf';
alter database rename file'/u01/app/oracle/product/10.2.0/db_1/oradata/orcl/sysaux01.dbf' to'/oradata/orcl/sysaux01.dbf';
alter database rename file'/u01/app/oracle/product/10.2.0/db_1/oradata/orcl/users01.dbf' to'/oradata/orcl/users01.dbf';
alter database rename file'/u01/app/oracle/product/10.2.0/db_1/oradata/orcl/data01.dbf' to'/oradata/orcl/data01.dbf';
alter database rename file'/u01/app/oracle/product/10.2.0/db_1/oradata/orcl/data02.dbf' to'/oradata/orcl/data02.dbf';
alter database rename file'/u01/app/oracle/product/10.2.0/db_1/oradata/orcl/temp01.dbf' to'/oradata/orcl/temp01.dbf';
alter database rename file'/u01/app/oracle/product/10.2.0/db_1/oradata/orcl/redo01.log' to'/oradata/orcl/redo01.log';
alter database rename file'/u01/app/oracle/product/10.2.0/db_1/oradata/orcl/redo02.log' to'/oradata/orcl/redo02.log';
alter database rename file'/u01/app/oracle/product/10.2.0/db_1/oradata/orcl/redo03.log' to'/oradata/orcl/redo03.log';
注意：引號之間不要有空格
步驟閱讀
8打開數據庫
SQL> alterdatabase open;
9重啟驗證
SQL>shutdow immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 167772160bytes
Fixed Size 2082464 bytes
Variable Size 125831520 bytes
Database Buffers 33554432 bytes
Redo Buffers 6303744 bytes
Database mounted.
Database opened.
SQL>
步驟閱讀
