Ok terimakasih Pak Yulius udah solved. Makasih berat. Regards, Aria On 10/20/05, Yulius Wibowo <[EMAIL PROTECTED]> wrote: > > > RECOVER itu artinya perlu di recover (di betulkan) > > Penyebanya ada 2 kemungkinan > 1. Karena , rusak kemudian di restore dari backup dan belum di > recover > 2. Karena "sedang" dilakukan HOT BACKUP (ALTER TABLESPACE ... BEGIN > BACKUP) dan databasenya MATI atai DIMATIKAN ... > > Coba ikuti langkah2 berikut ... > > 1. Check apakah sedang dalam mode HOT BACKUP > SQL> SELECT * FROM V$BACKUP; > > perhatikan utk FILE# = 5, apakah statusnya ACTIVE ? > kalau ya, jalankan > SQL> ALTER DATABASE DATAFILE 5 END BACKUP; > ATAU > SQL> ALTER DATABASE END BACKUP; (kalau databasenya sudah 9i) > > kemudian > SQL> ALTER DATABASE OPEN; (kalau belum open) > atau > SQL> ALTER DATABASE DATAFILE 5 ONLINE; (kalau sudah open) > > > 2. Kalau nilai STATUS tidak sama dengan ACTIVE > > SQL> RECOVER DATAFILE 5; > > Nanti akan diminta archived log files-nya (kalau mode database-nya > archivelog) > > Lalu > SQL> ALTER DATABASE OPEN; (kalau belum open) > atau > SQL> ALTER DATABASE DATAFILE 5 ONLINE; (kalau sudah open) > > CMIIW > > Bowo > > > --- In [email protected], a_r_i_a <[EMAIL PROTECTED]> wrote: > > > > Dear Para Master Oracle, > > Saya punya masalah datafile seperti dibawah ini; > > ORA-00376: file 5 cannot be read at this time > > ORA-01110: data file > 5: '/data02/oradata/dbsgcpro/dbsgcpro_idx01.dbf' > > Jika saya select seperti SELECT * FROM v$datafile, > > datafile tersebut dalam keadaan RECOVER. > > Saya mencoba membuat online dengan syntax dibawah ini; > > ALTER DATABASE > DATAFILE '/data02/oradata/dbsgcpro/dbsgcpro_idx01.dbf' > > ONLINE; > > Tetapi terjadi error; > > ORA-01113: FILE 5 needs media RECOVERY > > ORA-01110: DATA FILE > 5: '/data02/oradata/dbsgcpro/dbsgcpro_idx01.dbf' > > Tolong pencerahanya gimana cara membuat menjadi ONLINE kembali. > > Regards, > > Aria > > > > > > [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 > Yahoo! Groups Links > > > > > > > > >
[Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/PhFolB/TM --------------------------------------------------------------------~-> -- -----------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 Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
