[Oracle] 관리자 5장 실습 8

Close 상태에서 tablespace 이동 (필)

MOUNT 상태에서 data file을 이동하는 과정

step 1. DB SHUTDOWN

step 2. DATA FILE 이동

step 3. DB MOUNT

step 4. ALTER DATABASE 명령으로 DATA FILE 등록

step 5. DB OPEN

사용 명령어

ALTER DATABASE RENAME FILE

<원래 data file명> TO <이동한 data file명>;

- Data file 등록 정보 수정

- ALTER TABLESPACE ~ RENAME DATAFILE 명령과 동일한 효과가 있다.

SELECT tablespace_name, bytes, file_name FROM dba_data_files;

SHUTDOWN IMMEDIATE

!mv /app/ora12c/oradata/DB12/sysaux01.dbf /app/ora12c/oradata/disk3/

!mv /app/ora12c/oradata/DB12/system01.dbf /app/ora12c/oradata/disk3/

!mv /app/ora12c/oradata/DB12/undotbs01.dbf /app/ora12c/oradata/disk3/

!mv /app/ora12c/oradata/DB12/temp01.dbf /app/ora12c/oradata/disk3/

STARTUP MOUNT

SELECT t.name tablespace_name, d.bytes, d.name file_name

FROM v$tablespace t, v$datafile d

WHERE t.ts#=d.ts#

ORDER BY 1;

ALTER DATABASE RENAME file

'/app/ora12c/oradata/DB12/sysaux01.dbf'

TO '/app/ora12c/oradata/disk3/sysaux01.dbf';

ALTER DATABASE RENAME file

'/app/ora12c/oradata/DB12/system01.dbf'

TO '/app/ora12c/oradata/disk3/system01.dbf';

ALTER DATABASE RENAME file

'/app/ora12c/oradata/DB12/undotbs01.dbf'

TO '/app/ora12c/oradata/disk3/undotbs01.dbf';

ALTER DATABASE RENAME file

'/app/ora12c/oradata/DB12/temp01.dbf'

TO '/app/ora12c/oradata/disk3/temp01.dbf';

SELECT t.name tablespace_name, d.bytes, d.name file_name

FROM v$tablespace t, v$datafile d

WHERE t.ts#=d.ts#

ORDER BY 1;

SELECT t.name tablespace_name, d.bytes,d.name file_name

FROM v$tablespace t, v$tempfile d

WHERE t.ts#=d.ts#

ORDER BY 1;

SELECT name FROM v$controlfile;

SELECT member FROM v$logfile;

!rm -rf /app/ora12c/oradata/DB12

!ls /app/ora12c/oradata/

ALTER DATABASE OPEN;