maaf mas Agus, saya ndak mengerti dengan error host does not exists tersebut. dan disini saya tidak membutuhkan exp ataupun imp untuk recovery nya. saya maunya incomplete recovery menggunakan Archive Log file.
thanks, Adhika --- In [email protected], agus purwanto <[EMAIL PROTECTED]> wrote: > > salam, > > mas andhika saya coba kok tidak bisa ya, dia menyebutkan host does not exists > kalo saya pake exp yg 10g tidak masalah > > tolong mas beritahu secara detail > > terima kasih, > ags > > > > ----- Original Message ---- > From: adhika_rexuss <[EMAIL PROTECTED]> > To: [email protected] > Sent: Tuesday, May 22, 2007 6:43:43 PM > Subject: [indo-oracle] incomplete recovery untuk satu datafile saja > > > 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] > > > > > > > ____________________________________________________________________________________ > Sucker-punch spam with award-winning protection. > Try the free Yahoo! Mail Beta. > http://advision.webevents.yahoo.com/mailbeta/features_spam.html > > [Non-text portions of this message have been removed] >
