[20191213]不完全恢复疑问.txt

来源:这里教程网 时间:2026-03-03 14:43:13 作者:

[20191213]不完全恢复疑问.txt --//链接提到的问题,http://www.itpub.net/thread-2122132-1-1.html --//自己做一个测试: 1.环境: SCOTT@book> @ ver1 PORT_STRING                    VERSION        BANNER ------------------------------ -------------- -------------------------------------------------------------------------------- x86_64/Linux 2.4.xx            11.2.0.4.0     Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production SYS@book> @ currredo Current log sequence No Percent Full bytes used exclude header Left space logfile size low_rba              on_disk_rba ----------------------- ------------ ------------------------- ---------- ------------ -------------------- --------------------                     746        47.28                  24787456   27640832     52428800 746.46473.0          746.48414.0 MEMBER ------------------------------------------------------------ /mnt/ramdisk/book/redo01.log --//当前seq=746; 2.建立备份: --//清除以前的备份. RMAN> backup as compressed backupset full filesperset 1 database format '/u01/backup/book_%U_%T'; Starting backup at 2019-12-13 08:47:34 using channel ORA_DISK_1 using channel ORA_DISK_2 using channel ORA_DISK_3 channel ORA_DISK_1: starting compressed full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set input datafile file number=00002 name=/mnt/ramdisk/book/sysaux01.dbf channel ORA_DISK_1: starting piece 1 at 2019-12-13 08:47:36 channel ORA_DISK_2: starting compressed full datafile backup set channel ORA_DISK_2: specifying datafile(s) in backup set input datafile file number=00003 name=/mnt/ramdisk/book/undotbs01.dbf channel ORA_DISK_2: starting piece 1 at 2019-12-13 08:47:36 channel ORA_DISK_3: starting compressed full datafile backup set channel ORA_DISK_3: specifying datafile(s) in backup set input datafile file number=00001 name=/mnt/ramdisk/book/system01.dbf channel ORA_DISK_3: starting piece 1 at 2019-12-13 08:47:36 channel ORA_DISK_2: finished piece 1 at 2019-12-13 08:47:36 piece handle=/u01/backup/book_flujabp8_1_1_20191213 tag=TAG20191213T084734 comment=NONE channel ORA_DISK_2: backup set complete, elapsed time: 00:00:00 channel ORA_DISK_2: starting compressed full datafile backup set channel ORA_DISK_2: specifying datafile(s) in backup set input datafile file number=00005 name=/mnt/ramdisk/book/example01.dbf channel ORA_DISK_2: starting piece 1 at 2019-12-13 08:47:37 channel ORA_DISK_2: finished piece 1 at 2019-12-13 08:47:44 piece handle=/u01/backup/book_fnujabp9_1_1_20191213 tag=TAG20191213T084734 comment=NONE channel ORA_DISK_2: backup set complete, elapsed time: 00:00:07 channel ORA_DISK_2: starting compressed full datafile backup set channel ORA_DISK_2: specifying datafile(s) in backup set input datafile file number=00004 name=/mnt/ramdisk/book/users01.dbf channel ORA_DISK_2: starting piece 1 at 2019-12-13 08:47:44 channel ORA_DISK_2: finished piece 1 at 2019-12-13 08:47:47 piece handle=/u01/backup/book_foujabpg_1_1_20191213 tag=TAG20191213T084734 comment=NONE channel ORA_DISK_2: backup set complete, elapsed time: 00:00:03 channel ORA_DISK_2: starting compressed full datafile backup set channel ORA_DISK_2: specifying datafile(s) in backup set input datafile file number=00006 name=/mnt/ramdisk/book/tea01.dbf channel ORA_DISK_2: starting piece 1 at 2019-12-13 08:47:47 channel ORA_DISK_2: finished piece 1 at 2019-12-13 08:47:48 piece handle=/u01/backup/book_fpujabpj_1_1_20191213 tag=TAG20191213T084734 comment=NONE channel ORA_DISK_2: backup set complete, elapsed time: 00:00:01 channel ORA_DISK_1: finished piece 1 at 2019-12-13 08:47:54 piece handle=/u01/backup/book_fkujabp8_1_1_20191213 tag=TAG20191213T084734 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:18 channel ORA_DISK_3: finished piece 1 at 2019-12-13 08:48:02 piece handle=/u01/backup/book_fmujabp8_1_1_20191213 tag=TAG20191213T084734 comment=NONE channel ORA_DISK_3: backup set complete, elapsed time: 00:00:26 Finished backup at 2019-12-13 08:48:02 Starting Control File and SPFILE Autobackup at 2019-12-13 08:48:03 piece handle=/u01/app/oracle/fast_recovery_area/BOOK/autobackup/2019_12_13/o1_mf_s_1026895683_gz5qy4pm_.bkp comment=NONE Finished Control File and SPFILE Autobackup at 2019-12-13 08:48:06 SYS@book> @ currredo Current log sequence No Percent Full bytes used exclude header Left space logfile size low_rba              on_disk_rba ----------------------- ------------ ------------------------- ---------- ------------ -------------------- --------------------                     746        47.41                  24855040   27573248     52428800 4294967295.429496729 746.48546.0                                                                                        5.65535 MEMBER ------------------------------------------------------------ /mnt/ramdisk/book/redo01.log --//当前seq=746; 3.测试1: --//until sequence 746;实际上最后到seq=745,而备份是从746开始.这个备份不可能用于这样的恢复. run{ set until sequence 746; restore database preview; } executing command: SET until clause Starting restore at 2019-12-13 08:50:46 using channel ORA_DISK_1 using channel ORA_DISK_2 using channel ORA_DISK_3 datafile 6 will be created automatically during restore operation RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of restore command at 12/13/2019 08:50:49 RMAN-06026: some targets not found - aborting restore RMAN-06023: no backup or copy of datafile 5 found to restore RMAN-06023: no backup or copy of datafile 4 found to restore RMAN-06023: no backup or copy of datafile 3 found to restore RMAN-06023: no backup or copy of datafile 2 found to restore RMAN-06023: no backup or copy of datafile 1 found to restore 4.测试不完全恢复: SYS@book> shutdown immediate ; Database closed. Database dismounted. ORACLE instance shut down. --//先做一个冷备份,便于反复测试: $ cp -a /mnt/ramdisk/book /u01/backup/20191213 $ rm -f /mnt/ramdisk/book/*               */ RMAN> startup nomount Oracle instance started Total System Global Area     643084288 bytes Fixed Size                     2255872 bytes Variable Size                205521920 bytes Database Buffers             427819008 bytes Redo Buffers                   7487488 bytes RMAN> restore controlfile from autobackup ; Starting restore at 2019-12-13 08:56:43 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=323 device type=DISK recovery area destination: /u01/app/oracle/fast_recovery_area database name (or database unique name) used for search: BOOK channel ORA_DISK_1: AUTOBACKUP /u01/app/oracle/fast_recovery_area/BOOK/autobackup/2019_12_13/o1_mf_s_1026895683_gz5qy4pm_.bkp found in the recovery area AUTOBACKUP search with format "%F" not attempted because DBID was not set channel ORA_DISK_1: restoring control file from AUTOBACKUP /u01/app/oracle/fast_recovery_area/BOOK/autobackup/2019_12_13/o1_mf_s_1026895683_gz5qy4pm_.bkp channel ORA_DISK_1: control file restore from AUTOBACKUP complete output file name=/mnt/ramdisk/book/control01.ctl output file name=/mnt/ramdisk/book/control02.ctl Finished restore at 2019-12-13 08:56:46 RMAN> alter database mount; database mounted released channel: ORA_DISK_1 RMAN> restore database ; Starting restore at 2019-12-13 08:59:05 Starting implicit crosscheck backup at 2019-12-13 08:59:05 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=323 device type=DISK allocated channel: ORA_DISK_2 channel ORA_DISK_2: SID=15 device type=DISK allocated channel: ORA_DISK_3 channel ORA_DISK_3: SID=30 device type=DISK Crosschecked 6 objects Finished implicit crosscheck backup at 2019-12-13 09:00:24 Starting implicit crosscheck copy at 2019-12-13 09:00:24 using channel ORA_DISK_1 using channel ORA_DISK_2 using channel ORA_DISK_3 Crosschecked 7 objects Finished implicit crosscheck copy at 2019-12-13 09:00:25 searching for all files in the recovery area ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~=> seq=746还在redo没有切换到归档. cataloging files... cataloging done List of Cataloged Files ======================= File Name: /u01/app/oracle/fast_recovery_area/BOOK/autobackup/2019_12_13/o1_mf_s_1026895683_gz5qy4pm_.bkp using channel ORA_DISK_1 using channel ORA_DISK_2 using channel ORA_DISK_3 channel ORA_DISK_1: starting datafile backup set restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set channel ORA_DISK_1: restoring datafile 00003 to /mnt/ramdisk/book/undotbs01.dbf channel ORA_DISK_1: reading from backup piece /u01/backup/book_flujabp8_1_1_20191213 channel ORA_DISK_2: starting datafile backup set restore channel ORA_DISK_2: specifying datafile(s) to restore from backup set channel ORA_DISK_2: restoring datafile 00005 to /mnt/ramdisk/book/example01.dbf channel ORA_DISK_2: reading from backup piece /u01/backup/book_fnujabp9_1_1_20191213 channel ORA_DISK_3: starting datafile backup set restore channel ORA_DISK_3: specifying datafile(s) to restore from backup set channel ORA_DISK_3: restoring datafile 00004 to /mnt/ramdisk/book/users01.dbf channel ORA_DISK_3: reading from backup piece /u01/backup/book_foujabpg_1_1_20191213 channel ORA_DISK_1: piece handle=/u01/backup/book_flujabp8_1_1_20191213 tag=TAG20191213T084734 channel ORA_DISK_1: restored backup piece 1 channel ORA_DISK_1: restore complete, elapsed time: 00:00:02 channel ORA_DISK_1: starting datafile backup set restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set channel ORA_DISK_1: restoring datafile 00006 to /mnt/ramdisk/book/tea01.dbf channel ORA_DISK_1: reading from backup piece /u01/backup/book_fpujabpj_1_1_20191213 channel ORA_DISK_3: piece handle=/u01/backup/book_foujabpg_1_1_20191213 tag=TAG20191213T084734 channel ORA_DISK_3: restored backup piece 1 channel ORA_DISK_3: restore complete, elapsed time: 00:00:02 channel ORA_DISK_3: starting datafile backup set restore channel ORA_DISK_3: specifying datafile(s) to restore from backup set channel ORA_DISK_3: restoring datafile 00002 to /mnt/ramdisk/book/sysaux01.dbf channel ORA_DISK_3: reading from backup piece /u01/backup/book_fkujabp8_1_1_20191213 channel ORA_DISK_1: piece handle=/u01/backup/book_fpujabpj_1_1_20191213 tag=TAG20191213T084734 channel ORA_DISK_1: restored backup piece 1 channel ORA_DISK_1: restore complete, elapsed time: 00:00:00 channel ORA_DISK_1: starting datafile backup set restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set channel ORA_DISK_1: restoring datafile 00001 to /mnt/ramdisk/book/system01.dbf channel ORA_DISK_1: reading from backup piece /u01/backup/book_fmujabp8_1_1_20191213 channel ORA_DISK_2: piece handle=/u01/backup/book_fnujabp9_1_1_20191213 tag=TAG20191213T084734 channel ORA_DISK_2: restored backup piece 1 channel ORA_DISK_2: restore complete, elapsed time: 00:00:05 channel ORA_DISK_1: piece handle=/u01/backup/book_fmujabp8_1_1_20191213 tag=TAG20191213T084734 channel ORA_DISK_1: restored backup piece 1 channel ORA_DISK_1: restore complete, elapsed time: 00:00:25 channel ORA_DISK_3: piece handle=/u01/backup/book_fkujabp8_1_1_20191213 tag=TAG20191213T084734 channel ORA_DISK_3: restored backup piece 1 channel ORA_DISK_3: restore complete, elapsed time: 00:00:25 Finished restore at 2019-12-13 09:00:57 RMAN> recover database ; Starting recover at 2019-12-13 09:02:09 using channel ORA_DISK_1 using channel ORA_DISK_2 using channel ORA_DISK_3 starting media recovery unable to find archived log archived log thread=1 sequence=746 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of recover command at 12/13/2019 09:02:15 RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 746 and starting SCN of 13277626332 --//恢复无法进行下去,只能以这个restore的数据文件强行打开. SYS@book> SELECT file#, CHECKPOINT_CHANGE#, CHECKPOINT_TIME,CREATION_CHANGE#  , RESETLOGS_CHANGE#,status, CHECKPOINT_COUNT,fuzzy,name,tablespace_name  FROM v$datafile_header; FILE# CHECKPOINT_CHANGE# CHECKPOINT_TIME     CREATION_CHANGE# RESETLOGS_CHANGE# STATUS  CHECKPOINT_COUNT FUZ NAME                             TABLESPACE_NAME ----- ------------------ ------------------- ---------------- ----------------- ------- ---------------- --- -------------------------------- ---------------     1        13277626335 2019-12-13 08:47:36                7            925702 ONLINE               964 NO  /mnt/ramdisk/book/system01.dbf   SYSTEM     2        13277626332 2019-12-13 08:47:36             1834            925702 ONLINE               952 NO  /mnt/ramdisk/book/sysaux01.dbf   SYSAUX     3        13277626333 2019-12-13 08:47:36           923328            925702 ONLINE               873 NO  /mnt/ramdisk/book/undotbs01.dbf  UNDOTBS1     4        13277626342 2019-12-13 08:47:44            16143            925702 ONLINE               958 NO  /mnt/ramdisk/book/users01.dbf    USERS     5        13277626336 2019-12-13 08:47:37           952916            925702 ONLINE               869 NO  /mnt/ramdisk/book/example01.dbf  EXAMPLE     6        13277626345 2019-12-13 08:47:47      13276257767            925702 ONLINE               351 NO  /mnt/ramdisk/book/tea01.dbf      TEA 6 rows selected. SYS@book> SELECT max( CHECKPOINT_CHANGE#) from v$datafile_header; MAX(CHECKPOINT_CHANGE#) -----------------------             13277626345 --//最大scn是13277626345,只能向这个scn靠拢. SYS@book> 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: '/mnt/ramdisk/book/system01.dbf' --//不存在归档以及在线日志,无法打开.加入参数 *._allow_resetlogs_corruption=true SYS@book> alter database open resetlogs; Database altered. --//运气很好,我这里测试环境没有任何业务. SYS@book> SELECT file#, CHECKPOINT_CHANGE#, CHECKPOINT_TIME,CREATION_CHANGE#  , RESETLOGS_CHANGE#,status, CHECKPOINT_COUNT,fuzzy,name,tablespace_name  FROM v$datafile_header; FILE# CHECKPOINT_CHANGE# CHECKPOINT_TIME     CREATION_CHANGE# RESETLOGS_CHANGE# STATUS  CHECKPOINT_COUNT FUZ NAME                            TABLESPACE_NAME ----- ------------------ ------------------- ---------------- ----------------- ------- ---------------- --- ------------------------------- ---------------     1        13277626336 2019-12-13 09:10:44                7       13277626333 ONLINE               966 YES /mnt/ramdisk/book/system01.dbf  SYSTEM     2        13277626336 2019-12-13 09:10:44             1834       13277626333 ONLINE               954 YES /mnt/ramdisk/book/sysaux01.dbf  SYSAUX     3        13277626336 2019-12-13 09:10:44           923328       13277626333 ONLINE               875 YES /mnt/ramdisk/book/undotbs01.dbf UNDOTBS1     4        13277626336 2019-12-13 09:10:44            16143       13277626333 ONLINE               960 YES /mnt/ramdisk/book/users01.dbf   USERS     5        13277626336 2019-12-13 09:10:44           952916       13277626333 ONLINE               871 YES /mnt/ramdisk/book/example01.dbf EXAMPLE     6        13277626336 2019-12-13 09:10:44      13276257767       13277626333 ONLINE               353 YES /mnt/ramdisk/book/tea01.dbf     TEA 6 rows selected. SYS@book> startup open read only ; ORACLE instance started. Total System Global Area    643084288 bytes Fixed Size                    2255872 bytes Variable Size               205521920 bytes Database Buffers            427819008 bytes Redo Buffers                  7487488 bytes Database mounted. Database opened. $ exp system/oracle full=y BUFFER=20971520 --//基本没有问题. 5.使用bbed看看: --//重复前面的步骤.注意清除归档目录里面问题. RMAN> restore controlfile from '/u01/app/oracle/fast_recovery_area/BOOK/autobackup/2019_12_13/o1_mf_s_1026895683_gz5qy4pm_.bkp'; RMAN> alter database mount; RMAN> restore database ; SYS@book> SELECT file#, CHECKPOINT_CHANGE#, CHECKPOINT_TIME,CREATION_CHANGE#  , RESETLOGS_CHANGE#,status, CHECKPOINT_COUNT,fuzzy,name,tablespace_name  FROM v$datafile_header; FILE# CHECKPOINT_CHANGE# CHECKPOINT_TIME     CREATION_CHANGE# RESETLOGS_CHANGE# STATUS         CHECKPOINT_COUNT FUZZY  NAME                            TABLESPACE_NAME ----- ------------------ ------------------- ---------------- ----------------- -------------- ---------------- ------ ------------------------------- ------------------------------     1        13277626335 2019-12-13 08:47:36                7            925702 ONLINE                      964 NO     /mnt/ramdisk/book/system01.dbf  SYSTEM     2        13277626332 2019-12-13 08:47:36             1834            925702 ONLINE                      952 NO     /mnt/ramdisk/book/sysaux01.dbf  SYSAUX     3        13277626333 2019-12-13 08:47:36           923328            925702 ONLINE                      873 NO     /mnt/ramdisk/book/undotbs01.dbf UNDOTBS1     4        13277626342 2019-12-13 08:47:44            16143            925702 ONLINE                      958 NO     /mnt/ramdisk/book/users01.dbf   USERS     5        13277626336 2019-12-13 08:47:37           952916            925702 ONLINE                      869 NO     /mnt/ramdisk/book/example01.dbf EXAMPLE     6        13277626345 2019-12-13 08:47:47      13276257767            925702 ONLINE                      351 NO     /mnt/ramdisk/book/tea01.dbf     TEA 6 rows selected. --//使用bbed设置scn=13277626345看看. --//13277626335 = scn_wrap,scn_base(10): 3,392724447 = scn_wrap,scn_base(16): 0x3,0x17687fdf --//13277626332 = scn_wrap,scn_base(10): 3,392724444 = scn_wrap,scn_base(16): 0x3,0x17687fdc --//13277626345 = scn_wrap,scn_base(10): 3,392724457 = scn_wrap,scn_base(16): 0x3,0x17687fe9 $ seq 6 | xargs -IQ echo p /d dba Q,1  kcvfh.kcvfhckp.kcvcpscn.kscnbas| rlbbed| grep kscnbas BBED> ub4 kscnbas                                 @484      392724447 BBED> ub4 kscnbas                                 @484      392724444 BBED> ub4 kscnbas                                 @484      392724445 BBED> ub4 kscnbas                                 @484      392724454 BBED> ub4 kscnbas                                 @484      392724448 BBED> ub4 kscnbas                                 @484      392724457 --//也就是修改kcvfh.kcvfhckp.kcvcpscn.kscnbas=392724457 $  seq 6 | xargs -IQ echo assign  dba Q,1  kcvfh.kcvfhckp.kcvcpscn.kscnbas=392724457 | sed '1aY' | rlbbed --//注:中间使用Y,因为第一次提示Warning: contents of previous BIFILE will be lost. Proceed? (Y/N).要输入Y. $ seq 6 | xargs -IQ echo p /d dba Q,1  kcvfh.kcvfhckp.kcvcpscn.kscnbas| rlbbed| grep kscnbas BBED> ub4 kscnbas                                 @484      392724457 BBED> ub4 kscnbas                                 @484      392724457 BBED> ub4 kscnbas                                 @484      392724457 BBED> ub4 kscnbas                                 @484      392724457 BBED> ub4 kscnbas                                 @484      392724457 BBED> ub4 kscnbas                                 @484      392724457 $ seq 6 | xargs -IQ echo sum apply dba Q,1  |  sed '1aY' | rlbbed $ seq 6 | xargs -IQ echo verify dba Q,1  |   rlbbed --//OK完成修改: SYS@book> SELECT file#, CHECKPOINT_CHANGE#, CHECKPOINT_TIME,CREATION_CHANGE#  , RESETLOGS_CHANGE#,status, CHECKPOINT_COUNT,fuzzy,name,tablespace_name  FROM v$datafile_header; FILE# CHECKPOINT_CHANGE# CHECKPOINT_TIME     CREATION_CHANGE# RESETLOGS_CHANGE# STATUS CHECKPOINT_COUNT FUZZY  NAME                            TABLESPACE_NAME ----- ------------------ ------------------- ---------------- ----------------- ------ ---------------- ------ ------------------------------- ---------------     1        13277626345 2019-12-13 08:47:36                7            925702 ONLINE              964 NO     /mnt/ramdisk/book/system01.dbf  SYSTEM     2        13277626345 2019-12-13 08:47:36             1834            925702 ONLINE              952 NO     /mnt/ramdisk/book/sysaux01.dbf  SYSAUX     3        13277626345 2019-12-13 08:47:36           923328            925702 ONLINE              873 NO     /mnt/ramdisk/book/undotbs01.dbf UNDOTBS1     4        13277626345 2019-12-13 08:47:44            16143            925702 ONLINE              958 NO     /mnt/ramdisk/book/users01.dbf   USERS     5        13277626345 2019-12-13 08:47:37           952916            925702 ONLINE              869 NO     /mnt/ramdisk/book/example01.dbf EXAMPLE     6        13277626345 2019-12-13 08:47:47      13276257767            925702 ONLINE              351 NO     /mnt/ramdisk/book/tea01.dbf     TEA 6 rows selected. SYS@book> 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: '/mnt/ramdisk/book/system01.dbf' SYS@book> recover database using backup controlfile until cancel; ORA-00279: change 13277626345 generated at 12/13/2019 08:47:47 needed for thread 1 ORA-00289: suggestion : /u01/app/oracle/archivelog/book/1_746_896605872.dbf ORA-00280: change 13277626345 for thread 1 is in sequence #746 Specify log: {<RET>=suggested | filename | AUTO | CANCEL} cancel Media recovery cancelled. SYS@book> alter database open resetlogs; Database altered. SYS@book> SELECT file#, CHECKPOINT_CHANGE#, CHECKPOINT_TIME,CREATION_CHANGE#  , RESETLOGS_CHANGE#,status, CHECKPOINT_COUNT,fuzzy,name,tablespace_name  FROM v$datafile_header; FILE# CHECKPOINT_CHANGE# CHECKPOINT_TIME     CREATION_CHANGE# RESETLOGS_CHANGE# STATUS  CHECKPOINT_COUNT FUZ NAME                            TABLESPACE_NAME ----- ------------------ ------------------- ---------------- ----------------- ------- ---------------- --- ------------------------------- ---------------     1        13277626349 2019-12-13 09:45:04                7       13277626346 ONLINE               966 YES /mnt/ramdisk/book/system01.dbf  SYSTEM     2        13277626349 2019-12-13 09:45:04             1834       13277626346 ONLINE               954 YES /mnt/ramdisk/book/sysaux01.dbf  SYSAUX     3        13277626349 2019-12-13 09:45:04           923328       13277626346 ONLINE               875 YES /mnt/ramdisk/book/undotbs01.dbf UNDOTBS1     4        13277626349 2019-12-13 09:45:04            16143       13277626346 ONLINE               960 YES /mnt/ramdisk/book/users01.dbf   USERS     5        13277626349 2019-12-13 09:45:04           952916       13277626346 ONLINE               871 YES /mnt/ramdisk/book/example01.dbf EXAMPLE     6        13277626349 2019-12-13 09:45:04      13276257767       13277626346 ONLINE               353 YES /mnt/ramdisk/book/tea01.dbf     TEA 6 rows selected. --//理论将这样强行打开数据库问题多多,最佳的方式以它为基础导出重建新库.

相关推荐

热文推荐