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 [email protected], "adhika_rexuss" <[EMAIL PROTECTED]> 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] >
