Chinaunix首页 | 论坛 | 博客
  • 博客访问: 423280
  • 博文数量: 119
  • 博客积分: 5221
  • 博客等级: 大校
  • 技术积分: 972
  • 用 户 组: 普通用户
  • 注册时间: 2008-01-04 08:57
文章分类

全部博文(119)

文章存档

2011年(13)

2010年(21)

2009年(19)

2008年(66)

我的朋友

分类: Oracle

2009-11-12 21:50:56

有新同事不小心将数据文件在数据库打开时mv到其他位置了,赶紧关闭数据库采取紧急措施,打开了数据库,操作方法如下:
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 2.7917E+10 bytes
Fixed Size                  2205176 bytes
Variable Size            3885849096 bytes
Database Buffers         2.4025E+10 bytes
Redo Buffers                4259840 bytes
Database mounted.
1、先把数据文件online;
SQL> alter      database        datafile        75      online;
Database altered.
SQL> alter      database        datafile        76      online;
alter   database        datafile        77      online;
Database altered.
SQL>
Database altered.
SQL> alter      database        datafile        78      online;
alter   database        datafile        79      online;
Database altered.
SQL>
Database altered.
SQL> alter      database        datafile        80      online;
alter   database        datafile        81      online;
Database altered.
SQL>
Database altered.
SQL> alter      database        datafile        82      online;
alter   database        datafile        83      online;
alter   database        datafile        84      online;
Database altered.
SQL>
Database altered.
SQL>
Database altered.
SQL> alter      database        datafile        85      online;
alter   database        datafile        86      online;
alter   database        datafile        87      online;
Database altered.
SQL>
Database altered.
SQL>
Database altered.
SQL> alter      database        datafile        88      online;
alter   database        datafile        89      online;
Database altered.
SQL>
Database altered.
SQL> alter      database        datafile        90      online;
alter   database        datafile        91      online;
Database altered.
SQL>
Database altered.
SQL> alter      database        datafile        92      online;
alter   database        datafile        93      online;
Database altered.
SQL>
Database altered.
SQL> alter      database        datafile        94      online;
alter   database        datafile        95      online;
Database altered.
SQL>
Database altered.
SQL> alter      database        datafile        96      online;
Database altered.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 75 needs media recovery
ORA-01110: data file 75: '/ifmdata2/userdata/wcdma/d_sub_wireless_dbs_0.dbf'
2、检查控制文件的checkpoint和数据文件的checkpoint,已经不一致了:
SQL> select checkpoint_change# from v$database;
CHECKPOINT_CHANGE#
------------------
        1064482970
SQL> select checkpoint_change# from v$datafile;
CHECKPOINT_CHANGE#
------------------
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1063939002
        1063939002
        1063939002
        1063939002
        1063939002
        1063939002
        1063939002
        1063939002
        1064482970
        1064482970
        1063939002
        1063939002
        1063939002
        1063939002
        1063939002
        1063939002
        1063939002
        1063939002
        1063939002
        1063939002
        1063939002
        1063939002
        1063939002
        1063939002
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
        1064482970
128 rows selected.
3、试试recover,不行:
SQL> recover database using backup controlfile until cancel;
ORA-00279: change 1049582473 generated at 11/11/2009 17:04:30 needed for thread 1
ORA-00289: suggestion : /archive/flash_recovery_area/SXIWCDMA/archivelog/2009_11_12/o1_mf_1_597_%u_.arc
ORA-00280: change 1049582473 for thread 1 is in sequence #597

Specify log: {=suggested | filename | AUTO | CANCEL}
ORA-00308: cannot open archived log '/archive/flash_recovery_area/SXIWCDMA/archivelog/2009_11_12/o1_mf_1_597_%u_.arc'
ORA-27037: unable to obtain file status
HPUX-ia64 Error: 2: No such file or directory
Additional information: 3

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/ifmdata1/sysdata/system01.dbf'

