lebih lanjut tentang object yang terdapat block corrupted,
semoga berguna :
------------------------
Error: ORA-1578
Text: ORACLE data block corrupted (file # %s, block # %s)
----------------------------------------
Diagnosis:
a) Check for any ORA-600 errors in the ALERT and TRACE files.
b) lakukan query dengan login user sys
sql> SELECT segment_name , segment_type , owner , tablespace_name
FROM sys.dba_extents
WHERE file_id = &bad_file_id
AND &bad_block_id BETWEEN block_id and block_id + blocks -1;
(&bad_file_id is the ABSOLUTE file number in Oracle8)
salaam,
ardian
On 5/10/06, wagisol <[EMAIL PROTECTED]> wrote:
>
> database tetap bisa jalan dan data tetap bisa masuk itu sudah terjadi 4
> bulan yang lalu, berhubunga saya orang baru jadi bingung kalau
> direcovery apakah data yang masuk selama 4 bulan itu akan hilang?apakah
> bisa recovery cuma system atau struktur-nya saja?
>
> backup ada pada 1 bulan sebelum terjadinya kerusakan
>
>
>
>
>
>
> --
> -----------I.N.D.O - O.R.A.C.L.E---------------
> Keluar: [EMAIL PROTECTED]
> Website: http://indo-oracle.lizt.org (NEW)
> -----------------------------------------------
>
> Bergabung dengan Indonesia Thin Client User Groups,
> Terminal Server, Citrix, New Moon Caneveral, di:
> http://indo-thin.vze.com
>
>
>
> SPONSORED LINKS
> Membership database software<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Membership+database+software&w2=Database+mortgage+software&w3=Pda+database+software&w4=Database+management+software&w5=Oracle+database+administration&w6=Oracle+database+management&c=6&s=195&.sig=eDDh4hKVCztlkTEeYzirSg> Database
> mortgage software<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Membership+database+software&w2=Database+mortgage+software&w3=Pda+database+software&w4=Database+management+software&w5=Oracle+database+administration&w6=Oracle+database+management&c=6&s=195&.sig=hXxg74XuhXSzegVx-t1xkA> Pda
> database software<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Membership+database+software&w2=Database+mortgage+software&w3=Pda+database+software&w4=Database+management+software&w5=Oracle+database+administration&w6=Oracle+database+management&c=6&s=195&.sig=roR_Z1cY1-GOzqzt3GgyUw> Database
> management software<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Membership+database+software&w2=Database+mortgage+software&w3=Pda+database+software&w4=Database+management+software&w5=Oracle+database+administration&w6=Oracle+database+management&c=6&s=195&.sig=qVd58SCSnEG4iKPrZDnKTA> Oracle
> database administration<http://groups.yahoo.com/gads?t=ms&k=Oracle+database+administration&w1=Membership+database+software&w2=Database+mortgage+software&w3=Pda+database+software&w4=Database+management+software&w5=Oracle+database+administration&w6=Oracle+database+management&c=6&s=195&.sig=HnkpKGBwHtP2yh9OvVaS3Q> Oracle
> database management<http://groups.yahoo.com/gads?t=ms&k=Oracle+database+management&w1=Membership+database+software&w2=Database+mortgage+software&w3=Pda+database+software&w4=Database+management+software&w5=Oracle+database+administration&w6=Oracle+database+management&c=6&s=195&.sig=8YpXzkCJ2hlCDM-NY94dXQ>
> ------------------------------
> YAHOO! GROUPS LINKS
>
>
> - Visit your group "indo-oracle<http://groups.yahoo.com/group/indo-oracle>"
> on the web.
>
> - To unsubscribe from this group, send an email to:
> [EMAIL PROTECTED]<[EMAIL PROTECTED]>
>
> - Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/>.
>
>
> ------------------------------
>
[Non-text portions of this message have been removed]
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.lizt.org (NEW)
-----------------------------------------------
Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.vze.com
SPONSORED LINKS
| Membership database software | Database mortgage software | Pda database software |
| Database management software | Oracle database administration | Oracle database management |
YAHOO! GROUPS LINKS
- Visit your group "indo-oracle" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
