Oracle完全脱机，部分脱机与部分联机备份(四)
11
2 1 165 52428800 1 YES ACTIVE 1322946396143 2013/6/2 11
3 1 166 52428800 1 NO CURRENT 1322946396145 2013/6/2 11
SQL> INSERT INTO t_scn values(3, dbms_flashback.get_system_change_number);
1 row inserted
SQL> commit;
Commit complete
SQL> alter system switch logfile;
System altered
SQL> SELECT * FROM v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- -------- ---------------- ------------- -----------
1 1 167 52428800 1 NO CURRENT 1322946396158 2013/6/2 11
2 1 165 52428800 1 YES ACTIVE 1322946396143 2013/6/2 11
3 1 166 52428800 1 YES ACTIVE 1322946396145 2013/6/2 11
SQL> INSERT INTO t_scn values(3, dbms_flashback.get_system_change_number);
1 row inserted
SQL> commit;
Commit complete
SQL> alter system switch logfile;
System altered
SQL> INSERT INTO t_scn values(4, dbms_flashback.get_system_change_number);
1 row inserted
SQL> commit;
Commit complete
SQL> alter system switch logfile;
System altered
SQL> INSERT INTO t_scn values(4, dbms_flashback.get_system_change_number);
1 row inserted
SQL> commit;
Commit complete
SQL> alter system switch logfile;
System altered
SQL> INSERT INTO t_scn values(5, dbms_flashback.get_system_change_number);
1 row inserted
SQL> INSERT INTO t_scn values(6, dbms_flashback.get_system_change_number);
1 row inserted
SQL> commit;
Commit complete
SQL> alter system switch logfile;
System altered
SQL> INSERT INTO t_scn values(7, dbms_flashback.get_system_change_number);
1 row inserted
SQL> commit;
Commit complete
SQL> alter system switch logfile;
System altered
SQL>
--现在插入一条数据，提交，但是不切换日志文件：
SQL> SELECT * FROM v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- -------- ---------------- ------------- -----------
1 1 170 52428800 1 YES ACTIVE 1322946396162 2013/6/2 11
2 1 171 52428800 1 YES ACTIVE 1322946396163 2013/6/2 11
3 1 172 52428800 1 NO CURRENT 1322946396165 2013/6/2 11
SQL> INSERT INTO t_scn values(8, dbms_flashback.get_system_change_number);
1 row inserted
SQL> commit;
Commit COMPLETE
--最后插入一条数据，但是不提交
INSERT INTO t_scn values(9, dbms_flashback.get_system_change_number);
--这时这条数据可能写到日志文件中也可能没写到日志文件中
--现在我们将
数据库的数据文件删除掉
[oracle@localhost orcl]$ ll
total 2855936
-rw-r----- 1 oracle oinstall 7094272 Jun 2 14:28 control01.ctl
-rw-r----- 1 oracle oinstall 7094272 Jun 2 14:28 control02.ctl
-rw-r----- 1 oracle oinstall 7094272 Jun 2 14:28 control03.ctl
-rw-r----- 1 oracle oinstall 52429312 Jun 2 11:54 redo01.log
-rw-r----- 1 oracle oinstall 52429312 Jun 2 11:55 redo02.log
-rw-r-----