SQL> recover database using backup controlfile until cancel;
ORA-00279: change 1049582473 generated at 11/11/2009 17:04:30 needed for thread 1
ORA-00289: suggestion : /archive/flash_recovery_area/SXIWCDMA/archivelog/2009_11_12/o1_mf_1_597_%u_.arc
ORA-00280: change 1049582473 for thread 1 is in sequence #597

Specify log: {=suggested | filename | AUTO | CANCEL}
cancel
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/ifmdata1/sysdata/system01.dbf'

ORA-01112: media recovery not started
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/ifmdata1/sysdata/system01.dbf'
4、重建控制文件:
SQL> alter database backup controlfile to trace;
Database altered.
SQL> shutdown immediate
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.
SQL> startup nomount;
ORACLE instance started.
Total System Global Area 2.7917E+10 bytes
Fixed Size                  2205176 bytes
Variable Size            3885849096 bytes
Database Buffers         2.4025E+10 bytes
Redo Buffers                4259840 bytes
SQL> CREATE CONTROLFILE REUSE DATABASE "SXIWCDMA" RESETLOGS  NOARCHIVELOG
  2      MAXLOGFILES 16
    MAXLOGMEMBERS 5
    MAXDATAFILES 1024
    MAXINSTANCES 8
    MAXLOGHISTORY 292
LOGFILE
  GROUP 1 '/redo_log/sysdata/redo01a.log'  SIZE 512M,
  GROUP 2 '/redo_log/sysdata/redo02a.log'  SIZE 512M,
  GROUP 5 '/redo_log/sysdata/redo01b.log'  SIZE 512M,
  GROUP 6 '/redo_log/sysdata/redo02b.log'  SIZE 512M
