[20191213]不完全恢復疑問.txt
[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部落格 ” ，連結：http://blog.itpub.net/267265/viewspace-2668397/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- Oracle 不完全恢復Oracle
- [20191209]降序索引疑問.txt索引
- [20190411]linux stat 命令疑問.txtLinux
- [20190428]恢復oraInventory.txtAI
- [20191209]降序索引疑問2.txt索引
- [20200303]降序索引疑問5.txt索引
- [20191210]降序索引疑問3.txt索引
- [20191218]降序索引疑問4.txt索引
- [20190401]那個更快的疑問.txt
- RMAN深入解析之--Incarnation應用（不完全恢復）
- Oracle 不完全恢復遇到的ORA-600錯誤Oracle
- 如何進行Oracle資料庫不完全恢復RBOracle資料庫
- [20220909]bbed關於刪除記錄恢復的問題.txt
- [20210926]並行執行計劃疑問.txt並行
- [20220308]查詢x$ksmmem遇到的疑問.txt
- [20190510]rman備份的疑問8.txt
- [20190510]rman備份的疑問7.txt
- [20190509]rman備份的疑問5.txt
- [20190423]那個更快的疑問3.txt
- [20191213]toad 12下BIND_AWARE提示無效.txt
- [20190124]bbed恢復資料遇到延遲塊清除的問題.txt
- [20181031]truncate IDL_UB1$恢復.txt
- [20180627]truncate table的另類恢復.txt
- [20191213]共享池繫結變數的值在哪裡.txt變數
- [20221014]資料檔案2的小疑問.txt
- [20220304]測試library cache mutex遇到的疑問.txtMutex
- ORACLE資料庫基於時間點的不完全恢復Oracle資料庫
- [20230308]versions偽列versions_starttime疑問2.txt
- [20220309]查詢x$ksmmem遇到的疑問補充.txt
- [20201207]關於ORACLE IMU的一些疑問.txtOracle
- [20210803]刪除user$的恢復準備.txt
- [20210930]bbed恢復刪除的資料.txt
- [20201221]KTFB Bitmapped File Space Header的恢復.txtAPPHeader
- [20201222]KTFB Bitmapped File Space Bitmap的恢復.txtAPP
- [20190130]刪除tab$記錄的恢復.txt
- [20181212]truncate的另類恢復5.txt
- G017-ORACLE-MIGRATION-01 RMAN備份異機不完全恢復Oracle
- PG 資料庫的 表的不完全恢復的簡易方法資料庫