[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.
--//理论将这样强行打开数据库问题多多,最佳的方式以它为基础导出重建新库.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/267265/viewspace-2668397/ ，如需转载，请注明出处，否则将追究法律责任。
最新文章
- [20261008]验证Shared Memory Segments key以及Semaphore Arrays Key(11g).txt
- [20261008]gdb引入结构体是否可行.txt
- [20261008]bpftrace定义结构体例子.txt
- [20261007]关于oracle sskgph2函数.txt
- [20261007]oracle Semaphore Arrays Key值的冲突.txt
- [20261004]oracle sskgph2函数等价c以及python脚本.txt
- [20261004]bpftrace查看oracle函数调用堆栈问题.txt
- [20261002]验证sskgphpjw函数参与运算的字符串是否存在规律.txt
- [20261002]oracle Semaphore Arrays Key值的计算2.txt
- [20261001]oracle Semaphore Arrays Key值的计算.txt
