Problema ne’e mosu dala barak iha systema base de dadus oracle nian, error ida ne’ebe simples, maibe bele halo ulu fatuk moras, bainhira ita servisu mesak. Tamba nia solusaun iha ne’eba maibe ita nian hanoin mak sidauk to’o, dala ruma mos, ita hanoin dook liu buka nia solusaun.
Tamba ne’emak bainhira problema mosu, copya error No no buka iha Google.com depois ajusta ba ita nia sistema, tamba iha google.com labele fo’o informasaun detail ne’ebe refere mai iha nia nian particular base de dadus.
Bainhira problema ne’e mosu, tama ba iha SQLPLUs no run, imagem iha leten hanesan ezemplu deit, usa logon proses ho apropria, usa system
select name, floor(space_limit / 1024 / 1024) Size_MB, ceil(space_used / 1024 / 1024) Used_MB from v$recovery_file_dest order by name;
nia resultadu:
Hare iha imagem resultadu, karik iha ne’e ba mosu katak USE_MB usa tiha ona 95% husi SIZE_MB, maka dipastikan database problema.
Atu resolve problema ne’e run script tuir mai:
cd\
c:
robocopy D:\backup\full\database\ARCHIVELOG\ D:\temp /S /MOVE /PURGE /MINAGE:62 /xn /log+:D:\backup\full\del_ARCHIVELOG_database.txt
del /S /Q D:\temp\
copy script iha leten ne’e no paste iha notepad, depois save as bat file depois run as Administrator. Ita boot sira sei bele hetan resultadu diak.
Note: script iha leten bele customiza tuir kondisaun server ita nian
Tested by: JF
0 Comments