-- STANDBY LOGFILE
DATAFILE
  '/ifmdata1/sysdata/system01.dbf',
  '/ifmdata3/sysdata/undotbs01.dbf',
  '/ifmdata2/sysdata/sysaux01.dbf',
  3    4    5    6    7    8    9   10   11   12   13   14   15   16   17    '/ifmdata1/sysdata/users01.dbf',
  '/ifmdata1/system02.dbf',
  '/ifmdata1/sysdata/users02.dbf',
  '/ifmdata2/sysdata/sysaux02.dbf',
  '/ifmdata3/sysdata/undotbs02.dbf',
  '/ifmdata3/sysdata/perftemp01.dbf',
  '/ifmdata1/sysdata/wcdmatemp01.dbf',
  '/ifmdata1/userdata/wcdma/d_alarm_dbs.dbf',
  '/ifmdata1/userdata/wcdma/i_alarm_dbs.dbf',
  '/ifmdata1/userdata/wcdma/d_wcdma_dbs.dbf',
  '/ifmdata1/userdata/wcdma/i_wcdma_dbs.dbf',
  '/ifmdata1/userdata/wcdma/d_cs_dbs.dbf',
  '/ifmdata1/userdata/wcdma/i_cs_dbs.dbf',
  '/ifmdata1/userdata/wcdma/d_ps_dbs.dbf',
  '/ifmdata1/userdata/wcdma/i_ps_dbs.dbf',
  '/ifmdata1/userdata/wcdma/d_wireless_dbs_0.dbf',
  '/ifmdata1/userdata/wcdma/d_wireless_dbs_1.dbf',
  '/ifmdata1/userdata/wcdma/d_wireless_dbs_2.dbf',
  '/ifmdata1/userdata/wcdma/d_wireless_dbs_3.dbf',
  '/ifmdata1/userdata/wcdma/d_wireless_dbs_4.dbf',
  '/ifmdata1/userdata/wcdma/d_wireless_dbs_5.dbf',
  '/ifmdata1/userdata/wcdma/d_wireless_dbs_6.dbf',
  '/ifmdata1/userdata/wcdma/d_wireless_db 18   19   20   21   22   23  /userdata/wcdma/d_wireless_dbs_8.dbf',
  '/ifmdata1/userdata/wcdma/d_wireless_dbs_9.dbf',
  '/ifmdata1/userdata/wcdma/d_wireless_dbs_10.dbf',
  '/ifmdata1/userdata/wcdma/d_wireless_dbs_11.dbf',
  '/ifmdata1/userdata/wcdma/d_wireless_dbs_12.dbf',
 24   25   26   27   28   29   30   31   32   33   34   35   36   37   38   39   40   41   42   43   44   45    '/ifmdata1/userdata/wcdma/d_wireless_dbs_13.dbf',
  '/ifmdata1/userdata/wcdma/d_wireless_dbs_14.dbf',
  '/ifmdata1/userdata/wcdma/d_wireless_dbs_15.dbf',
  '/ifmdata1/userdata/wcdma/d_wireless_dbs_16.dbf',
  '/ifmdata1/userdata/wcdma/d_wireless_dbs_17.dbf',
  '/ifmdata1/userdata/wcdma/d_wireless_dbs_18.dbf',
  '/ifmdata1/userdata/wcdma/d_wireless_dbs_19.dbf',
  '/ifmdata1/userdata/wcdma/d_wireless_dbs_20.dbf',
  '/ifmdata1/userdata/wcdma/d_wireless_dbs_21.dbf',
  '/ifmdata1/userdata/wcdma/d_wireless_dbs_22.dbf',
  '/ifmdata1/userdata/wcdma/d_wireless_dbs_23.dbf',
  '/ifmdata1/userdata/wcdma/i_wireless_dbs_0.dbf',
  '/ifmdata1/userdata/wcdma/i_wireless_dbs_1.dbf',
  '/ifmdata1/userdata/wcdma/i_wireless_dbs_2.dbf',
  '/ifmdata1/userdata/wcdma/i_wireless_dbs_3.dbf',
  '/ifmdata1/userdata/wcdma/i_wireless_dbs_4.dbf',
  '/ifmdata1/userdata/wcdma/i_wireless_dbs_5.dbf',
  '/ifmdata1/userdata/wcdma/i_wireless_dbs_6.dbf',
  '/ifmdata1/userdata/wcdma/i_wireless_dbs_7.dbf',
  '/ifmdata1/userdata/wcd 46   47   48  .dbf',
  '/ifmdata1/userdata/wcdma/i_wireless_dbs_9.dbf',
  '/ifmdata1/userdata/wcdma/i_wireless_dbs_10.dbf',
  '/ifmdata1/userdata/wcdma/i_wireless_dbs_11.dbf',
  '/ifmdata2/userdata/wcdma/i_wireless_dbs_12.dbf',
  '/ifmdata2/userdata/wcdma/i_wireless_dbs_13.dbf',
  '/ifmdata2/userdata/wcdma/i_wireless_dbs_14.dbf',
  '/ifmdata2/userdata/wcdma/i_wireless_dbs_15.dbf',
 49   50   51   52   53   54   55   56   57   58   59   60   61   62   63   64   65   66   67   68   69   70   71   72    '/ifmdata2/userdata/wcdma/i_wireless_dbs_16.dbf',
  '/ifmdata2/userdata/wcdma/i_wireless_dbs_17.dbf',
  '/ifmdata2/userdata/wcdma/i_wireless_dbs_18.dbf',
  '/ifmdata2/userdata/wcdma/i_wireless_dbs_19.dbf',
  '/ifmdata2/userdata/wcdma/i_wireless_dbs_20.dbf',
  '/ifmdata2/userdata/wcdma/i_wireless_dbs_21.dbf',
  '/ifmdata2/userdata/wcdma/i_wireless_dbs_22.dbf',
  '/ifmdata2/userdata/wcdma/i_wireless_dbs_23.dbf',
  '/ifmdata3/userdata/wcdma/d_wperf_dbs.dbf',
  '/ifmdata3/userdata/wcdma/i_wperf_dbs.dbf',
  '/ifmdata3/userdata/wcdma/d_adapter_dbs.dbf',
  '/ifmdata3/userdata/wcdma/i_adapter_dbs.dbf',
  '/ifmdata3/userdata/wcdma/d_sub_cs_dbs.dbf',
  '/ifmdata3/userdata/wcdma/i_sub_cs_dbs.dbf',
  '/ifmdata3/userdata/wcdma/d_sub_ps_dbs.dbf',
  '/ifmdata3/userdata/wcdma/i_sub_ps_dbs.dbf',
  '/ifmdata2/userdata/wcdma/d_sub_wireless_dbs_0.dbf',
  '/ifmdata2/userdata/wcdma/d_sub_wireless_dbs_1.dbf',
  '/ifmdata2/userdata/wcdma/d_sub_wireless_dbs_2.dbf',
  '/ifmdata2/userdata/wcdma/d_sub_wireless_dbs_3 73   74   75   76  /userdata/wcdma/d_sub_wireless_dbs_4.dbf',
  '/ifmdata2/userdata/wcdma/d_sub_wireless_dbs_5.dbf',
  '/ifmdata2/userdata/wcdma/d_sub_wireless_dbs_6.dbf',
  '/ifmdata2/userdata/wcdma/d_sub_wireless_dbs_7.dbf',
  '/ifmdata2/userdata/wcdma/d_sub_wireless_dbs_8.dbf',
  '/ifmdata2/userdata/wcdma/d_sub_wireless_dbs_9.dbf',
  '/ifmdata2/userdata/wcdma/d_sub_wireless_dbs_10.dbf',
  '/ifmdata2/userdata/wcdma/d_sub_wireless_dbs_11.dbf',
 77   78   79   80   81   82   83   84   85   86   87   88   89   90   91   92   93   94   95   96   97   98   99  100    '/ifmdata2/userdata/wcdma/d_sub_wireless_dbs_12.dbf',
  '/ifmdata2/userdata/wcdma/d_sub_wireless_dbs_13.dbf',
  '/ifmdata2/userdata/wcdma/d_sub_wireless_dbs_14.dbf',
  '/ifmdata2/userdata/wcdma/d_sub_wireless_dbs_15.dbf',
  '/ifmdata2/userdata/wcdma/d_sub_wireless_dbs_16.dbf',
  '/ifmdata2/userdata/wcdma/d_sub_wireless_dbs_17.dbf',
  '/ifmdata2/userdata/wcdma/d_sub_wireless_dbs_18.dbf',
  '/ifmdata2/userdata/wcdma/d_sub_wireless_dbs_19.dbf',
  '/ifmdata2/userdata/wcdma/d_sub_wireless_dbs_20.dbf',
  '/ifmdata2/userdata/wcdma/d_sub_wireless_dbs_21.dbf',
  '/ifmdata2/userdata/wcdma/d_sub_wireless_dbs_22.dbf',
  '/ifmdata2/userdata/wcdma/d_sub_wireless_dbs_23.dbf',
  '/ifmdata3/userdata/wcdma/i_sub_wireless_dbs_0.dbf',
  '/ifmdata3/userdata/wcdma/i_sub_wireless_dbs_1.dbf',
  '/ifmdata3/userdata/wcdma/i_sub_wireless_dbs_2.dbf',
