SYS@rhel6> select group#,status from v$log;
GROUP# STATUS
---------- ----------------
1 INACTIVE
2 CURRENT
3 INACTIVE
SYS@rhel6> !ls /u01/app/oracle/oradata/rhel6/redo*
/u01/app/oracle/oradata/rhel6/redo01.log
/u01/app/oracle/oradata/rhel6/redo02.log
/u01/app/oracle/oradata/rhel6/redo03.log
SYS@rhel6> alter database drop logfile group 2;
alter database drop logfile group 2
*
ERROR at line 1:
ORA-01624: log 2 needed for crash recovery of instance rhel6 (thread 1)
ORA-00312: online log 2 thread 1: '/u01/app/oracle/oradata/rhel6/redo02.log'
SYS@rhel6> shu immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS@rhel6> startup mount
ORACLE instance started.
Total System Global Area 830930944 bytes
Fixed Size 2232920 bytes
Variable Size 633343400 bytes
Database Buffers 188743680 bytes
Redo Buffers 6610944 bytes
Database mounted.
SYS@rhel6> alter database open resetlogs;
Database altered.
SYS@rhel6> select group#,status from v$log;
GROUP# STATUS
---------- ----------------
1 CURRENT
2 UNUSED
3 UNUSED
GROUP# STATUS
---------- ----------------
1 INACTIVE
2 CURRENT
3 INACTIVE
/u01/app/oracle/oradata/rhel6/redo01.log
/u01/app/oracle/oradata/rhel6/redo02.log
/u01/app/oracle/oradata/rhel6/redo03.log
SYS@rhel6> alter database drop logfile group 2;
alter database drop logfile group 2
*
ERROR at line 1:
ORA-01624: log 2 needed for crash recovery of instance rhel6 (thread 1)
ORA-00312: online log 2 thread 1: '/u01/app/oracle/oradata/rhel6/redo02.log'
SYS@rhel6> shu immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS@rhel6> startup mount
ORACLE instance started.
Total System Global Area 830930944 bytes
Fixed Size 2232920 bytes
Variable Size 633343400 bytes
Database Buffers 188743680 bytes
Redo Buffers 6610944 bytes
Database mounted.
SYS@rhel6> alter database open resetlogs;
Database altered.
GROUP# STATUS
---------- ----------------
1 CURRENT
2 UNUSED
3 UNUSED
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/30166973/viewspace-1626437/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/30166973/viewspace-1626437/