Rcover database using backup controlfile after datafile added into database
该篇文章再现了使用备份控制文件恢复数据库,但是在控制文件备份之后向数据库里面添加了数据文件(没有开启控制文件自动备份),即改变了数据库的物理结构,导致物理结构和控制文件里面记录的信息不一致的情况。
数据库需要开启归档模式,不需要数据库的备份。
1.查询数据库的相关状态
SQL> select name from v$controlfile;
NAME
--------------------------------------------------------------------------------
/ORADATA/szscdb/control01.ctl
/ORADATA/szscdb/control02.ctl
/ORADATA/szscdb/control03.ctl
---使用该SQL语句对控制文件和物理文件信息做全外连接查询
SELECT t.TS#,t.NAME FROM_CTL,ts.tablespace_name FROM_DATAFILE
FROM V$TABLESPACE t FULL OUTER JOIN DBA_TABLESPACES ts
ON (t.NAME=ts.tablespace_name);
TS# FROM_CTL FROM_DATAFILE
---------- ------------------------------ ------------------------------
0 SYSTEM SYSTEM
1 UNDOTBS1 UNDOTBS1
2 SYSAUX SYSAUX
3 TEMP TEMP
4 USERS USERS
6 EXAMPLE EXAMPLE
6 rows selected.
2.使用rman copy当前的控制文件
SQL> !rman target /
Recovery Manager: Release 11.2.0.3.0 - Production on Wed Jul 10 06:55:09 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: SZSCDB (DBID=2429344538)
RMAN> list copy;
using target database control file instead of recovery catalog
specification does not match any datafile copy in the repository
specification does not match any control file copy in the repository
specification does not match any archived log in the repository
RMAN> copy current controlfile to '/tmp/control_20130710.bak';
Starting backup at 10-JUL-13
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=13 device type=DISK
channel ORA_DISK_1: starting datafile copy
copying current control file
output file name=/tmp/control_20130710.bak tag=TAG20130710T065632 RECID=3 STAMP=820392994
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
Finished backup at 10-JUL-13
RMAN> crosscheck copy;
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=145 device type=DISK
specification does not match any datafile copy in the repository
specification does not match any archived log in the repository
validation succeeded for control file copy
control file copy file name=/tmp/control_20130710.bak RECID=3 STAMP=820392994
Crosschecked 1 objects
2.创建测试数据
SQL> CREATE TABLESPACE JSSZ DATAFILE '/ORADATA/szscdb/jssz01.dbf' size 100M;
Tablespace created.
SQL> ALTER TABLESPACE JSSZ ADD DATAFILE '/ORADATA/szscdb/jssz02.dbf' SIZE 300M AUTOEXTEND ON NEXT 30M;
Tablespace altered.
--创建测试表T
SQL> set timing on
SQL> CREATE TABLE T (ID INT,NAME VARCHAR2(20))
2 TABLESPACE JSSZ;
Table created.
Elapsed: 00:00:00.02
---循环快速插入一千万条记录
declare
i NUMBER;
begin
for i in 1..10000000 loop
INSERT INTO T VALUES(i,'szsckj.com');
end LOOP;
END;
/
PL/SQL procedure successfully completed.
Elapsed: 00:14:46.73
--这尼玛的速度慢的无语了。
alert.log中报出:
Checkpoint not complete
Current log# 2 seq# 80 mem# 0: /ORADATA/szscdb/redo02.log
Thread 1 advanced to log sequence 81 (LGWR switch)
Current log# 3 seq# 81 mem# 0: /ORADATA/szscdb/redo03.log
由于数据库处于归档模式,日志切的太快导致日志没有被完全归档所产生的等待。
[root@szsckj ~]# df -h
]Filesystem Size Used Avail Use% Mounted on
/dev/sda1 6.8G 2.9G 3.6G 46% /
/dev/sda3 9.9G 4.2G 5.2G 45% /RECO
/dev/sda2 9.7G 4.1G 5.2G 44% /u02
tmpfs 1014M 0 1014M 0% /dev/shm
/dev/sdb1 7.9G 3.1G 4.5G 42% /ORADATA
[root@szsckj ~]# iostat
Linux 2.6.18-164.el5 (szsckj) 07/10/2013
avg-cpu: %user %nice %system %iowait %steal %idle
3.29 0.01 2.80 2.28 0.00 91.62
Device: tps Blk_read/s Blk_wrtn/s Blk_read Blk_wrtn
sda 2.16 34.34 286.37 1145098 9550400
sda1 0.91 23.29 22.00 776738 733680
sda2 0.90 10.74 9.52 358215 317568
sda3 0.34 0.10 250.14 3287 8342120
sda4 0.00 0.00 0.00 8 0
sda5 0.02 0.19 4.71 6426 157032
sdb 4.29 47.84 519.03 1595415 17309392
sdb1 4.29 47.80 519.03 1594047 17309392
SQL> set autotrace traceonly
SQL> select count(*) from t;
Elapsed: 00:00:00.42
Execution Plan
----------------------------------------------------------
Plan hash value: 2966233522
-------------------------------------------------------------------
| Id | Operation | Name | Rows | Cost (%CPU)| Time |
-------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 6882 (4)| 00:01:23 |
| 1 | SORT AGGREGATE | | 1 | | |
| 2 | TABLE ACCESS FULL| T | 8232K| 6882 (4)| 00:01:23 |
-------------------------------------------------------------------
Note
-----
- dynamic sampling used for this statement (level=2)
Statistics
----------------------------------------------------------
0 recursive calls
1 db block gets
30466 consistent gets
16026 physical reads
0 redo size
422 bytes sent via SQL*Net to client
420 bytes received via SQL*Net from client
2 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
1 rows processed
3.模拟控制文件丢失的恢复
oracle@szsckj:/ORADATA/szscdb>mv control0* /tmp/
SQL> shutdown immediate;
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/ORADATA/szscdb/control01.ctl'
ORA-27041: unable to open file
Linux Error: 2: No such file or directory
Additional information: 3
SQL> shutdown abort;
3.1使用备份控制文件恢复
oracle@szsckj:/tmp>cp control_20130710.bak /ORADATA/szscdb/
oracle@szsckj:/tmp>cd /ORADATA/szscdb/
oracle@szsckj:/ORADATA/szscdb>mv control_20130710.bak control01.ctl
oracle@szsckj:/ORADATA/szscdb>cp control01.ctl control02.ctl
oracle@szsckj:/ORADATA/szscdb>cp control01.ctl control03.ctl
3.2启动数据库到mount状态
SQL> startup mount;
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/ORADATA/szscdb/system01.dbf'
SQL> recover database;
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
SQL> recover database using backup controlfile;
ORA-00279: change 1715168 generated at 07/10/2013 07:01:34 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_1_820393294.dbf
ORA-00280: change 1715168 for thread 1 is in sequence #1
Specify log: {=suggested | filename | AUTO | CANCEL}
AUTO
ORA-00283: recovery session canceled due to errors
ORA-01244: unnamed datafile(s) added to control file by media recovery
ORA-01110: data file 6: '/ORADATA/szscdb/jssz01.dbf'
ORA-01112: media recovery not started
SQL> select file#,name from v$datafile
2 where file#=6;
FILE# NAME
---------- -----------------------------------
6 /u02/app/oracle/products/11.2.0/dbs
/UNNAMED00006
---Oracle发现归档中出现一点不认识的家伙,虽然不任何但是也帮你加入控制文件了,给他一个名字UNNAMED0006,现在需要做的只是将控制文件中的改文件路径指向其物理的路径
'/ORADATA/szscdb/jssz01.dbf'
SQL> alter database rename file '/u02/app/oracle/products/11.2.0/dbs/UNNAMED00006' to
2 '/ORADATA/szscdb/jssz01.dbf';
Database altered.
----继续执行recover database using backup controlfile
SQL> recover database using backup controlfile;
ORA-00279: change 1715202 generated at 07/10/2013 07:03:49 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_1_820393294.dbf
ORA-00280: change 1715202 for thread 1 is in sequence #1
Specify log: {=suggested | filename | AUTO | CANCEL}
AUTO
ORA-00279: change 1717607 generated at 07/10/2013 07:13:46 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_2_820393294.dbf
ORA-00280: change 1717607 for thread 1 is in sequence #2
ORA-00278: log file '/RECO/arch/szscdb/1_1_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1719060 generated at 07/10/2013 07:14:01 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_3_820393294.dbf
ORA-00280: change 1719060 for thread 1 is in sequence #3
ORA-00278: log file '/RECO/arch/szscdb/1_2_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1720683 generated at 07/10/2013 07:14:21 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_4_820393294.dbf
ORA-00280: change 1720683 for thread 1 is in sequence #4
ORA-00278: log file '/RECO/arch/szscdb/1_3_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1722139 generated at 07/10/2013 07:14:39 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_5_820393294.dbf
ORA-00280: change 1722139 for thread 1 is in sequence #5
ORA-00278: log file '/RECO/arch/szscdb/1_4_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1723757 generated at 07/10/2013 07:14:54 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_6_820393294.dbf
ORA-00280: change 1723757 for thread 1 is in sequence #6
ORA-00278: log file '/RECO/arch/szscdb/1_5_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1725317 generated at 07/10/2013 07:15:07 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_7_820393294.dbf
ORA-00280: change 1725317 for thread 1 is in sequence #7
ORA-00278: log file '/RECO/arch/szscdb/1_6_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1726862 generated at 07/10/2013 07:15:28 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_8_820393294.dbf
ORA-00280: change 1726862 for thread 1 is in sequence #8
ORA-00278: log file '/RECO/arch/szscdb/1_7_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1728456 generated at 07/10/2013 07:15:44 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_9_820393294.dbf
ORA-00280: change 1728456 for thread 1 is in sequence #9
ORA-00278: log file '/RECO/arch/szscdb/1_8_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1730046 generated at 07/10/2013 07:15:55 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_10_820393294.dbf
ORA-00280: change 1730046 for thread 1 is in sequence #10
ORA-00278: log file '/RECO/arch/szscdb/1_9_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1731541 generated at 07/10/2013 07:16:12 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_11_820393294.dbf
ORA-00280: change 1731541 for thread 1 is in sequence #11
ORA-00278: log file '/RECO/arch/szscdb/1_10_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1733101 generated at 07/10/2013 07:16:33 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_12_820393294.dbf
ORA-00280: change 1733101 for thread 1 is in sequence #12
ORA-00278: log file '/RECO/arch/szscdb/1_11_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1734699 generated at 07/10/2013 07:16:47 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_13_820393294.dbf
ORA-00280: change 1734699 for thread 1 is in sequence #13
ORA-00278: log file '/RECO/arch/szscdb/1_12_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1736265 generated at 07/10/2013 07:16:58 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_14_820393294.dbf
ORA-00280: change 1736265 for thread 1 is in sequence #14
ORA-00278: log file '/RECO/arch/szscdb/1_13_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1737869 generated at 07/10/2013 07:17:18 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_15_820393294.dbf
ORA-00280: change 1737869 for thread 1 is in sequence #15
ORA-00278: log file '/RECO/arch/szscdb/1_14_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1739471 generated at 07/10/2013 07:17:38 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_16_820393294.dbf
ORA-00280: change 1739471 for thread 1 is in sequence #16
ORA-00278: log file '/RECO/arch/szscdb/1_15_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1740869 generated at 07/10/2013 07:17:51 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_17_820393294.dbf
ORA-00280: change 1740869 for thread 1 is in sequence #17
ORA-00278: log file '/RECO/arch/szscdb/1_16_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1742453 generated at 07/10/2013 07:18:02 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_18_820393294.dbf
ORA-00280: change 1742453 for thread 1 is in sequence #18
ORA-00278: log file '/RECO/arch/szscdb/1_17_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1744066 generated at 07/10/2013 07:18:23 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_19_820393294.dbf
ORA-00280: change 1744066 for thread 1 is in sequence #19
ORA-00278: log file '/RECO/arch/szscdb/1_18_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1746280 generated at 07/10/2013 07:18:44 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_20_820393294.dbf
ORA-00280: change 1746280 for thread 1 is in sequence #20
ORA-00278: log file '/RECO/arch/szscdb/1_19_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1747677 generated at 07/10/2013 07:19:03 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_21_820393294.dbf
ORA-00280: change 1747677 for thread 1 is in sequence #21
ORA-00278: log file '/RECO/arch/szscdb/1_20_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1749269 generated at 07/10/2013 07:19:17 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_22_820393294.dbf
ORA-00280: change 1749269 for thread 1 is in sequence #22
ORA-00278: log file '/RECO/arch/szscdb/1_21_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1750762 generated at 07/10/2013 07:19:42 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_23_820393294.dbf
ORA-00280: change 1750762 for thread 1 is in sequence #23
ORA-00278: log file '/RECO/arch/szscdb/1_22_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1752195 generated at 07/10/2013 07:20:04 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_24_820393294.dbf
ORA-00280: change 1752195 for thread 1 is in sequence #24
ORA-00278: log file '/RECO/arch/szscdb/1_23_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1753782 generated at 07/10/2013 07:20:25 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_25_820393294.dbf
ORA-00280: change 1753782 for thread 1 is in sequence #25
ORA-00278: log file '/RECO/arch/szscdb/1_24_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1754983 generated at 07/10/2013 07:20:36 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_26_820393294.dbf
ORA-00280: change 1754983 for thread 1 is in sequence #26
ORA-00278: log file '/RECO/arch/szscdb/1_25_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1755976 generated at 07/10/2013 07:20:47 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_27_820393294.dbf
ORA-00280: change 1755976 for thread 1 is in sequence #27
ORA-00278: log file '/RECO/arch/szscdb/1_26_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1756889 generated at 07/10/2013 07:20:57 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_28_820393294.dbf
ORA-00280: change 1756889 for thread 1 is in sequence #28
ORA-00278: log file '/RECO/arch/szscdb/1_27_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1757806 generated at 07/10/2013 07:21:13 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_29_820393294.dbf
ORA-00280: change 1757806 for thread 1 is in sequence #29
ORA-00278: log file '/RECO/arch/szscdb/1_28_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1758726 generated at 07/10/2013 07:21:27 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_30_820393294.dbf
ORA-00280: change 1758726 for thread 1 is in sequence #30
ORA-00278: log file '/RECO/arch/szscdb/1_29_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1759649 generated at 07/10/2013 07:21:41 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_31_820393294.dbf
ORA-00280: change 1759649 for thread 1 is in sequence #31
ORA-00278: log file '/RECO/arch/szscdb/1_30_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1760571 generated at 07/10/2013 07:21:58 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_32_820393294.dbf
ORA-00280: change 1760571 for thread 1 is in sequence #32
ORA-00278: log file '/RECO/arch/szscdb/1_31_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1761480 generated at 07/10/2013 07:22:09 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_33_820393294.dbf
ORA-00280: change 1761480 for thread 1 is in sequence #33
ORA-00278: log file '/RECO/arch/szscdb/1_32_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1779661 generated at 07/10/2013 07:23:08 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_34_820393294.dbf
ORA-00280: change 1779661 for thread 1 is in sequence #34
ORA-00278: log file '/RECO/arch/szscdb/1_33_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1780224 generated at 07/10/2013 07:23:29 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_35_820393294.dbf
ORA-00280: change 1780224 for thread 1 is in sequence #35
ORA-00278: log file '/RECO/arch/szscdb/1_34_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1780817 generated at 07/10/2013 07:23:56 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_36_820393294.dbf
ORA-00280: change 1780817 for thread 1 is in sequence #36
ORA-00278: log file '/RECO/arch/szscdb/1_35_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1780905 generated at 07/10/2013 07:24:29 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_37_820393294.dbf
ORA-00280: change 1780905 for thread 1 is in sequence #37
ORA-00278: log file '/RECO/arch/szscdb/1_36_820393294.dbf' no longer needed for
this recovery
ORA-00283: recovery session canceled due to errors
ORA-01244: unnamed datafile(s) added to control file by media recovery
ORA-01110: data file 7: '/ORADATA/szscdb/jssz02.dbf'
ORA-01112: media recovery not started
----同样的问题
SQL> select file#,name from v$datafile
2 where file#=7;
FILE# NAME
---------- -----------------------------------
7 /u02/app/oracle/products/11.2.0/dbs
/UNNAMED00007
SQL> alter database rename file '/u02/app/oracle/products/11.2.0/dbs/UNNAMED00007' to
2 '/ORADATA/szscdb/jssz02.dbf';
SQL> recover database using backup controlfile;
ORA-00279: change 1781030 generated at 07/10/2013 07:27:57 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_37_820393294.dbf
ORA-00280: change 1781030 for thread 1 is in sequence #37
Specify log: {=suggested | filename | AUTO | CANCEL}
AUTO
ORA-00279: change 1781954 generated at 07/10/2013 07:30:31 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_38_820393294.dbf
ORA-00280: change 1781954 for thread 1 is in sequence #38
ORA-00278: log file '/RECO/arch/szscdb/1_37_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1783570 generated at 07/10/2013 07:30:40 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_39_820393294.dbf
ORA-00280: change 1783570 for thread 1 is in sequence #39
ORA-00278: log file '/RECO/arch/szscdb/1_38_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1785018 generated at 07/10/2013 07:30:50 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_40_820393294.dbf
ORA-00280: change 1785018 for thread 1 is in sequence #40
ORA-00278: log file '/RECO/arch/szscdb/1_39_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1786628 generated at 07/10/2013 07:31:04 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_41_820393294.dbf
ORA-00280: change 1786628 for thread 1 is in sequence #41
ORA-00278: log file '/RECO/arch/szscdb/1_40_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1788243 generated at 07/10/2013 07:31:17 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_42_820393294.dbf
ORA-00280: change 1788243 for thread 1 is in sequence #42
ORA-00278: log file '/RECO/arch/szscdb/1_41_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1789855 generated at 07/10/2013 07:31:33 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_43_820393294.dbf
ORA-00280: change 1789855 for thread 1 is in sequence #43
ORA-00278: log file '/RECO/arch/szscdb/1_42_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1791429 generated at 07/10/2013 07:31:44 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_44_820393294.dbf
ORA-00280: change 1791429 for thread 1 is in sequence #44
ORA-00278: log file '/RECO/arch/szscdb/1_43_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1793033 generated at 07/10/2013 07:31:58 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_45_820393294.dbf
ORA-00280: change 1793033 for thread 1 is in sequence #45
ORA-00278: log file '/RECO/arch/szscdb/1_44_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1794658 generated at 07/10/2013 07:32:11 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_46_820393294.dbf
ORA-00280: change 1794658 for thread 1 is in sequence #46
ORA-00278: log file '/RECO/arch/szscdb/1_45_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1796273 generated at 07/10/2013 07:32:22 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_47_820393294.dbf
ORA-00280: change 1796273 for thread 1 is in sequence #47
ORA-00278: log file '/RECO/arch/szscdb/1_46_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1797880 generated at 07/10/2013 07:32:37 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_48_820393294.dbf
ORA-00280: change 1797880 for thread 1 is in sequence #48
ORA-00278: log file '/RECO/arch/szscdb/1_47_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1799482 generated at 07/10/2013 07:32:49 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_49_820393294.dbf
ORA-00280: change 1799482 for thread 1 is in sequence #49
ORA-00278: log file '/RECO/arch/szscdb/1_48_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1801092 generated at 07/10/2013 07:33:07 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_50_820393294.dbf
ORA-00280: change 1801092 for thread 1 is in sequence #50
ORA-00278: log file '/RECO/arch/szscdb/1_49_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1802708 generated at 07/10/2013 07:33:21 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_51_820393294.dbf
ORA-00280: change 1802708 for thread 1 is in sequence #51
ORA-00278: log file '/RECO/arch/szscdb/1_50_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1804313 generated at 07/10/2013 07:33:35 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_52_820393294.dbf
ORA-00280: change 1804313 for thread 1 is in sequence #52
ORA-00278: log file '/RECO/arch/szscdb/1_51_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1805934 generated at 07/10/2013 07:33:50 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_53_820393294.dbf
ORA-00280: change 1805934 for thread 1 is in sequence #53
ORA-00278: log file '/RECO/arch/szscdb/1_52_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1807577 generated at 07/10/2013 07:34:03 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_54_820393294.dbf
ORA-00280: change 1807577 for thread 1 is in sequence #54
ORA-00278: log file '/RECO/arch/szscdb/1_53_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1809174 generated at 07/10/2013 07:34:20 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_55_820393294.dbf
ORA-00280: change 1809174 for thread 1 is in sequence #55
ORA-00278: log file '/RECO/arch/szscdb/1_54_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1810766 generated at 07/10/2013 07:34:33 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_56_820393294.dbf
ORA-00280: change 1810766 for thread 1 is in sequence #56
ORA-00278: log file '/RECO/arch/szscdb/1_55_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1812360 generated at 07/10/2013 07:34:47 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_57_820393294.dbf
ORA-00280: change 1812360 for thread 1 is in sequence #57
ORA-00278: log file '/RECO/arch/szscdb/1_56_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1814015 generated at 07/10/2013 07:35:03 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_58_820393294.dbf
ORA-00280: change 1814015 for thread 1 is in sequence #58
ORA-00278: log file '/RECO/arch/szscdb/1_57_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1815613 generated at 07/10/2013 07:35:17 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_59_820393294.dbf
ORA-00280: change 1815613 for thread 1 is in sequence #59
ORA-00278: log file '/RECO/arch/szscdb/1_58_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1817219 generated at 07/10/2013 07:35:32 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_60_820393294.dbf
ORA-00280: change 1817219 for thread 1 is in sequence #60
ORA-00278: log file '/RECO/arch/szscdb/1_59_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1818844 generated at 07/10/2013 07:35:48 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_61_820393294.dbf
ORA-00280: change 1818844 for thread 1 is in sequence #61
ORA-00278: log file '/RECO/arch/szscdb/1_60_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1820439 generated at 07/10/2013 07:36:05 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_62_820393294.dbf
ORA-00280: change 1820439 for thread 1 is in sequence #62
ORA-00278: log file '/RECO/arch/szscdb/1_61_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1822026 generated at 07/10/2013 07:36:23 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_63_820393294.dbf
ORA-00280: change 1822026 for thread 1 is in sequence #63
ORA-00278: log file '/RECO/arch/szscdb/1_62_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1823572 generated at 07/10/2013 07:36:35 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_64_820393294.dbf
ORA-00280: change 1823572 for thread 1 is in sequence #64
ORA-00278: log file '/RECO/arch/szscdb/1_63_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1825163 generated at 07/10/2013 07:36:52 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_65_820393294.dbf
ORA-00280: change 1825163 for thread 1 is in sequence #65
ORA-00278: log file '/RECO/arch/szscdb/1_64_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1826604 generated at 07/10/2013 07:37:06 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_66_820393294.dbf
ORA-00280: change 1826604 for thread 1 is in sequence #66
ORA-00278: log file '/RECO/arch/szscdb/1_65_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1828187 generated at 07/10/2013 07:37:22 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_67_820393294.dbf
ORA-00280: change 1828187 for thread 1 is in sequence #67
ORA-00278: log file '/RECO/arch/szscdb/1_66_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1829777 generated at 07/10/2013 07:37:38 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_68_820393294.dbf
ORA-00280: change 1829777 for thread 1 is in sequence #68
ORA-00278: log file '/RECO/arch/szscdb/1_67_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1831367 generated at 07/10/2013 07:37:50 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_69_820393294.dbf
ORA-00280: change 1831367 for thread 1 is in sequence #69
ORA-00278: log file '/RECO/arch/szscdb/1_68_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1832954 generated at 07/10/2013 07:38:03 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_70_820393294.dbf
ORA-00280: change 1832954 for thread 1 is in sequence #70
ORA-00278: log file '/RECO/arch/szscdb/1_69_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1834552 generated at 07/10/2013 07:38:19 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_71_820393294.dbf
ORA-00280: change 1834552 for thread 1 is in sequence #71
ORA-00278: log file '/RECO/arch/szscdb/1_70_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1836138 generated at 07/10/2013 07:38:35 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_72_820393294.dbf
ORA-00280: change 1836138 for thread 1 is in sequence #72
ORA-00278: log file '/RECO/arch/szscdb/1_71_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1837687 generated at 07/10/2013 07:38:53 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_73_820393294.dbf
ORA-00280: change 1837687 for thread 1 is in sequence #73
ORA-00278: log file '/RECO/arch/szscdb/1_72_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1839277 generated at 07/10/2013 07:39:06 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_74_820393294.dbf
ORA-00280: change 1839277 for thread 1 is in sequence #74
ORA-00278: log file '/RECO/arch/szscdb/1_73_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1840877 generated at 07/10/2013 07:39:20 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_75_820393294.dbf
ORA-00280: change 1840877 for thread 1 is in sequence #75
ORA-00278: log file '/RECO/arch/szscdb/1_74_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1842466 generated at 07/10/2013 07:39:36 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_76_820393294.dbf
ORA-00280: change 1842466 for thread 1 is in sequence #76
ORA-00278: log file '/RECO/arch/szscdb/1_75_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1844142 generated at 07/10/2013 07:40:09 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_77_820393294.dbf
ORA-00280: change 1844142 for thread 1 is in sequence #77
ORA-00278: log file '/RECO/arch/szscdb/1_76_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1845667 generated at 07/10/2013 07:40:23 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_78_820393294.dbf
ORA-00280: change 1845667 for thread 1 is in sequence #78
ORA-00278: log file '/RECO/arch/szscdb/1_77_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1847205 generated at 07/10/2013 07:40:42 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_79_820393294.dbf
ORA-00280: change 1847205 for thread 1 is in sequence #79
ORA-00278: log file '/RECO/arch/szscdb/1_78_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1848658 generated at 07/10/2013 07:40:57 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_80_820393294.dbf
ORA-00280: change 1848658 for thread 1 is in sequence #80
ORA-00278: log file '/RECO/arch/szscdb/1_79_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1850262 generated at 07/10/2013 07:41:13 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_81_820393294.dbf
ORA-00280: change 1850262 for thread 1 is in sequence #81
ORA-00278: log file '/RECO/arch/szscdb/1_80_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1851849 generated at 07/10/2013 07:41:27 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_82_820393294.dbf
ORA-00280: change 1851849 for thread 1 is in sequence #82
ORA-00278: log file '/RECO/arch/szscdb/1_81_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1853455 generated at 07/10/2013 07:41:43 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_83_820393294.dbf
ORA-00280: change 1853455 for thread 1 is in sequence #83
ORA-00278: log file '/RECO/arch/szscdb/1_82_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1855042 generated at 07/10/2013 07:41:59 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_84_820393294.dbf
ORA-00280: change 1855042 for thread 1 is in sequence #84
ORA-00278: log file '/RECO/arch/szscdb/1_83_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1856717 generated at 07/10/2013 07:42:16 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_85_820393294.dbf
ORA-00280: change 1856717 for thread 1 is in sequence #85
ORA-00278: log file '/RECO/arch/szscdb/1_84_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1858311 generated at 07/10/2013 07:42:34 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_86_820393294.dbf
ORA-00280: change 1858311 for thread 1 is in sequence #86
ORA-00278: log file '/RECO/arch/szscdb/1_85_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1859898 generated at 07/10/2013 07:42:50 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_87_820393294.dbf
ORA-00280: change 1859898 for thread 1 is in sequence #87
ORA-00278: log file '/RECO/arch/szscdb/1_86_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1861265 generated at 07/10/2013 07:43:06 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_88_820393294.dbf
ORA-00280: change 1861265 for thread 1 is in sequence #88
ORA-00278: log file '/RECO/arch/szscdb/1_87_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1862864 generated at 07/10/2013 07:43:24 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_89_820393294.dbf
ORA-00280: change 1862864 for thread 1 is in sequence #89
ORA-00278: log file '/RECO/arch/szscdb/1_88_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1864417 generated at 07/10/2013 07:43:40 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_90_820393294.dbf
ORA-00280: change 1864417 for thread 1 is in sequence #90
ORA-00278: log file '/RECO/arch/szscdb/1_89_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1866006 generated at 07/10/2013 07:43:55 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_91_820393294.dbf
ORA-00280: change 1866006 for thread 1 is in sequence #91
ORA-00278: log file '/RECO/arch/szscdb/1_90_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1867601 generated at 07/10/2013 07:44:11 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_92_820393294.dbf
ORA-00280: change 1867601 for thread 1 is in sequence #92
ORA-00278: log file '/RECO/arch/szscdb/1_91_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1869201 generated at 07/10/2013 07:44:29 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_93_820393294.dbf
ORA-00280: change 1869201 for thread 1 is in sequence #93
ORA-00278: log file '/RECO/arch/szscdb/1_92_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1870788 generated at 07/10/2013 07:44:45 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_94_820393294.dbf
ORA-00280: change 1870788 for thread 1 is in sequence #94
ORA-00278: log file '/RECO/arch/szscdb/1_93_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1872384 generated at 07/10/2013 07:45:04 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_95_820393294.dbf
ORA-00280: change 1872384 for thread 1 is in sequence #95
ORA-00278: log file '/RECO/arch/szscdb/1_94_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1873834 generated at 07/10/2013 07:50:51 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_96_820393294.dbf
ORA-00280: change 1873834 for thread 1 is in sequence #96
ORA-00278: log file '/RECO/arch/szscdb/1_95_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1874691 generated at 07/10/2013 07:51:01 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_97_820393294.dbf
ORA-00280: change 1874691 for thread 1 is in sequence #97
ORA-00278: log file '/RECO/arch/szscdb/1_96_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1875610 generated at 07/10/2013 07:51:16 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_98_820393294.dbf
ORA-00280: change 1875610 for thread 1 is in sequence #98
ORA-00278: log file '/RECO/arch/szscdb/1_97_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1876521 generated at 07/10/2013 07:51:30 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_99_820393294.dbf
ORA-00280: change 1876521 for thread 1 is in sequence #99
ORA-00278: log file '/RECO/arch/szscdb/1_98_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1877439 generated at 07/10/2013 07:51:51 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_100_820393294.dbf
ORA-00280: change 1877439 for thread 1 is in sequence #100
ORA-00278: log file '/RECO/arch/szscdb/1_99_820393294.dbf' no longer needed for
this recovery
ORA-00279: change 1878360 generated at 07/10/2013 07:52:06 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_101_820393294.dbf
ORA-00280: change 1878360 for thread 1 is in sequence #101
ORA-00278: log file '/RECO/arch/szscdb/1_100_820393294.dbf' no longer needed
for this recovery
ORA-00279: change 1879276 generated at 07/10/2013 07:52:21 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_102_820393294.dbf
ORA-00280: change 1879276 for thread 1 is in sequence #102
ORA-00278: log file '/RECO/arch/szscdb/1_101_820393294.dbf' no longer needed
for this recovery
ORA-00279: change 1880181 generated at 07/10/2013 07:52:39 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_103_820393294.dbf
ORA-00280: change 1880181 for thread 1 is in sequence #103
ORA-00278: log file '/RECO/arch/szscdb/1_102_820393294.dbf' no longer needed
for this recovery
ORA-00279: change 1881098 generated at 07/10/2013 07:53:00 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_104_820393294.dbf
ORA-00280: change 1881098 for thread 1 is in sequence #104
ORA-00278: log file '/RECO/arch/szscdb/1_103_820393294.dbf' no longer needed
for this recovery
ORA-00279: change 1882000 generated at 07/10/2013 07:53:24 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_105_820393294.dbf
ORA-00280: change 1882000 for thread 1 is in sequence #105
ORA-00278: log file '/RECO/arch/szscdb/1_104_820393294.dbf' no longer needed
for this recovery
ORA-00279: change 1882808 generated at 07/10/2013 18:42:59 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_106_820393294.dbf
ORA-00280: change 1882808 for thread 1 is in sequence #106
ORA-00278: log file '/RECO/arch/szscdb/1_105_820393294.dbf' no longer needed
for this recovery
ORA-00308: cannot open archived log '/RECO/arch/szscdb/1_106_820393294.dbf'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
---到这里归档已经断掉了,那么恢复所需要的数据可能在redo日志中。
SQL> select group#,status from v$log;
GROUP# STATUS
---------- ----------------
1 CURRENT
3 UNUSED
2 UNUSED
根据返回的结果,数据很可能在第一组日志中。
SQL> recover database using backup controlfile;
ORA-00279: change 1882808 generated at 07/10/2013 18:42:59 needed for thread 1
ORA-00289: suggestion : /RECO/arch/szscdb/1_106_820393294.dbf
ORA-00280: change 1882808 for thread 1 is in sequence #106
Specify log: {=suggested | filename | AUTO | CANCEL}
/ORADATA/szscdb/redo01.log
Log applied.
Media recovery complete.
3.3打开数据库
SQL> select file#,checkpoint_change# from v$datafile;
FILE# CHECKPOINT_CHANGE#
---------- ------------------
1 1883541
2 1883541
3 1883541
4 1883541
5 1883541
6 1883541
7 1883541
7 rows selected.
SQL> select file#,checkpoint_change# from v$datafile_header;
FILE# CHECKPOINT_CHANGE#
---------- ------------------
1 1883541
2 1883541
3 1883541
4 1883541
5 1883541
6 1883541
7 1883541
7 rows selected.
SQL> alter database open resetlogs;
Database altered.
小结:没有及时备份控制文件的恢复是比较复杂和繁琐的,所以建议开启控制文件自动备份。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26169542/viewspace-765992/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/26169542/viewspace-765992/