[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. --//理论将这样强行打开数据库问题多多,最佳的方式以它为基础导出重建新库.
[20191213]不完全恢复疑问.txt
来源:这里教程网
时间:2026-03-03 14:43:13
作者:
编辑推荐:
下一篇:
相关推荐
-
雷神推出 MIX PRO II 迷你主机:基于 Ultra 200H,玻璃上盖 + ARGB 灯效
2 月 9 日消息,雷神 (THUNDEROBOT) 现已宣布推出基于英
-
制造商 Musnap 推出彩色墨水屏电纸书 Ocean C:支持手写笔、第三方安卓应用
2 月 10 日消息,制造商 Musnap 现已在海外推出一款 Oce
热文推荐
- 分布式事务 GTS 的价值和原理浅析
分布式事务 GTS 的价值和原理浅析
26-03-03 - 从零开始入门 | Kubernetes 中的服务发现与负载均衡
从零开始入门 | Kubernetes 中的服务发现与负载均衡
26-03-03 - 原来华为手机不亮屏也能看时间,点击这个按钮,30秒即可开启
原来华为手机不亮屏也能看时间,点击这个按钮,30秒即可开启
26-03-03 - 阿里云视频云正式支持AV1编码格式 为视频编码服务降本提效
阿里云视频云正式支持AV1编码格式 为视频编码服务降本提效
26-03-03 - 等保2.0正式实施,阿里云发布全国首个《阿里公共云用户等保2.0合规能力白皮书》
- 阿里云小程序营收3步曲:一年发展3家加盟+2家直营
阿里云小程序营收3步曲:一年发展3家加盟+2家直营
26-03-03 - 小米手机用户要知道的手机技巧,能大大提高使用体验,米粉都知道
小米手机用户要知道的手机技巧,能大大提高使用体验,米粉都知道
26-03-03 - 周末修裤子-生产遭遇ORA-00600 [kokasgi1]的恢复过程
周末修裤子-生产遭遇ORA-00600 [kokasgi1]的恢复过程
26-03-03 - 接入支付宝小程序能力,人人租机实现从 0-100 增长
接入支付宝小程序能力,人人租机实现从 0-100 增长
26-03-03 - BEGIN SYS.KUPW$WORKER.MAIN('SYS_EXPORT_SCHEMA_02', 'SYS'); END;
