使用Oracle10g新特性,跨越Resetlogs时间点进行恢复

核心提示： 4.此时的数据库状态$ sqlplus "/ as sysdba"SQL*Plus: Release 10.1.0.2.0 - Production on Tue Apr 5 16:43:58 2005Copyright (c) 1982, 2004, Oracle.A

4.此时的数据库状态

$ sqlplus "/ as sysdba"
SQL*Plus: Release 10.1.0.2.0 - Production on Tue Apr 5 16:43:58 2005
Copyright (c) 1982, 2004, Oracle.　All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
SYS AS SYSDBA on 2005-04-05 16:43:58 >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
SYS AS SYSDBA on 2005-04-05 16:44:01 >select count(*) from t;
　COUNT(*)
----------
　　 18956

5.继续进行数据更改

SYS AS SYSDBA on 2005-04-05 16:44:08 >create table tt as select * from dba_users;
Table created.
SYS AS SYSDBA on 2005-04-05 16:45:51 >alter system switch logfile;
System altered.
SYS AS SYSDBA on 2005-04-05 16:45:56 >select count(*) from tt;
　COUNT(*)
----------
　　　　12
SYS AS SYSDBA on 2005-04-05 16:46:01 >insert into tt select * from tt;
12 rows created.
SYS AS SYSDBA on 2005-04-05 16:46:13 >commit;
Commit complete.
SYS AS SYSDBA on 2005-04-05 16:46:16 >alter system switch logfile;
System altered.