1 2 Previous Next 17 Replies Latest reply: Jan 7, 2013 8:02 AM by 620899 Go to original post RSS
      • 15. Re: ORA-00376: file 2 cannot be read at this time
        983152
        --

        Edited by: 980149 on Jan 7, 2013 4:59 AM
        • 16. Re: ORA-00376: file 2 cannot be read at this time
          983152
          Hi, I gave the output at beginning. I told already that PSAPUNDO needs recovery.
          SQL> select segment_name,tablespace_name,status from dba_rollback_segs;

          SEGMENT_NAME TABLESPACE_NAME STATUS
          ------------------------------ ------------------------------ ----------------
          SYSTEM SYSTEM ONLINE
          _SYSSMU17$                     PSAPUNDO                       OFFLINE
          _SYSSMU16$                     PSAPUNDO                       OFFLINE
          _SYSSMU15$                     PSAPUNDO                       OFFLINE
          _SYSSMU14$                     PSAPUNDO                       OFFLINE
          _SYSSMU13$                     PSAPUNDO                       OFFLINE
          _SYSSMU12$                     PSAPUNDO                       OFFLINE
          _SYSSMU11$                     PSAPUNDO                       OFFLINE
          _SYSSMU10$                     PSAPUNDO                       NEEDS RECOVERY
          _SYSSMU9$                      PSAPUNDO                       NEEDS RECOVERY
          _SYSSMU8$                      PSAPUNDO                       NEEDS RECOVERY

          SEGMENT_NAME TABLESPACE_NAME STATUS
          ------------------------------ ------------------------------ ----------------
          _SYSSMU7$                      PSAPUNDO                       NEEDS RECOVERY
          _SYSSMU6$                      PSAPUNDO                       NEEDS RECOVERY
          _SYSSMU5$                      PSAPUNDO                       NEEDS RECOVERY
          _SYSSMU4$                      PSAPUNDO                       NEEDS RECOVERY
          _SYSSMU3$                      PSAPUNDO                       NEEDS RECOVERY
          _SYSSMU2$                      PSAPUNDO                       NEEDS RECOVERY
          _SYSSMU1$                      PSAPUNDO                       NEEDS RECOVERY

          18 rows selected.

          Also I find some important thing in alert log.

          I got some important information from the alert log.
          ----------------------
          Incremental checkpoint up to RBA [0x2aad.15fb6.0], current log tail at RBA [0x2aad.15ff4.0]
          Sun Dec 02 19:01:16 2012
          Beginning log switch checkpoint up to RBA [0x2aae.2.10], SCN: 179359877
          Thread 1 advanced to log sequence 10926
          Current log# 2 seq# 10926 mem# 0: D:\ORACLE\SOL\ORIGLOGB\LOG_G12M1.DBF
          Current log# 2 seq# 10926 mem# 1: C:\ORACLE\SOL\MIRRLOGB\LOG_G12M2.DBF
          Sun Dec 02 19:06:21 2012
          Completed checkpoint up to RBA [0x2aae.2.10], SCN: 179359877
          Sun Dec 02 19:25:04 2012
          Incremental checkpoint up to RBA [0x2aae.2d36.0], current log tail at RBA [0x2aae.2e11.0]
          Sun Dec 02 19:30:00 2012
          KCF: write/open error block=0x19 online=1
          file=2 D:\ORACLE\SOL\SAPDATA1\UNDO_1\UNDO.DATA1
          error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write to file
          **O/S-Error: (OS 33) The process cannot access the file because another process has locked a portion of the file.'*Automatic datafile offline due to write error on*
          file 2: D:\ORACLE\SOL\SAPDATA1\UNDO_1\UNDO.DATA1Sun Dec 02 19:30:01 2012
          Errors in file d:\oracle\sol\saptrace\usertrace\sol_ora_5408.trc:
          ORA-00376: file 2 cannot be read at this time
          ORA-01110: data file 2: 'D:\ORACLE\SOL\SAPDATA1\UNDO_1\UNDO.DATA1'
          ORA-00376: file 2 cannot be read at this time
          ------------------------------------------------
          Any suggestions?

          Edited by: 980149 on Jan 7, 2013 4:58 AM

          Edited by: 980149 on Jan 7, 2013 4:58 AM
          • 17. Re: ORA-00376: file 2 cannot be read at this time
            620899
            so you need to recover the file and make it online.

            connect sys as sysdba and run

            sql>recover datafile 2;
            sql>alter database datafile 2 online;

            thanks
            1 2 Previous Next