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 Don Burleson Blog oracle ora 00376
ORA-00376: file cannot be read ora 00376 ora 01110 at this time Oracle Database Tips by Burleson Consulting May 15, 2016 Question: I am getting an ORA-00376 error when trying ora 00376 cannot be read at this time 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 15 cannot be read at this time ORA-01110: data file 15: 'C:\APP\ORADATA\UNDOTBS03.DBF' ora-00376: file cannot be read at this time 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 is not readable. Most likely // the file is offline. Action: Check the state of the file. Bring it online . First,Ora-00376 Ora-01110 Data File
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 tablespace, follow these steps:1: create a new UNDO tablespace2: ALTER SYSTEM SET undo_tablespace = ;3: Bounce the instance Oracle Training from Don Burleson The best on site "Oracle training classes" are just a phone call away! You can get perso
Du siehst YouTube auf Deutsch. Du kannst diese Einstellung unten ändern. Learn more You're viewing YouTube in German. You can change this preference below. Schließen Ja, ich möchte sie behalten Rückgängig machen Schließen Dieses Video ist nicht verfügbar.
Ora-00376 File 6 Cannot Be Read At This Time
WiedergabelisteWarteschlangeWiedergabelisteWarteschlange Alle entfernenBeenden Wird geladen... Wiedergabeliste Warteschlange __count__/__total__ ORACLE ERROR ORA-00376: file 4 ora-00376 file 2 cannot be read at this time undo tablespace cannot be read at this time ORA-01110: data file 4: Aju Thomas John AbonnierenAbonniertAbo beenden66 Wird geladen... Wird geladen... ora-00376 file 8 cannot be read at this time Wird verarbeitet... Hinzufügen Möchtest du dieses Video später noch einmal ansehen? Wenn du bei YouTube angemeldet bist, kannst du dieses Video zu einer Playlist hinzufügen. Anmelden Teilen Mehr Melden Möchtest du http://www.dba-oracle.com/t_ora_00376_file_cannot_be_read_at_this_time.html dieses Video melden? Melde dich an, um unangemessene Inhalte zu melden. Anmelden Statistik 4.688 Aufrufe 5 Dieses Video gefällt dir? Melde dich bei YouTube an, damit dein Feedback gezählt wird. Anmelden 6 0 Dieses Video gefällt dir nicht? Melde dich bei YouTube an, damit dein Feedback gezählt wird. Anmelden 1 Wird geladen... Wird geladen... Wird geladen... Die Bewertungsfunktion ist nach Ausleihen des Videos verfügbar. https://www.youtube.com/watch?v=5RoNxmM7rR0 Diese Funktion ist zurzeit nicht verfügbar. Bitte versuche es später erneut. Hochgeladen am 16.05.2011ORACLE ERROR ORA-00376: file 4 cannot be read at this time ORA-01110: data file 4: 'E:\ORACLE\PRODUCT\10.2.0\O Kategorie Bildung Lizenz Standard-YouTube-Lizenz Mehr anzeigen Weniger anzeigen Wird geladen... Autoplay Wenn Autoplay aktiviert ist, wird die Wiedergabe automatisch mit einem der aktuellen Videovorschläge fortgesetzt. Nächstes Video ORACLE WORLD - Recovery of Dropped Tablespace using TSPITR without RMAN - Dauer: 17:05 Oracle World 4.098 Aufrufe 17:05 Oracle Basics: Understanding the init.ora and spfile - Dauer: 20:54 Chris Ostrowski 15.429 Aufrufe 20:54 Video 01: Presentación Curso Base de Datos Avanzado 2 en Oracle - Cibertec 2015-32 - Dauer: 15:12 Richard Leonardo Berrocal Navarro 613 Aufrufe 15:12 solution for ORA-01113 ORA-01110 DONE BY Toms Oracle DBA.. http://tomstheoracledba.blogspot.in/ - Dauer: 2:25 Aju Thomas John 4.422 Aufrufe 2:25 Oracle DBA Justin - How to create a basic Dataguard physical standby database # 1 of 3 - Dauer: 21:47 jbleistein11 44.160 Aufrufe 21:47 resolving ora 10458 01195 01110 errors - Dauer: 6:45 DBA Pro 240 Aufrufe 6:45 Oracle - Understanding the tnsnames.ora and listener.ora files - Dauer: 12:46 Chris Ostrowski 88.976 Aufrufe 12:46 Or
SYSDBA sqlplus / as sysdba SQL> select * from v$recover_file; FILE# status 43 OFFLINE https://anargodjaev.wordpress.com/2013/11/16/ora-00376-file-43-cannot-be-read-at-this-time/ SQL> recover datafile 43; ORA-00279: change 271477927444 generated at 15/11/2013 10:30:46 needed for thread 1 ORA-00289: suggestion : /export/a01/oradata/ANARTEST/arch/arch_1_170675_526120954.arcORA-00280: change 271477927444 for thread 1 is in sequence #170675 Specify log: {=suggested filename AUTO CANCEL} AUTO ORA-00308: cannot open archived log '/export/a01/oradata/ANARTEST/arch/arch_1_170675_526120954.arc' ORA-27037: unable to obtain file status SVR4 Error: 2: No such cannot be file or directory Additional information: 3 ORA-00308: cannot open archived log '/export/a01/oradata/ANARTEST/arch/arch_1_170675_526120954.arc'ORA-27037: unable to obtain file status SVR4Error: 2: No such file or directory Additional information: 3 RMAN will need to load the necessary archivelog s back to the disk from tape ls /export/a01/oradata/ANARTEST/arch/arch_1_170675_526120954.arc /export/a01/oradata/ANARTEST/arch/arch_1_170675_526120954.arc: No such file or directory Connect to cannot be read rman rman target / restore archivelog from logseq 170674 until logseq 170679 ; RMAN connect target connect anat run { set command id to "an1";5> allocate channel t1 type 'SBT_TAPE'6> restore archivelog from logseq 170674 until logseq 170679 ;7> } connected to target database: ANARTEST (DBID=37.................)connected to recovery catalog databaseexecuting command: SET COMMAND IDallocated channel: t1channel t1: sid=3.. devtype=SBT_TAPEchannel t1: NMO v4.2.0.0Starting restore at 15-OCT-13channel t1: starting archive log restore to default destinationchannel t1: restoring archive logarchive log thread=1 sequence=170674channel t1: reading from backup piece ANARTEST_arch_ANARTEST_113898_7alsl5l9_1_1channel t1: restored backup piece 1piece handle=ANARTEST_arch_ANARTEST_113898_7alsl5l9_1_1 tag=TAG20101110T103208channel t1: restore complete, elapsed time: 00:00:36channel t1: starting archive log restore to default destinationchannel t1: restoring archive logarchive log thread=1 sequence=170675channel t1: reading from backup piece ANARTEST_arch_ANARTEST_113899_7blsl94v_1_1channel t1: restored backup piece 1piece handle=ANARTEST_arch_ANARTEST_113899_7blsl94v_1_1 tag=TAG20101110T113143channel t1: restore complete, elapsed time: 00:00:15channel t1: starting archive log restore to default destinationchannel t1: restoring archive logarchive log thread=1 sequence=170676channel t1: restoring archive logarchive log thread=1 sequence=1