Salam, saya punya log listener, dengan log sbb : 23-MAY-2007 07:58:17 * (CONNECT_DATA=(SID=worlclas)(CID=(PROGRAM=C:\Program Files\Quest Software\TOAD\TOAD.exe)(HOST=agskompi)(USER=agus))) * (ADDRESS=(PROTOCOL=tcp)(HOST=xxx.xxx.xxx.xxx)(PORT=1675)) * establish * worlclas * 0
yg jadi pertanyaan, itu error dari log atau hanya log listener saja. terima kasih, ags ----- Original Message ---- From: Yulius Wibowo <[EMAIL PROTECTED]> To: [email protected] Sent: Wednesday, May 23, 2007 7:44:13 AM Subject: [indo-oracle] Re: incomplete recovery untuk satu datafile saja Mas Andhika, Menurut saya memang soalnya tdk lengkap/salah/ njebak. Mungkin karena yg buat soal bukan DBA kali ya ,.. hehehe. Di Database Oracle dimungkinkan melakukan incomplete recovery di level tablespace (level datafile, kalau 1 TS hanya memiliki 1 DF). Biasa disebut TSPITR (Tablespace Point in Time Recovery). Tapi step2nya nggak semudah yg ada disoal :-) Yg jelas, setelah melakukan incomplete recovery, yg harus dilakukan adalah melakukan backup database secara keseluruhan, agar supaya bisa dilakukan recovery database di waktu berikutnya tanpa mengalami kendala. CMIIW, Bw --- In indo-oracle@ yahoogroups. com, "adhika_rexuss" <adhika_rexuss@ ...> wrote: > > > Halo semua nya, > saya sedang belajar melakukan incomplete recover nih. Iseng-iseng, saya > dapet pertanyaan seperti ini nih: > > Data file DF1 belongs to tablespace TS1, and the database is in > ARCHIVELOG mode. You did an incomplete recovery in the following steps: > > > > 1. Take data file DF1 offline. > > 2. Copy a backup copy of DF1 into the current DF1 location. > > 3. Execute RECOVER DATAFILE UNTIL TIME sometime in the past. > > 4. Bring DF1 online. > > 5. Execute ALTER DATABASE OPEN RESETLOGS. > > > > To guarantee that the database is recoverable in the future, what is the > least amount of work needed? > > > > A. Back up the data file. > > B. Bring tablespace TS1 online. > > C. Copy redo logs to the backup directory. > > D. Make a complete backup right after opening the database. > > E. Copy the data file DF1 back to the backup directory. > > > Answer: D > karena ngga percaya nya kalo oracle bisa recover 1 datafile secara > incomplete, maka saya mencoba seperti di bawah ini. tapi saya gagal > melakukan seperti yang ada di pertanyaan tersebut. mohon pencerahannya > nih. > > C:\> sqlplus /nolog > > SQL> connect adhika/adhika as sysdba > connected > SQL> create table testrman ( > 2 no number, > 3 keterangan varchar(200) ); > > Table created. > > SQL> select sysdate from dual; > > SYSDATE > ------------ ------- > 2007-05-22:18: 25:22 > > SQL> insert into testrman values (1, 'data 1, sebelum full backup'); > > 1 row created. > > SQL> insert into testrman values (1, 'data 2, sebelum full backup'); > > 1 row created. > > SQL> commit; > > Commit complete. > > SQL> select sysdate from dual; > > SYSDATE > ------------ ------- > 2007-05-22:18: 27:23 > > SQL> connect sys/oracle as sysdba > connected > SQL> shutdown immediate; > Database closed. > Database dismounted. > ORACLE instance shut down. > > copy full database ke folder lain. > > SQL> startup > ORACLE instance started. > > Total System Global Area 118561572 bytes > Fixed Size 453412 bytes > Variable Size 92274688 bytes > Database Buffers 25165824 bytes > Redo Buffers 667648 bytes > Database mounted. > Database opened. > SQL> select sysdate from dual; > > SYSDATE > ------------ ------- > 2007-05-22:18: 36:17 > > SQL> connect adhika/adhika > Connected. > SQL> select * from testrman; > > NO KETERANGAN > ---------- ------------ --------- -------- > 1 data 1, sebelum full backup > 1 data 2, sebelum full backup > > SQL> connect sys/oracle as sysdba > Connected. > SQL> alter system switch logfile; > > System altered. > > SQL> alter system switch logfile; > > System altered. > > SQL> alter system switch logfile; > > System altered. > > SQL> select sysdate from dual; > > SYSDATE > ------------ ------- > 2007-05-22:18: 38:16 > > SQL> connect adhika/adhika > Connected. > SQL> drop table testrman; > > Table dropped. > > SQL> select sysdate from dual; > > SYSDATE > ------------ ------- > 2007-05-22:18: 39:00 > > SQL> connect sys/oracle as sysdba > Connected. > SQL> alter database datafile 6 offline; > > Database altered. > > copy file datafile 6 yang isinya table tersebut dari full backup diatas > ke dalam folder databasenya. > > SQL> recover datafile 6 until '2007-05-21: 18:38:00' ; > ORA-00274: illegal recovery option UNTIL > > SQL> show user > USER is "SYS" > SQL> shutdown immediate; > Database closed. > Database dismounted. > ORACLE instance shut down. > SQL> startup mount > ORACLE instance started. > > Total System Global Area 118561572 bytes > Fixed Size 453412 bytes > Variable Size 92274688 bytes > Database Buffers 25165824 bytes > Redo Buffers 667648 bytes > Database mounted. > SQL> recover datafile 6 until '2007-05-21: 18:38:00' ; > ORA-00274: illegal recovery option UNTIL > > gimana yah caranya supaya saya bisa incomplete recovery hanya untuk satu > datafile tersebut? > apa ada langkah2 saya yang kurang? > > regards, > Adhika > > > > [Non-text portions of this message have been removed] > ____________________________________________________________________________________Take the Internet to Go: Yahoo!Go puts the Internet in your pocket: mail, news, photos & more. http://mobile.yahoo.com/go?refer=1GNXIC [Non-text portions of this message have been removed]
