oracle正常关闭下redo丢失恢复(二)
-------
1 1 742 52428800 512 1 YES INACTIVE 11303012 26-AUG-13 11355835 27-AUG-13
3 1 743 52428800 512 1 NO CURRENT 11355835 27-AUG-13 2.8147E+14
2 1 741 52428800 512 1 YES INACTIVE 11265035 26-AUG-13 11303012 26-AUG-13
SQL>
SQL> alter database clear logfile group 1;
Database altered.
SQL> !
[oracle@oracle-one RHYS]$ ls -l
total 4949740
-rw-r-----. 1 oracle oinstall 524296192 Aug 27 17:15 arch_tbs01.dbf
-rw-r-----. 1 oracle oinstall 9846784 Aug 27 17:20 control01.ctl
-rw-r-----. 1 oracle oinstall 52429312 Aug 27 17:20 redo01.log
-rw-r-----. 1 oracle oinstall 52429312 Aug 27 13:22 redo01.log_bak
-rw-r-----. 1 oracle oinstall 52429312 Aug 27 13:22 redo02.log
-rw-r-----. 1 oracle oinstall 52429312 Aug 27 17:15 redo03.log
-rw-r-----. 1 oracle oinstall 209723392 Aug 27 17:15 statspack.dbf
-rw-r-----. 1 oracle oinstall 629153792 Aug 27 17:15 sysaux01.dbf
-rw-r-----. 1 oracle oinstall 1457528832 Aug 27 17:15 system01.dbf
-rw-r-----. 1 oracle oinstall 67117056 Aug 27 13:33 temp01.dbf
-rw-r-----. 1 oracle oinstall 1688215552 Aug 27 17:15 test.dbf
-rw-r-----. 1 oracle oinstall 31465472 Aug 27 17:15 undotbs1.dbf
-rw-r-----. 1 oracle oinstall 262152192 Aug 27 17:15 undotbs3.dbf
-rw-r-----. 1 oracle oinstall 5251072 Aug 27 17:15 users01.dbf
[oracle@oracle-one RHYS]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Tue Aug 27 17:20:32 2013
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
alter database open;
Database altered.
SQL>