ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Rcover database using backup controlfile after datafile added into database

Rcover database using backup controlfile after datafile added into database

原创 Linux操作系统 作者:DBA_oracle_java 时间:2013-07-10 20:13:12 0 删除 编辑

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/,如需转载,请注明出处,否则将追究法律责任。

上一篇: Linux LVM管理
请登录后发表评论 登录
全部评论

注册时间:2013-07-02

  • 博文量
    31
  • 访问量
    116864