提示日志文件组存在
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.
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博客 ” ，链接：https://blog.itpub.net/31399171/viewspace-2138625/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
丢失current状态日志文件
请登录后发表评论
登录
全部评论
