有新同事不小心将数据文件在数据库打开时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也一致了,估计会丢失一些数据,这些数据没有备份,是没有办法挽回的。现场可以检查测试一下,然后迅速导出一些重要的用户吧,以防万一。