Ya, kalo anda punya flashback featurenya ON (punya flashback log) bisa lakukan ini. flashback database - open readonly - expot - recover database - import
2008/8/19 Ananias Sembiring <[EMAIL PROTECTED]> > > Maaf sekedar menambahkan., kl salah tolong dikoreksi., > ========================================== > > Saya pernah mengembalikan table yang sudah ditruncate dengan menggunakan > salah satu feature flashback., yaitu FLASHBACK DATABASE., > > feature ini saya lakukan sebagai demo untuk membandingkan incomplete > recovery., > namun sebelum table di truncate., feature flashback database-nya harus ON., > status ini dibuat pada saat database MOUNT., > > SQL> SELECT flashback_on > 2 FROM v$database; > > FLASHBACK_ON > ------------------ > NO > > ubah jadi yes pada kondisi MOUNT., > > SQL> ALTER DATABASE FLASHBACK ON; > Database altered. > > SQL> SELECT flashback_on > FROM v$database; > FLASHBACK_ON > ------------------ > YES > > pada saat flashback database diaktifkan., background process RVWR (Recovery > Writer) akan mencatat "before image" ke dalam flashback log .,sehingga > database bisa dikembalikan ke waktu yang kita inginkan,. sesuai parameter > flashback retention > db_flashback_retention_target., > > Namun ada beberapa kondisi., dimana feature flashback database tidak bisa > di-gunakan untuk mengembalikan data., > > cth : > ==== > -> Tablespace yang sudah di-drop., > -> Datafile yang sudah di-shrink., dll., > > Thank's., > > CMIIW > > Salam., > > An's Sembiring > > > > --- On Tue, 8/19/08, Yoel Susanto <[EMAIL > PROTECTED]<yoel.susanto%40gmail.com>> > wrote: > From: Yoel Susanto <[EMAIL PROTECTED] <yoel.susanto%40gmail.com>> > Subject: Re: Fw: Re: [indo-oracle] Rollback data table > > To: [email protected] <indo-oracle%40yahoogroups.com> > Date: Tuesday, August 19, 2008, 9:52 AM > > Hi all, > > Table yang sudah di truncate datanya tidak akan bisa di recover dengan > > flashback, karena undo datanya tidak ada. > > kalo menggunakan DELETE statement itu masih bisa gunakan flashback.. > > Satu-satunya caranya yah restore dari backup. > > HTH, > > 2008/8/19 m Ilhami <[EMAIL PROTECTED] com> > > > > > > http://luhartma. blogspot. com/2006/ 01/flashback- any-error- > with-oracle- 10g_23.html > > > > > > kalau masalah anda bisa terpecahkan, mohon sharing disini ya. > > > > > > > > > On Fri, Aug 15, 2008 at 10:21 AM, Denny Kusumah <[EMAIL > > PROTECTED]<zuna_doank% > 40yahoo.com> > > > > wrote: > > > > Oracle DB 10g > > > > > > > > --- On Thu, 8/14/08, ronald speirs <ronald.speirs@ > > > gmail.com<ronald.speirs% > 40gmail.com> > > > > wrote: > > > > From: ronald speirs <ronald.speirs@ gmail.com <ronald.speirs% > 40gmail.com> > > > > > > > > Subject: Re: [indo-oracle] Rollback data table > > > > To: indo-oracle@ yahoogroups. com <indo-oracle% 40yahoogroups. com> > > > > Date: Thursday, August 14, 2008, 8:06 PM > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > versi database? > > > > > > > > > > > > > > > > 2008/8/15 Denny Kusumah <zuna_doank@ yahoo. com>: > > > > > > > >> Dear all master oracle, > > > > > > > >> > > > > > > > >> Mo tanya neh, adakah yg tau cara rollback DB > > > > > > > >> jika suatu tabel sudah di truncate. Jadi misalkan > > > > > > > >> saya men-truncate suatu tabel dengan script > > > > > > > >> "truncate table [nama tabel] drop storage;" kemudian > > > > > > > >> saya ingin mengembalikan data tabel tersebut. > > > > > > > >> > > > > > > > >> Mohon pencerahannya. > > > > > > > >> > > > > > > > >> -Denny- > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > > ------------ --------- --------- ------ > > > > > > > > -- > > > > -----------I. N.D.O - O.R.A.C.L.E- --------- ----- > > > > Keluar: indo-oracle- unsubscribe@ yahoogroups. com<indo-oracle- > unsubscribe% 40yahoogroups. com> > > > > Website: http://indooracle. wordpress. com > > > > ------------ --------- --------- --------- -------- > > > > > > > > Bergabung dengan Indonesia Thin Client User Groups, > > > > Terminal Server, Citrix, New Moon Caneveral, di: > > > > http://indo- thin.blogspot. comYahoo! Groups Links > > > > > > > > > > > > > > > > > > > > > > > > -- > > 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]
