오라클 DB 경로 변경. oracle
2014.02.12 17:58 Edit
ORACLE 접속
#sqlplus / as sysdba
SQL>startup mount
Total System Global Area 535662592 bytes
Fixed Size 1334380 bytes
Variable Size 180355988 bytes
Database Buffers 348127232 bytes
Redo Buffers 5844992 bytes
Database mounted.
현재 DB경로 확인
SQL>select name from v$datafile;
NAME
--------------------------------------------------------------------------------
/oracle/product/oradata/REAGLE/SYSTEM01.DBF
/oracle/product/oradata/REAGLE/SYSAUX01.DBF
/oracle/product/oradata/REAGLE/UNDOTBS01.DBF
/oracle/product/oradata/REAGLE/USERS01.DBF
/oracle/product/oradata/REAGLE/EXAMPLE01.DBF
데이터베이스 종료
SQL>shutdown
기존경로에 있는 DB파일들을 변경할 경로로 복사.(정해진 DB명이 있기에 보통 폴더를 통째로 옮긴다)
ex)
#cp -Rp /oracle/product/oradata/REAGLE/ /oradata
ORACLE 재접속 - 변경된 경로로 재 설정
#sqlplus / as sysdba
SQL>startup mount
SQL> alter database rename file '/oracle/product/oradata/REAGLE/system01.dbf' to '/oradata/REAGLE/system01.dbf';
Database altered.
SQL> alter database rename file '/oracle/product/oradata/REAGLE/undotbs01.dbf' to '/oradata/REAGLE/undotbs01.dbf';
Database altered.
SQL> alter database rename file '/oracle/product/oradata/REAGLE/sysaux01.dbf' to '/oradata/REAGLE/sysaux01.dbf';
Database altered.
SQL> alter database rename file '/oracle/product/oradata/REAGLE/users01.dbf' to '/oradata/REAGLE/users01.dbf';
Database altered.
SQL> alter database rename file '/oracle/product/oradata/REAGLE/example01.dbf' to '/oradata/REAGLE/example01.dbf';
Database altered.
SQL> shutdown
재시작
SQL> startup
SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
/oradata/REAGLE/system01.dbf
/oradata/REAGLE/undotbs01.dbf
/oradata/REAGLE/sysaux01.dbf
/oradata/REAGLE/users01.dbf
/oradata/REAGLE/example01.dbf
경로 변경 확인