Coba utk klarifikasinya, sbg user internal jalankan perintah sbb:

SQL> ARCHIVE LOG LIST

Check Log Mode nya: NOARCHIVELOG atau ARCHIVELOG


Alternatif lain, selain dgn recovery coba pakai DBMS_REPAIR.
Tapi ngak dijamin bisa dibetulkan datanya ya!

Bowo


--- In [email protected], "Andes Febrian" <[EMAIL PROTECTED]> 
wrote:
>
> Ohh.. huhuhuhu.. pak widhi pake oracle versi 8i.. maap2 tidak lihat.
> 
> tp apakah bisa jalan backupnya tersebut ? seharusnya ada eror gmn2 
bukan ?
> 
> cepet amat balesannya, thanks yoel. (pernah bilang jgn panggil 
bapak ya,
> hihihi.. lupa saya)
> 
> 2008/5/22 Yoel Susanto <[EMAIL PROTECTED]>:
> 
> >   Andes,
> > di oracle 8 belum ada blockrecover command :)
> >
> > iya..hotbackup tanpa archivelog sama dengan tidak ada backup :)
> >
> > 2008/5/22 Andes Febrian <[EMAIL PROTECTED] <pejantan4u%40gmail.com>>:
> >
> >
> > > dear all, bisa gunakan rman blockrecover command, saya baru 
baca2
> > > hihihi..
> > > :D
> > >
> > > widhi, bukankah yg namanya hot backup harus dalam archivelog 
mode ? bukan
> > > begitu pak yoel ? CMIIW
> > >
> > > 2008/5/22 Yoel Susanto <[EMAIL PROTECTED]<yoel.susanto%
40gmail.com><yoel.susanto%
> > 40gmail.com>
> > > >:
> > >
> > >
> > > > hot backup tanpa archivelog???
> > > > apakah anda pernah coba restore backup Anda?
> > > >
> > > > Hot Backup tanpa archivelog itu tidak mungkin bisa di restore 
pak.
> > > > saya rasa anda tidak bisa lakukan apa2 untuk menyelamatkan 
data anda...
> > > >
> > > >
> > > > 2008/5/22 wkus77 <[EMAIL PROTECTED] <wkus77%40yahoo.com> <wkus77%
> > 40yahoo.com> <wkus77%
> > > 40yahoo.com>>:
> > > >
> > > > > terima kasih atas responsnya...
> > > > > saya pakai hot backup biasa tanpa archivelog
> > > > > database versi 8i
> > > > > apa yang harus saya lakukan yach pak... ???
> > > > >
> > > > > Terima kasih sebelumnya
> > > > > widhi
> > > > >
> > > > >
> > > > > ----- Original Message ----
> > > > > From: Yoel Susanto <[EMAIL PROTECTED]<yoel.susanto%
40gmail.com><yoel.susanto%
> > 40gmail.com><yoel.susanto%
> > > 40gmail.com><yoel.susanto%
> > > > 40gmail.com>>
> > > > > To: [email protected] <indo-oracle%
40yahoogroups.com><indo-oracle%
> > 40yahoogroups.com><indo-oracle%
> > > 40yahoogroups.com><indo-oracle%
> > > > 40yahoogroups.com>
> > > > > Sent: Thursday, May 22, 2008 2:18:45 PM
> > > > > Subject: Re: [indo-oracle] urgent ...ora-01578 .. plezzzz 
help
> > > > >
> > > > > Backup Anda pake apa? archivelog lengkap?
> > > > > database versi brapa?
> > > > >
> > > > > 2008/5/22 wkus77 <[EMAIL PROTECTED] com>:
> > > > >
> > > > > > MIME-Version: 1.0
> > > > > > Content-Type: text/plain; charset=us-ascii
> > > > > >
> > > > > > Dear Rekan-rekan
> > > > > > pagi ini pas user lakukan entry data, keluar message 
error:
> > > > > > "ora01578 : oracle datablock corrupted (file#1 block 
#38926
> > > > > > ora-01110:datafile 'f:\oracle\oradata\ dbname\system01. 
dbf"
> > > > > > apa yang harus saya lakuka yach...
> > > > > > terima kasih sebelumnya
> > > > > > Widhi
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > > --
> > > > > Cheers,
> > > > > Yoel Susanto
> > > > >
> > > > > www.indo-oracletech .com
> > > > >
> > > > > [Non-text portions of this message have been removed]
> > > > >
> > > > > [Non-text portions of this message have been removed]
> > > > >
> > > > >
> > > > >
> > > >
> > > > --
> > > > Cheers,
> > > > Yoel Susanto
> > > >
> > > > www.indo-oracletech.com
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > > >
> > > >
> > >
> > > --
> > > Cheers,
> > > ^_^ Andes ^_^
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > >
> > >
> >
> > --
> > Cheers,
> > Yoel Susanto
> >
> > www.indo-oracletech.com
> >
> > [Non-text portions of this message have been removed]
> >
> >  
> >
> 
> 
> 
> -- 
> Cheers,
> ^_^ Andes ^_^
> 
> 
> [Non-text portions of this message have been removed]
>


Kirim email ke