101  102  103  104  105  106  107  108  109  110  111  112  113  114  115    '/ifmdata3/userdata/wcdma/i_sub_wireless_dbs_3.dbf',
  '/ifmdata3/userdata/wcdma/i_sub_wireless_dbs_4.dbf',
  '/ifmdata3/userdata/wcdma/i_sub_wireless_dbs_5.dbf',
  '/ifmdata3/userdata/wcdma/i_sub_wireless_dbs_6.dbf',
  '/ifmdata3/userdata/wcdma/i_sub_wireless_dbs_7.dbf',
  '/ifmdata3/userdata/wcdma/i_sub_wireless_dbs_8.dbf',
  '/ifmdata3/userdata/wcdma/i_sub_wireless_dbs_9.dbf',
  '/ifmdata3/userdata/wcdma/i_sub_wireless_dbs_10.dbf',
  '/ifmdata3/userdata/wcdma/i_sub_wireless_dbs_11.dbf',
  '/ifmdata3/userdata/wcdma/i_sub_wireless_dbs_12.dbf',
  '/ifmdata3/userdata/wcdma/i_sub_wireless_dbs_13.dbf',
  '/ifmdata3/userdata/wcdma/i_sub_wireless_dbs_14.dbf',
  '/ifmdata3/userdata/wcdma/i_sub_wireless_dbs_15.dbf',
  '/ifmdata3/userdata/wcdma/i_sub_wireless_dbs_16.dbf',
  '/ifmdata3/userdata/wcdma/i_sub_wireless_dbs_17.dbf',
  '/ifmdata3/userdata/wcdma/i_sub_wireless_dbs_18.dbf',
  '/ifmdata3/userdata/wcdma/i_sub_wireless_dbs_19.dbf',
  '/ifmdata3/userdata/wcdma/i_sub_wireless_dbs_20.dbf',
  '/i116  117  cdma/i_sub_wireless_dbs_21.dbf',
  '/ifmdata3/userdata/wcdma/i_sub_wireless_dbs_22.dbf',
  '/ifmdata3/userdata/wcdma/i_sub_wireless_dbs_23.dbf',
  '/ifmdata3/userdata/wcdma/d_kpi_dbs.dbf',
  '/ifmdata3/userdata/wcdma/i_kpi_dbs.dbf',
  '/ifmdata3/userdata/wcdma/dbmonitor.dbf',
  '/ifmdata1/userdata/wcdma/safety01.dbf',
  '/ifmdata4/userdata/d_sys_mon_dbs.dbf',
