Hlášení Aplikace:

ORA-20000: Oracle Text error: ORA-00604: error occurred at recursive SQL level 1
ORA-00376: file 3 cannot be read at this time ORA-01110: data file 3: ‚+DATA0/espis/datafile/sysaux.285.621056765‘ ORA-06512: at „CTXSYS.DRUE“, line 160 ORA-06512: at „CTXSYS.DRVDML“, line 427 ORA-06512: at „SPS.DR$OSS_FT_POZTC“, line 1 ORA-04088: error during execution of trigger ‚SPS.DR$OSS_FT_POZTC‘

Chyby v alert.logu

Sat Dec 21 08:41:00 2013
Errors in file d:\oracle\admin\espis\bdump\espis1_lms1_680.trc:
ORA-01135: file 3 accessed for DML/query is offline
ORA-01110: data file 3: ‚+DATA0/espis/datafile/sysaux.285.621056765‘

Sat Dec 21 08:41:00 2013
LMS1: terminating instance due to error 1135
Sat Dec 21 08:41:00 2013
Errors in file d:\oracle\admin\espis\bdump\espis1_lmon_3664.trc:
ORA-01135: file accessed for DML/query is offline

Sat Dec 21 08:44:36 2013
Errors in file d:\oracle\admin\espis\bdump\espis1_j000_5880.trc:
ORA-12012: error on auto execute of job 131052
ORA-00376: file ORA-00376: file 3 cannot be read at this time
ORA-01110: data file 3: ‚+DATA0/espis/datafile/sysaux.285.621056765‘
ORA-06512: at „SYS.DBMS_SPACE“, line 1528
cannot be read at this time

Kontrola souboru v ASM

ASMCMD> ls -ltr
Type Redund Striped Time Sys Name
DATAFILE UNPROT COARSE DEC 21 09:00:00 Y SYSAUX.285.621056765
DATAFILE UNPROT COARSE DEC 21 11:00:00 Y CWMLITE.291.621056857
DATAFILE UNPROT COARSE DEC 21 11:00:00 Y DMSARCHIV.527.779015519

Kontrola statusu daného souboru

SQL> select status, file# from v$datafile;
STATUS FILE#
------- ----------
SYSTEM 1
ONLINE 2
RECOVER 3
ONLINE 4
ONLINE 5
ONLINE 6

Recover daného souboru z RMANa

RMAN> recover datafile 3;
ZaΦßtek recover v 21.12.13
mφsto katalogu obnovy se pou₧φvß °φdicφ soubor cφlovΘ databßze
p°id∞len² kanßl: ORA_DISK_1
kanßl ORA_DISK_1: sid=24 instance=espis2 devtype=DISK
zaΦφnß obnova mΘdia
vlßkno archivnφho protokolu 1 sekvence 179068 je ji₧ ulo₧eno na disku jako soubo
r +DATA0/espis/archivelog/2013_12_21/thread_1_seq_179068.365.834755593
kanßl ORA_DISK_1: zaΦßtek obnovy archivnφch protokol∙ do v²chozφho mφsta
kanßl ORA_DISK_1: obnova archivnφho protokolu
archivnφ protokol vlßkno=2 sekvence=89713
kanßl ORA_DISK_1: probφhß Φtenφ z Φßsti zßlohy F:\ZALOHA\ESPIS\RMAN\KJOS2B49_1_1
kanßl ORA_DISK_1: probφhß obnova Φßsti zßlohy 1
deskriptor Φßsti=F:\ZALOHA\ESPIS\RMAN\KJOS2B49_1_1 znaΦka=TAG20131221T091032
kanßl ORA_DISK_1: obnova dokonΦena, uplynul² Φas: 00:00:02
kanßl ORA_DISK_1: zaΦßtek obnovy archivnφch protokol∙ do v²chozφho mφsta
kanßl ORA_DISK_1: obnova archivnφho protokolu
archivnφ protokol vlßkno=2 sekvence=89714
kanßl ORA_DISK_1: probφhß Φtenφ z Φßsti zßlohy F:\ZALOHA\ESPIS\RMAN\KLOS2B4B_1_1
...
obnova mΘdia dokonΦena, uplynul² Φas: 00:00:06
UkonΦenφ recover v 21.12.13
RMAN>

Kontrola statusu po obnově

SQL> select file#, status, name from v$datafile where file#=3;
FILE# STATUS
---------- -------
NAME
-----------------------------------------------------------------------------
3 OFFLINE
+DATA0/espis/datafile/sysaux.285.621056765

Přepnutí do online režimu

SQL> alter tablespace sysaux online;
Tablespace altered.
SQL> select file#, status, name from v$datafile where file#=3;
FILE# STATUS
---------- -------
NAME
---------------------------------------------------------------------------
3 OFFLINE
+DATA0/espis/datafile/sysaux.285.621056765

 



Komentáře