redo log파일이름 변경

redo log파일이름 변경

작성자: 강명규
OS: Linux 2.2.14
Oracle: Oracle 8.1.5

새로운 DB를 생성하다가 실수로 redo log file의 이름을 맞지 않게 지정했다.
사용에 지장은 없으나 나의 파일이름에 대한 열망은 참을 수 없었다. ^^


[oracle@dev2 dev]$ pwd
/u01/app/oracle/oradata/dev

기존의 로그파일을 새로운 파일이름으로 미리 복사를 해둔다.
[oracle@dev2 dev]$ cp redotest02.log redodev02.log
[oracle@dev2 dev]$ cp redotest01.log redodev01.log
[oracle@dev2 dev]$ cp redotest03.log redodev03.log

나의 경우는 미리 변경될 이름으로 복사복을 만들어야 rename이 가능했다.
그렇지 않을 경우 다음과 같은 에러가 발생했다.

SVRMGR> alter database rename file '/u01/app/oracle/oradata/dev/redotest02.log' to '/u01/app/oracle/oradata/dev/redodev02.log';
alter database rename file '/u01/app/oracle/oradata/dev/redotest02.log' to '/u01/app/oracle/oradata/dev/redodev02.log'
*
ORA-01511: error in renaming log/data files
ORA-01512: error renaming log file /u01/app/oracle/oradata/dev/redotest02.log - new file /u01/app/oracle/oradata/dev/redodev02.log not found
ORA-27037: unable to obtain file status
Linux Error: 2: 그런 파일이나 디렉토리가 없음
Additional information: 3




[oracle@dev2 dbs]$ svrmgrl

Oracle Server Manager Release 3.1.5.0.0 - Production

(c) Copyright 1997, Oracle Corporation.  All Rights Reserved.

Oracle8i Release 8.1.5.0.2 - Production
With the Java option
PL/SQL Release 8.1.5.0.0 - Production

SVRMGR> connect internal
Connected.
SVRMGR> startup mount   
ORACLE instance started.
Total System Global Area                         73997712 bytes
Fixed Size                                          64912 bytes
Variable Size                                     6651904 bytes
Database Buffers                                 67108864 bytes
Redo Buffers                                       172032 bytes
Database mounted.

SVRMGR> alter database rename file '/u01/app/oracle/oradata/dev/redotest02.log' to '/u01/app/oracle/oradata/dev/redodev02.log';
Statement processed.
SVRMGR> alter database rename file '/u01/app/oracle/oradata/dev/redotest01.log' to '/u01/app/oracle/oradata/dev/redodev01.log';
Statement processed.
SVRMGR> alter database rename file '/u01/app/oracle/oradata/dev/redotest03.log' to '/u01/app/oracle/oradata/dev/redodev03.log';
Statement processed.
SVRMGR> select * from v$logfile;
GROUP#     STATUS  MEMBER                                                                          
---------- ------- --------------------------------------------------------------------------------
         1         /u01/app/oracle/oradata/dev/redodev01.log                                       
         2         /u01/app/oracle/oradata/dev/redodev02.log                                       
         3         /u01/app/oracle/oradata/dev/redodev03.log                                       
3 rows selected.
SVRMGR> quit
Server Manager complete.

기존의 로그파일 제거
[oracle@dev2 dev]$ rm redotest0*