[ controll file rename ]

1. database shutdown

SVRMGR> shutdown

2. controll file copy

# copy /old-path/oldfile-name /new-path/newfile-name (os상의 작업)

3. init<SID>.ora file 수정

# vi init<SID>.ora --- controll의 위치를 지정한 파라메타에 새로운 path로 입력

4. database startup

SVRMGR> startup

5. 확인

SVRMGR> select *from v$controllfile;



[ Tablespace(datafile) rename ]

1. database startup

SVRMGR> startup

2. datafile offline

SVRMGR> alter tablespace <tablespace_name> offline;

3. datafile copy

# copy /old-path/oldfile-name /new-path/newfile-name (os상의 작업)

4. datafile rename

SVRMGR> alter database <tablespace_name> rename file '/old-path/oldfile-name'

to '/new-path/newfile-name';

5. database open and tablespace online

SVRMGR> alter database open;

SVRMGR> alter tablespace <tablespace_name> online;

6. 확인

SVRMGR> select name, status from v$datafile;

7. unix command에 의한 old datafile 삭제



[ system datafile 및 logfile ]

1. database shutdown ( immeidate나 abort로 하면 안됨)

SVRMGR> shutdown

2. unix command에 의한 새위치에 copy

# copy /old-path/oldfile-name /new-path/newfile-name (os상의 작업)

3. mount database

SVRMGR> startup mount

4. rename

SVRMGR> alter database rename file '/old-full-path/old-filename'

to '/new-full-path/new-filename';

5. open database

SVRMGR> alter database open;

6. 확인

SVRMGR> select name, status from v$datafile;

SVRMGR> select * from v$log;

SVRMGR> select * from v$logfile;

7. unix command에 의한 old logfile 삭제