开发学院数据库 Oracle 使用Oracle10g新特性,跨越Resetlogs时间点进行恢复... 阅读

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

　2007-07-24 12:34:40　来源：WEB开发网　闂傚倷绶氬ḿ褍螞閹绢喖绠柨鐕傛嫹

闂傚倷绀侀幉锟犲垂閻㈠灚宕查柟鎵閸庡秵銇勯幒鎴濃偓鐢稿磻閹炬枼妲堟繛鍡楃С濞岊亞绱撻崒姘扁枌闁瑰嚖鎷�

婵犵數濮幏鍐川椤撴繄鎹曢梻渚€娼уú銈吤洪妸鈺佺劦妞ゆ帊鑳堕埊鏇㈡煏閸モ晛浠х紒杈╁仱閺佹捇鏁撻敓锟�闂傚倷绶氬ḿ褍螞閹绢喖绠柨鐕傛嫹　　闂傚倷鑳舵灙缂佺粯顨呴埢宥夊即閵忕姵鐎梺缁樺姈椤愮厧鈽夊Ο閿嬬€婚梺褰掑亰閸撴稑鈻斿鑸碘拺闁告稑饪村▓鏃€绻涚仦鍌氬闁崇粯鎹囬獮瀣攽閹邦剚顔傛俊鐐€栧濠氬储瑜忛幉鎾晸閿燂拷

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.