“ORA-03113: end-of-file on communication channel”

(Puujee S) #1

Oracle server deer iim aldaa garaad login khiikhgui bn yakh yostoi be tuslana uu.
Serveriin tog udaa daraa tasraad assan

(Batmunkh Moltov) #2

hii

set lin200
select * from v$flash_recovery_area_usage;

Энэ коммандын үр дүнг харуулдаа

(Puujee S) #3

SQL> select * from v$flash_recovery_area_usage;

FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES


CONTROL FILE 0 0 0
REDO LOG 0 0 0
ARCHIVED LOG 99.97 0 659
BACKUP PIECE 0 0 0
IMAGE COPY 0 0 0
FLASHBACK LOG 0 0 0
FOREIGN ARCHIVED LOG 0 0 0

7 rows selected.

(Puujee S) #4

iim baina archived log ni duurkheer ingedeg uu. golden gate ajillaj baigaa.

(Batmunkh Moltov) #5

Дүүрсэн тул зай гаргах хэрэгтэй

rman target /
delete archivelog until time 'sysdate-3'; 

дээрх rman комманд сүүлийн 3 өдрийн архивлог үлдээж устгана.

(Batmunkh Moltov) made this topic public #6