오라클 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

경로 변경 확인




Leave Comments

카테고리

최근 글

최근 댓글

최근 엮인글

태그