суббота, 11 декабря 2010 г.

lost logfile ORA-00362, STALE status for logfile

--alert.log
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG'
--
22:20:58 150 4294967295 SYS@orcl> alter database drop logfile 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG';
alter database drop logfile 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG'
*
ERROR at line 1:
ORA-01514: error in log specification: no such log
ORA-01517: log member: 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG'
--
22:26:18 150 4294967295 SYS@orcl> select group#, member, status from v$logfile;

GROUP# | MEMBER


| STATUS
------------------------------------ | ----------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------ | -----------
3.0 | C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG


| STALE
2.0 | C:\PROJECT\OCP\REDO2.LOG


|
1.0 | C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG


| INVALID
1.0 | C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01_1.LOG


| STALE
3.0 | C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01_3.LOG


| STALE
4.0 | C:\PROJECT\OCP\DB_CREATE_ONLINE_DEST\ORCL\ONLINELOG\O1_MF_4_6HLR64SC_.LOG


|

6 rows selected.
--
alter system switch logfile;
--
22:28:39 150 4294967295 SYS@orcl> alter database drop logfile member 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG';

Database altered.
22:33:44 150 4294967295 SYS@orcl> alter database add logfile member 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG' to group 1;

Database altered.

Elapsed: 00:00:03.75

Комментариев нет:

Отправить комментарий

Update BLOB

set define off DECLARE    vb1 CLOB := 'long text';    vb2 CLOB :=                 'long text';    vb3 CLOB :=              ...