Oracle Error Ora 00376
Contents |
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle PostersOracle Books Oracle Scripts Ion Excel-DB ora-00376 ora-01110 Don Burleson Blog
ora-00376 ora-01110 data file ORA-00376: file cannot be read at this time Oracle Database Tips by Burleson Consulting May ora-00376 file 2 cannot be read at this time undo tablespace 15, 2016 Question: I am getting an ORA-00376 error when trying to drop my UNDO tablespace: ALTER DATABASE DATAFILE 'C:\APP\ORADATA\UNDOTBS03.DBF' OFFLINE DROP; ORA-00604: error occurred at recursive SQL level 1 ora-00376 file 6 cannot be read at this time ORA-00376: file 15 cannot be read at this time ORA-01110: data file 15: 'C:\APP\ORADATA\UNDOTBS03.DBF' How do I fix the ORA-00376 error? Answer: First, why would you try to drop your UNDO tablespace? The oerr utility shows this for the ORA-00376 error: ORA-00376: File %s cannot be read at this time Cause: attempting to read from a file that isHow To Bring Datafile Online In Oracle
not readable. Most likely // the file is offline. Action: Check the state of the file. Bring it online . First, see the MOSC note: "ORA-00376 and ORA-01110 Database File Unavailable" [ID 160705.1] and "Resolving ORA-00376 Error Encountered in database" [MOSC ID 1339985.1] Next, check your alert log for additional messages. You need to start by getting the file#. select * from DBA_DATA_FILES where TABLESPACE_NAME='XXX'; You will want to check the status of the data file: select status, file# from v$datafile where file# = nn; select status, file# from v$datafile_header where file# = nn; Next, check to see if the file wants recovery: select * from v$recover_file; Check rollback segments (UNDO); select segment_name, tablespace_name, status from dba_rollback_segs; Check to see if your UNDO tablespace is offline. Start by trying to bring it online: alter database datafile 'c:\u01\app\xxx' online; Fir non-UNDO issues you need to recover the datafile and then bring the tablespace online. recover datafile 'c:\u01\app\oracle\xxx'; alter tablespace 'XXX' online; In your case, you need your UNDO tablespace for crash recovery. If you want to allocate a new UNDO
ORA-00376: file 4 cannot be read at this time ORA-01110: data file 4: Aju Thomas John SubscribeSubscribedUnsubscribe66 Loading... Loading... Working... Add to Want to watch this again later? Sign in to
Ora-00376: File 5 Cannot Be Read At This Time
add this video to a playlist. Sign in Share More Report Need ora-00376 file 8 cannot be read at this time to report the video? Sign in to report inappropriate content. Sign in Statistics 4,708 views 5 Like this ora-00376 file 35 cannot be read at this time video? Sign in to make your opinion count. Sign in 6 0 Don't like this video? Sign in to make your opinion count. Sign in 1 Loading... Loading... Loading... Rating http://www.dba-oracle.com/t_ora_00376_file_cannot_be_read_at_this_time.html is available when the video has been rented. This feature is not available right now. Please try again later. Uploaded on May 16, 2011ORACLE ERROR ORA-00376: file 4 cannot be read at this time ORA-01110: data file 4: 'E:\ORACLE\PRODUCT\10.2.0\O Category Education License Standard YouTube License Show more Show less Loading... Autoplay When autoplay is enabled, a suggested video will automatically https://www.youtube.com/watch?v=5RoNxmM7rR0 play next. Up next Oracle DBA, Recover a datafile from a cold backup1e9 - Duration: 8:54. hammadshams 1,790 views 8:54 solution for ORA-01113 ORA-01110 DONE BY Toms Oracle DBA.. http://tomstheoracledba.blogspot.in/ - Duration: 2:25. Aju Thomas John 4,422 views 2:25 Oracle Basics: Understanding the init.ora and spfile - Duration: 20:54. Chris Ostrowski 15,429 views 20:54 ORACLE WORLD - Recovery of Dropped Tablespace using TSPITR without RMAN - Duration: 17:05. Oracle World 4,098 views 17:05 resolving ora 10458 01195 01110 errors - Duration: 6:45. DBA Pro 240 views 6:45 Oracle DBA Justin - How to create a basic Dataguard physical standby database # 1 of 3 - Duration: 21:47. jbleistein11 44,504 views 21:47 Video 01: PresentaciĆ³n Curso Base de Datos Avanzado 2 en Oracle - Cibertec 2015-32 - Duration: 15:12. Richard Leonardo Berrocal Navarro 613 views 15:12 how to solve ORA-12560: TNS:protocol adapter error - Duration: 2:27. Deepak Soni 111,585 views 2:27 Oracle DBA, Recover from the loss of a datafile using archived redologs, 1e13 - Duration: 6:22. hammadshams 2,474 views 6:22 Oracle Tutorial - How to recover a corrupted N
Library mySQL Code Library PHP Code Library JavaScript Code Library Oracle Terms & Definitions Oracle Error Codes PSOUG Community Blogs Oracle Jobs Board PSOUG Forum Oracle User Group Directory cannot be Free Oracle Magazines Online Learning Center PSOUG Presentations Advanced Code Search News and Events Sponsors Page Submit Code Contact Us Oracle Error: ORA-00376 Error Description: File string cannot be cannot be read read at this time Error Cause: Attempting to read from a file that is not readable. Most likely the file is offline. Action: Check the state of the file. Bring it online. There haven't been any comments added for this error yet. You may add one if you like. Add a comment Name: Email: URL: Chars left:1000 (1000 max) (No HTML, but newlines will be preserved) Home : Code Library : Sponsors : Privacy : Terms of Use : Contact Us 73 users online © 2009 psoug.org PSOUG LOGIN Username: Password: Forgot your password?