SQL> archive log list; Database log mode No Archive Mode Automatic archival Disabled Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 1 Next log sequence to archive 1 Current log sequence 1
SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down.
SQL> startup mount; ORACLE instance started. Total System Global Area 135338868 bytes Fixed Size 453492 bytes Variable Size 109051904 bytes Database Buffers 25165824 bytes Redo Buffers 667648 bytes Database mounted.
SQL> alter database archivelog; Database altered.
SQL> alter system set log_archive_start=true scope=spfile; System altered.
SQL> alter database open; Database altered.
SQL> archive log list; Database log mode Archive Mode Automatic archival Enabled Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 1 Next log sequence to archive 1 Current log sequence 1
SQL> create table time_back(name varchar(100)) tablespace users; Table created.
SQL> insert into time_back values('******* 1st *******'); 1 row created.
SQL> insert into time_back values('******* 2nd *******'); 1 row created.
SQL> commit; Commit complete.
SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down.
C:\>copy c:\oracle\product\10.2.0\oradata\dba20\*.DBF "c:\Time Backup" 1 file(s) copied.
SQL> startup; ORACLE instance started. Total System Global Area 167772160 bytes Fixed Size 1247876 bytes Variable Size 79693180 bytes Database Buffers 79691776 bytes Redo Buffers 7139328 bytes Database mounted. Database opened.
SQL> create table time_back2(name varchar(100)) tablespace users; Table created.
SQL> desc time_back2 Name Null? Type ----------------------------------------- -------- -------------------- NAME VARCHAR2(100)
SQL> select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') from dual; TO_CHAR(SYSDATE,'YY ------------------- 2010-06-17 14:43:23
SQL> drop table time_back; Table dropped.
SQL> drop table time_back2; Table dropped.
SQL> select * from time_back; select * from time_back * ERROR at line 1: ORA-00942: table or view does not exist
SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down.
C:\>copy "c:\Time Backup\*.DBF" c:\oracle\product\10.2.0\oradata\dba20\ 1 file(s) copied.
SQL> startup mount; ORACLE instance started. Total System Global Area 167772160 bytes Fixed Size 1247876 bytes Variable Size 79693180 bytes Database Buffers 79691776 bytes Redo Buffers 7139328 bytes Database mounted.
SQL> recover database until time '2010-06-17 15:13:53'; Media recovery complete.
SQL> alter database open resetlogs; Database altered.
SQL> select * from time_back; NAME ------------------------------------------------------------------------- ******* 1st ******* ******* 1st *******
SQL> desc time_back2; Name Null? Type ----------------------------------------- -------- --------------------- NAME VARCHAR2(100) |