118  119  120  121  122  123  124  125  126  127  128  129  130  131  132  133  134  135  136  137  138  139  140  141    '/ifmdata4/userdata/i_sys_mon_dbs.dbf'
CHARACTER SET ZHS16GBK;142 
Control file created.
SQL> !            
SXIWDB 21: cd $ORACLE_HOME
SXIWDB 22: ls
OPatch               css                  javavm               mgw                  perl                 sqlnet.log
SXIWDB_SXIWCDMA      ctx                  jdbc                 network              plsql                sqlplus
assistants           dbs                  jdk                  nls                  precomp              srvm
bin                  demo                 jlib                 oc4j                 racg                 sysman
ccr                  diagnostics          jre                  olap                 rdbms                tg4ifmx
cdata                has                  ldap                 opmn                 relnotes             tg4ingr
cfgtoollogs          hs                   lib                  oraInst.loc          root.sh              tg4sybs
clone                hs_err_pid18108.log  lib32                oracore              root.sh.old          tg4tera
config               install              log                  ord                  root.sh.old.1        uix
core                 install.platform     md                   oui                  slax                 wwg
crs                  inventory            mesg                 owm                  sqlj                 xdk
SXIWDB 23: cd dbs
SXIWDB 24: ls
alert_SXIWCDMA.log  hc_SXIWCDMA.dat     initdw.ora          lkSXIWCDMA          orapwSXIWCDMA       spfileSXIWCDMA.ora
hc_SXIALARM.dat     init.ora            lkSXIALARM          orapwSXIALARM       spfileSXIALARM.ora
SXIWDB 25: ls -lrt
total 208
-rw-r-----   1 oracle     oinstall      8385 Sep 11  1998 init.ora
-rw-r--r--   1 oracle     oinstall     12920 May  3  2001 initdw.ora
-rw-r-----   1 oracle     oinstall        24 Sep 28 16:00 lkSXIWCDMA
-rw-r-----   1 oracle     oinstall      3072 Oct 16 14:23 orapwSXIWCDMA
-rw-r--r--   1 oracle     oinstall        24 Oct 21 20:46 lkSXIALARM
-rw-r--r--   1 oracle     oinstall      3072 Oct 21 20:46 orapwSXIALARM
-rw-r--r--   1 oracle     oinstall      5120 Oct 21 20:46 spfileSXIALARM.ora
-rw-r--r--   1 oracle     oinstall      1544 Oct 21 20:47 hc_SXIALARM.dat
-rw-r-----   1 oracle     oinstall       444 Nov 12 09:07 alert_SXIWCDMA.log
-rw-rw----   1 oracle     oinstall      1552 Nov 12 11:29 hc_SXIWCDMA.dat
-rw-r-----   1 oracle     oinstall      5120 Nov 12 11:30 spfileSXIWCDMA.ora
SXIWDB 26: strings spfileSXIWCDMA.ora
SXIWCDMA.__db_cache_size=24024973312
SXIWCDMA.__java_pool_size=100663296
SXIWCDMA.__large_pool_size=16777216
SXIWCDMA.__shared_pool_size=3758096384
SXIWCDMA.__streams_pool_size=0
*._allow_resetlogs_corruption=TRUE
*.audit_file_dest='/opt/app/oracle//admin/SXIWCDMA/adump'
*.background_dump_dest='/opt/app/oracle//admin/SXIWCDMA/bdump'
*.compatible='10.2.0.1.0'
*.control_files='/ifmdata1/sysdata/control01.ctl','/ifmdata2/sysdata/control02.ctl','/ifmdata3/sysdata/control03.ctl'
*.core_dump_dest='/opt/app/oracle//admin/SXIWCDMA/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='SXIWCDMA'
*.db_recovery_file_dest='/archive/flash_recovery_area'
*.db_recovery_file_dest_size=161061273600
*.dispatchers='(PROTOCOL=TCP) (SERVICE=SXIWCDMAXDB)'
*.job_queue_processes=0
*.nls_language='SIMPLIFIED CHINESE'
*.nls_territory='CHINA'
*.open_cursors=300
*.pga_aggregate_target=3007315968
*.processes=800
*.remote_login_passwordfile='EXCLUSIVE'
*.sessions=885
*.sga_target=27917287424
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/opt/app/oracle//admin/SXIWCDMA/udump'
SXIWDB 27: ls -l /ifmdata1/sysdata/control01.ctl
-rw-r-----   1 oracle     oinstall   14663680 Nov 12 11:31 /ifmdata1/sysdata/control01.ctl
SXIWDB 28: ls -l /ifmdata2/sysdata/control02.ctl
-rw-r-----   1 oracle     oinstall   14663680 Nov 12 11:31 /ifmdata2/sysdata/control02.ctl
SXIWDB 29: ls -l /ifmdata3/sysdata/control03.ctl
-rw-r-----   1 oracle     oinstall   14663680 Nov 12 11:31 /ifmdata3/sysdata/control03.ctl
SXIWDB 30: exit
SXIWDB 31:
SQL> startup mount;
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> alter database mount;
5、打开数据库:
SQL> alter database open RESETLOGS;
Database altered.
SQL> select status from v$instance;
STATUS
------------
OPEN
SQL> select checkpoint_change# from v$database;
CHECKPOINT_CHANGE#
------------------
        1064482972
SQL> select checkpoint_change# from v$datafile;
CHECKPOINT_CHANGE#
------------------
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
        1064482972
128 rows selected.
数据库打开,checkpoint也一致了,估计会丢失一些数据,这些数据没有备份,是没有办法挽回的。现场可以检查测试一下,然后迅速导出一些重要的用户吧,以防万一。
阅读(993) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~