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]
