ORA-01184: logfile group 1 already exists

提示日志文件组存在
SQL> alter database add logfile group 1 ('/u01/app/oracle/oradata/HU/redo01.log') size 50m;
alter database add logfile group 1 ('/u01/app/oracle/oradata/HU/redo01.log') size 50m
*
ERROR at line 1:
ORA-01184: logfile group 1 already exists




SQL> 


---查看但是没有
[oracle@hu HU]$ ll
total 2020544
-rw-r----- 1 oracle oinstall   9748480 May  7 16:18 control01.ctl
-rw-r----- 1 oracle oinstall   9748480 May  7 16:18 control02.ctl
-rw-r----- 1 oracle oinstall 363077632 May  7 16:04 example01.dbf
-rw-r----- 1 oracle oinstall  52429312 May  7 16:04 redo02.log
-rw-r----- 1 oracle oinstall  52429312 May  7 16:10 redo03.log
-rw-r----- 1 oracle oinstall 587210752 May  7 16:04 sysaux01.dbf
-rw-r----- 1 oracle oinstall 870326272 May  7 16:04 system01.dbf
-rw-r----- 1 oracle oinstall  20979712 May  7 15:58 temp01.dbf
-rw-r----- 1 oracle oinstall 104865792 May  7 16:04 undotbs01.dbf
-rw-r----- 1 oracle oinstall  15736832 May  7 16:04 users01.dbf
[oracle@hu HU]$ 




SQL> alter database drop logfile group 1;


Database altered.


SQL> alter database add logfile group 1 ('/u01/app/oracle/oradata/HU/redo01.log') size 50m;


Database altered.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/31399171/viewspace-2138625/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/31399171/viewspace-2138625/