rman target /恢復(fù)管理器:?Release?11.2.0.1.0?-?Production?on?星期一?11月?11?10:23:32..."/>
溫馨提示×

溫馨提示×

您好，登錄后才能下訂單哦！

密碼登錄×
登錄注冊×
其他方式登錄
點擊 登錄注冊 即表示同意《億速云用戶服務(wù)條款》

RMAN備份與恢復(fù)后UNDO表空間報錯ORA-01190:O

發(fā)布時間：2020-03-02 14:04:05 來源：網(wǎng)絡(luò) 閱讀：328 作者：敏而所學(xué) 欄目：關(guān)系型數(shù)據(jù)庫

RMAN完全恢復(fù)數(shù)據(jù)（有每天9點定時的rman備份）

1、登錄rman

C:\Users\My>rman target /

恢復(fù)管理器:?Release?11.2.0.1.0?-?Production?on?星期一?11月?11?10:23:32?2019
Copyright?(c)?1982,?2009,?Oracle?and/or?its?affiliates.??All?rights?reserved.
連接到目標數(shù)據(jù)庫:?TEST?(DBID=2300388695)

2、查看rman備份

RMAN> list backup of database;

使用目標數(shù)據(jù)庫控制文件替代恢復(fù)目錄
備份集列表
===================
BS?關(guān)鍵字??類型?LV?大小???????設(shè)備類型?經(jīng)過時間?完成時間
-------?----?--?----------?-----------?------------?----------
164?????Full????25.63M?????DISK????????00:00:11?????09-11月-19
????????BP?關(guān)鍵字:?166???狀態(tài):?AVAILABLE??已壓縮:?NO??標記:?BACKUP_TEST_000005_110919101006
段名:E:\APP\MY\ARCHIVELOG\TEST\BACKUPSET\2019_11_09\O1_MF_NNNDF_BACKUP_TEST_000005_1_GWD80OST_.BKP
??備份集?164?中的數(shù)據(jù)文件列表
??文件?LV?類型?Ckp?SCN????Ckp?時間???名稱
??----?--?----?----------?----------?----
??3???????Full?9645449425802?09-11月-19?E:\APP\MY\ORADATA\TEST\UNDOTBS01.DBF
??4???????Full?9645449425802?09-11月-19?E:\APP\MY\ORADATA\TEST\USERS01.DBF
??6???????Full?9645449425802?09-11月-19?E:\APP\MY\ORADATA\TEST\YMM01.DBF
??8???????Full?9645449425802?09-11月-19?E:\APP\MY\ORADATA\TEST\FDA01.DBF
BS?關(guān)鍵字??類型?LV?大小???????設(shè)備類型?經(jīng)過時間?完成時間
-------?----?--?----------?-----------?------------?----------
165?????Full????1.99G??????DISK????????00:02:57?????09-11月-19
????????BP?關(guān)鍵字:?167???狀態(tài):?AVAILABLE??已壓縮:?NO??標記:?BACKUP_TEST_000005_110919101006
段名:E:\APP\MY\ARCHIVELOG\TEST\BACKUPSET\2019_11_09\O1_MF_NNNDF_BACKUP_TEST_000005_1_GWD80OSW_.BKP
??備份集?165?中的數(shù)據(jù)文件列表
??文件?LV?類型?Ckp?SCN????Ckp?時間???名稱
??----?--?----?----------?----------?----
??1???????Full?9645449425800?09-11月-19?E:\APP\MY\ORADATA\TEST\SYSTEM01.DBF
??2???????Full?9645449425800?09-11月-19?E:\APP\MY\ORADATA\TEST\SYSAUX01.DBF
??5???????Full?9645449425800?09-11月-19?E:\APP\MY\ORADATA\TEST\EXAMPLE01.DBF
??7???????Full?9645449425800?09-11月-19?E:\APP\MY\ORADATA\TEST\P_MANAGE_1.DBF
??9???????Full?9645449425800?09-11月-19?E:\APP\MY\ORADATA\TEST\RMANCATLOG01.DBF
BS?關(guān)鍵字??類型?LV?大小???????設(shè)備類型?經(jīng)過時間?完成時間
-------?----?--?----------?-----------?------------?----------
171?????Full????12.73M?????DISK????????00:00:10?????10-11月-19
????????BP?關(guān)鍵字:?173???狀態(tài):?AVAILABLE??已壓縮:?NO??標記:?BACKUP_TEST_000005_111019101009
段名:E:\APP\MY\ARCHIVELOG\TEST\BACKUPSET\2019_11_10\O1_MF_NNNDF_BACKUP_TEST_000005_1_GWGWDR9C_.BKP
??備份集?171?中的數(shù)據(jù)文件列表
??文件?LV?類型?Ckp?SCN????Ckp?時間???名稱
??----?--?----?----------?----------?----
??3???????Full?9645449674680?10-11月-19?E:\APP\MY\ORADATA\TEST\UNDOTBS01.DBF
??6???????Full?9645449670301?10-11月-19?E:\APP\MY\ORADATA\TEST\YMM01.DBF
??7???????Full?9645449674680?10-11月-19?E:\APP\MY\ORADATA\TEST\P_MANAGE_1.DBF
??8???????Full?9645449674680?10-11月-19?E:\APP\MY\ORADATA\TEST\FDA01.DBF
BS?關(guān)鍵字??類型?LV?大小???????設(shè)備類型?經(jīng)過時間?完成時間
-------?----?--?----------?-----------?------------?----------
172?????Full????2.01G??????DISK????????00:03:00?????10-11月-19
????????BP?關(guān)鍵字:?174???狀態(tài):?AVAILABLE??已壓縮:?NO??標記:?BACKUP_TEST_000005_111019101009
段名:E:\APP\MY\ARCHIVELOG\TEST\BACKUPSET\2019_11_10\O1_MF_NNNDF_BACKUP_TEST_000005_1_GWGWDR7X_.BKP
??備份集?172?中的數(shù)據(jù)文件列表
??文件?LV?類型?Ckp?SCN????Ckp?時間???名稱
??----?--?----?----------?----------?----
??1???????Full?9645449674678?10-11月-19?E:\APP\MY\ORADATA\TEST\SYSTEM01.DBF
??2???????Full?9645449674678?10-11月-19?E:\APP\MY\ORADATA\TEST\SYSAUX01.DBF
??4???????Full?9645449674678?10-11月-19?E:\APP\MY\ORADATA\TEST\USERS01.DBF
??5???????Full?9645449674678?10-11月-19?E:\APP\MY\ORADATA\TEST\EXAMPLE01.DBF
??9???????Full?9645449674678?10-11月-19?E:\APP\MY\ORADATA\TEST\RMANCATLOG01.DBF

3、關(guān)閉數(shù)據(jù)庫

RMAN> shutdown immediate;

數(shù)據(jù)庫已關(guān)閉
數(shù)據(jù)庫已卸裝
Oracle?實例已關(guān)閉

4、開啟數(shù)據(jù)庫至裝載狀態(tài)

RMAN> startup mount;

Oracle?實例已啟動
數(shù)據(jù)庫已裝載
系統(tǒng)全局區(qū)域總計????6731022336?字節(jié)
Fixed?Size?????????????????????2293976?字節(jié)
Variable?Size???????????????2768244520?字節(jié)
Database?Buffers????????????3942645760?字節(jié)
Redo?Buffers??????????????????17838080?字節(jié)

5、執(zhí)行rman的run塊--恢復(fù)備份到2019-11-10 8點鐘

RMAN> run {

2> allocate channel c1 type disk;

3> allocate channel c2 type disk;

4> sql 'alter session set nls_date_format="yyyy-mm-dd hh34:mi:ss"';

5> set until time = '2019-11-10 08:00:00';

6> restore database;

7> recover database;

8> alter database open resetlogs;}

分配的通道:?c1
通道?c1:?SID=129?設(shè)備類型=DISK
分配的通道:?c2
通道?c2:?SID=192?設(shè)備類型=DISK
sql?語句:?alter?session?set?nls_date_format="yyyy-mm-dd?hh34:mi:ss"
正在執(zhí)行命令:?SET?until?clause
啟動?restore?于?11-11月-19
將控制文件閃回到?SCN?9645449492414
通道?c1:?正在開始還原數(shù)據(jù)文件備份集
通道?c1:?正在指定從備份集還原的數(shù)據(jù)文件
通道?c1:?將數(shù)據(jù)文件?00003?還原到?E:\APP\MY\ORADATA\TEST\UNDOTBS01.DBF
通道?c1:?將數(shù)據(jù)文件?00004?還原到?E:\APP\MY\ORADATA\TEST\USERS01.DBF
通道?c1:?將數(shù)據(jù)文件?00006?還原到?E:\APP\MY\ORADATA\TEST\YMM01.DBF
通道?c1:?將數(shù)據(jù)文件?00008?還原到?E:\APP\MY\ORADATA\TEST\FDA01.DBF
通道?c1:?正在讀取備份片段?E:\APP\MY\ARCHIVELOG\TEST\BACKUPSET\2019_11_09\O1_MF_NNNDF_BACKUP_TEST_000005_1_GWD80OST_.BKP
通道?c2:?正在開始還原數(shù)據(jù)文件備份集
通道?c2:?正在指定從備份集還原的數(shù)據(jù)文件
通道?c2:?將數(shù)據(jù)文件?00001?還原到?E:\APP\MY\ORADATA\TEST\SYSTEM01.DBF
通道?c2:?將數(shù)據(jù)文件?00002?還原到?E:\APP\MY\ORADATA\TEST\SYSAUX01.DBF
通道?c2:?將數(shù)據(jù)文件?00005?還原到?E:\APP\MY\ORADATA\TEST\EXAMPLE01.DBF
通道?c2:?將數(shù)據(jù)文件?00007?還原到?E:\APP\MY\ORADATA\TEST\P_MANAGE_1.DBF
通道?c2:?將數(shù)據(jù)文件?00009?還原到?E:\APP\MY\ORADATA\TEST\RMANCATLOG01.DBF
通道?c2:?正在讀取備份片段?E:\APP\MY\ARCHIVELOG\TEST\BACKUPSET\2019_11_09\O1_MF_NNNDF_BACKUP_TEST_000005_1_GWD80OSW_.BKP
通道?c1:?段句柄?=?E:\APP\MY\ARCHIVELOG\TEST\BACKUPSET\2019_11_09\O1_MF_NNNDF_BACKUP_TEST_000005_1_GWD80OST_.BKP?標記?=?BACKUP_TEST_000005_110919101006
通道?c1:?已還原備份片段?1
通道?c1:?還原完成,?用時:?00:01:05
通道?c2:?段句柄?=?E:\APP\MY\ARCHIVELOG\TEST\BACKUPSET\2019_11_09\O1_MF_NNNDF_BACKUP_TEST_000005_1_GWD80OSW_.BKP?標記?=?BACKUP_TEST_000005_110919101006
通道?c2:?已還原備份片段?1
通道?c2:?還原完成,?用時:?00:01:35
完成?restore?于?11-11月-19
啟動?recover?于?11-11月-19
正在開始介質(zhì)的恢復(fù)
線程?1?序列?265?的歸檔日志已作為文件?E:\APP\MY\ARCHIVELOG\TEST\ARCHIVELOG\2019_11_09\O1_MF_1_265_GWD86OCH_.ARC?存在于磁盤上
線程?1?序列?266?的歸檔日志已作為文件?E:\APP\MY\ARCHIVELOG\TEST\ARCHIVELOG\2019_11_09\O1_MF_1_266_GWDOJ4YM_.ARC?存在于磁盤上
線程?1?序列?267?的歸檔日志已作為文件?E:\APP\MY\ARCHIVELOG\TEST\ARCHIVELOG\2019_11_09\O1_MF_1_267_GWF73B77_.ARC?存在于磁盤上
線程?1?序列?268?的歸檔日志已作為文件?E:\APP\MY\ARCHIVELOG\TEST\ARCHIVELOG\2019_11_09\O1_MF_1_268_GWFM7BTX_.ARC?存在于磁盤上
線程?1?序列?269?的歸檔日志已作為文件?E:\APP\MY\ARCHIVELOG\TEST\ARCHIVELOG\2019_11_10\O1_MF_1_269_GWGN79RX_.ARC?存在于磁盤上
線程?1?序列?270?的歸檔日志已作為文件?E:\APP\MY\ARCHIVELOG\TEST\ARCHIVELOG\2019_11_10\O1_MF_1_270_GWGPRNRB_.ARC?存在于磁盤上
歸檔日志文件名=E:\APP\MY\ARCHIVELOG\TEST\ARCHIVELOG\2019_11_09\O1_MF_1_265_GWD86OCH_.ARC?線程=1?序列=265
歸檔日志文件名=E:\APP\MY\ARCHIVELOG\TEST\ARCHIVELOG\2019_11_09\O1_MF_1_266_GWDOJ4YM_.ARC?線程=1?序列=266
歸檔日志文件名=E:\APP\MY\ARCHIVELOG\TEST\ARCHIVELOG\2019_11_09\O1_MF_1_267_GWF73B77_.ARC?線程=1?序列=267
歸檔日志文件名=E:\APP\MY\ARCHIVELOG\TEST\ARCHIVELOG\2019_11_09\O1_MF_1_268_GWFM7BTX_.ARC?線程=1?序列=268
歸檔日志文件名=E:\APP\MY\ARCHIVELOG\TEST\ARCHIVELOG\2019_11_10\O1_MF_1_269_GWGN79RX_.ARC?線程=1?序列=269
歸檔日志文件名=E:\APP\MY\ARCHIVELOG\TEST\ARCHIVELOG\2019_11_10\O1_MF_1_270_GWGPRNRB_.ARC?線程=1?序列=270
介質(zhì)恢復(fù)完成,?用時:?00:00:33
完成?recover?于?11-11月-19
數(shù)據(jù)庫已打開
釋放的通道:?c1
釋放的通道:?c2

6、查看恢復(fù)后表空間狀態(tài)---undo表空間異常

SQL>?select?*?from?v$datafile;
?????FILE#?CREATION_CHANGE#?CREATION_TIME????????TS#?????RFILE#?STATUS??ENABLED????CHECKPOINT_CHANGE#?CHECKPOINT_TIME?UNRECOVERABLE_CHANGE#?UNRECOVERABLE_TIME?LAST_CHANGE#?LAST_TIME???OFFLINE_CHANGE#?ONLINE_CHANGE#?ONLINE_TIME??????BYTES?????BLOCKS?CREATE_BYTES?BLOCK_SIZE?NAME?????????????????????????????????????????????????????????????????????????????PLUGGED_IN?BLOCK1_OFFSET?AUX_NAME?????????????????????????????????????????????????????????????????????????FIRST_NONLOGGED_SCN?FIRST_NONLOGGED_TIME?FOREIGN_DBID?FOREIGN_CREATION_CHANGE#?FOREIGN_CREATION_TIME?PLUGGED_READONLY?PLUGIN_CHANGE#?PLUGIN_RESETLOGS_CHANGE#?PLUGIN_RESETLOGS_TIME
----------?----------------?-------------?----------?----------?-------?----------?------------------?---------------?---------------------?------------------?------------?-----------?---------------?--------------?-----------?----------?----------?------------?----------?--------------------------------------------------------------------------------?----------?-------------?--------------------------------------------------------------------------------?-------------------?--------------------?------------?------------------------?---------------------?----------------?--------------?------------------------?---------------------
?????????1????????????????7?2013/10/9?18:??????????0??????????1?SYSTEM??READ?WRITE??????9645449500956?2019/11/11?10:0?????????????????????0???????????????????????????????????????????????9645449493420??9645449493421?2019/11/11???943718400?????115200????????????0???????8192?E:\APP\MY\ORADATA\TEST\SYSTEM01.DBF???????????????????????????????????????????????????????0??????????8192?NONE???????????????????????????????????????????????????????????????????????????????????????????????0?????????????????????????????????0????????????????????????0???????????????????????NO????????????????????????????0????????????????????????0?
?????????2?????????????1835?2013/10/9?18:??????????1??????????2?ONLINE??READ?WRITE??????9645449500956?2019/11/11?10:0?????????????????????0???????????????????????????????????????????????9645449493420??9645449493421?2019/11/11??1426063360?????174080????????????0???????8192?E:\APP\MY\ORADATA\TEST\SYSAUX01.DBF???????????????????????????????????????????????????????0??????????8192?NONE???????????????????????????????????????????????????????????????????????????????????????????????0?????????????????????????????????0????????????????????????0???????????????????????NO????????????????????????????0????????????????????????0?
?????????3???????????894817?2013/10/9?19:??????????2??????????3?OFFLINE?READ?WRITE??????9645449493420?2019/11/10?8:00?????????????????????0????????????????????964544949342?2019/11/11????9645449493420??9645449493421?2019/11/11??1646264320?????200960????????????0???????8192?E:\APP\MY\ORADATA\TEST\UNDOTBS01.DBF??????????????????????????????????????????????????????0??????????8192?NONE???????????????????????????????????????????????????????????????????????????????????????????????0?????????????????????????????????0????????????????????????0???????????????????????NO????????????????????????????0????????????????????????0?
?????????4????????????15975?2013/10/9?18:??????????4??????????4?ONLINE??READ?WRITE??????9645449500956?2019/11/11?10:0?????????????????????0???????????????????????????????????????????????9645449493420??9645449493421?2019/11/11?????6553600????????800????????????0???????8192?E:\APP\MY\ORADATA\TEST\USERS01.DBF????????????????????????????????????????????????????????0??????????8192?NONE???????????????????????????????????????????????????????????????????????????????????????????????0?????????????????????????????????0????????????????????????0???????????????????????NO????????????????????????????0????????????????????????0?
?????????5???????????924208?2019/3/7?0:39??????????6??????????5?ONLINE??READ?WRITE??????9645449500956?2019/11/11?10:0?????????????????????0?2019/11/2?7:16:36?????????????????????????????9645449493420??9645449493421?2019/11/11???352583680??????43040????104857600???????8192?E:\APP\MY\ORADATA\TEST\EXAMPLE01.DBF??????????????????????????????????????????????????????0??????????8192?NONE???????????????????????????????????????????????????????????????????????????????????????????????0????????????????????????4157061354???????????????????897480?2013/10/9?19:11:49????NO???????????????????????914234???????????????????897124?2019/3/7?0:37:46
?????????6????9617581639380?2019/11/2?23:??????????7??????????6?ONLINE??READ?WRITE??????9645449500956?2019/11/11?10:0?????????????????????0???????????????????????????????????????????????9645449493420??9645449493421?2019/11/11???104857600??????12800????104857600???????8192?E:\APP\MY\ORADATA\TEST\YMM01.DBF??????????????????????????????????????????????????????????0??????????8192?NONE???????????????????????????????????????????????????????????????????????????????????????????????0?????????????????????????????????0????????????????????????0???????????????????????NO????????????????????????????0????????????????????????0?
?????????7??????????1365579?2019/4/24?22:??????????8??????????7?ONLINE??READ?WRITE??????9645449500956?2019/11/11?10:0?????????????????????0???????????????????????????????????????????????9645449493420??9645449493421?2019/11/11????10485760???????1280???2147483648???????8192?E:\APP\MY\ORADATA\TEST\P_MANAGE_1.DBF?????????????????????????????????????????????????????0??????????8192?NONE???????????????????????????????????????????????????????????????????????????????????????????????0?????????????????????????????????0????????????????????????0???????????????????????NO????????????????????????????0????????????????????????0?
?????????8????9565206324637?2019/10/29?19?????????13??????????8?ONLINE??READ?WRITE??????9645449500956?2019/11/11?10:0?????????????????????0???????????????????????????????????????????????9645449493420??9645449493421?2019/11/11????41943040???????5120????104857600???????8192?E:\APP\MY\ORADATA\TEST\FDA01.DBF??????????????????????????????????????????????????????????0??????????8192?NONE???????????????????????????????????????????????????????????????????????????????????????????????0?????????????????????????????????0????????????????????????0???????????????????????NO????????????????????????????0????????????????????????0?
?????????9????9606240743994?2019/11/2?8:4?????????14??????????9?ONLINE??READ?WRITE??????9645449500956?2019/11/11?10:0?????????????????????0???????????????????????????????????????????????9645449493420??9645449493421?2019/11/11????15728640???????1920?????15728640???????8192?E:\APP\MY\ORADATA\TEST\RMANCATLOG01.DBF???????????????????????????????????????????????????0??????????8192?NONE???????????????????????????????????????????????????????????????????????????????????????????????0?????????????????????????????????0????????????????????????0???????????????????????NO????????????????????????????0????????????????????????0?
9?rows?selected

7、手動聯(lián)機undo表空間

SQL>?alter?tablespace?undotbs1?online;
alter?tablespace?undotbs1?online
ORA-01190:?控制文件或數(shù)據(jù)文件?3?來自最后一個?RESETLOGS?之前
ORA-01110:?數(shù)據(jù)文件?3:?'E:\APP\MY\ORADATA\TEST\UNDOTBS01.DBF'

8、關(guān)閉數(shù)據(jù)庫

RMAN> shutdown immediate;

數(shù)據(jù)庫已關(guān)閉
數(shù)據(jù)庫已卸裝
Oracle?實例已關(guān)閉

9、裝載數(shù)據(jù)庫

RMAN> startup mount;

Oracle?實例已啟動
數(shù)據(jù)庫已裝載
系統(tǒng)全局區(qū)域總計????6731022336?字節(jié)
Fixed?Size?????????????????????2293976?字節(jié)
Variable?Size???????????????2768244520?字節(jié)
Database?Buffers????????????3942645760?字節(jié)
Redo?Buffers??????????????????17838080?字節(jié)

10、將undo表空間脫機

SQL>?ALTER?DATABASE?DATAFILE?3?OFFLINE;
Database?altered.

11、rman還原undo表空間

RMAN> restore datafile 3;

啟動?restore?于?11-11月-19
使用目標數(shù)據(jù)庫控制文件替代恢復(fù)目錄
分配的通道:?ORA_DISK_1
通道?ORA_DISK_1:?SID=202?設(shè)備類型=DISK
分配的通道:?ORA_DISK_2
通道?ORA_DISK_2:?SID=9?設(shè)備類型=DISK
通道?ORA_DISK_1:?正在開始還原數(shù)據(jù)文件備份集
通道?ORA_DISK_1:?正在指定從備份集還原的數(shù)據(jù)文件
通道?ORA_DISK_1:?將數(shù)據(jù)文件?00003?還原到?E:\APP\MY\ORADATA\TEST\UNDOTBS01.DBF
通道?ORA_DISK_1:?正在讀取備份片段?E:\APP\MY\ARCHIVELOG\TEST\BACKUPSET\2019_11_09\O1_MF_NNNDF_BACKUP_TEST_000005_1_GWD80OST_.BKP
通道?ORA_DISK_1:?段句柄?=?E:\APP\MY\ARCHIVELOG\TEST\BACKUPSET\2019_11_09\O1_MF_NNNDF_BACKUP_TEST_000005_1_GWD80OST_.BKP?標記?=?BACKUP_TEST_000005_110919101006
通道?ORA_DISK_1:?已還原備份片段?1
通道?ORA_DISK_1:?還原完成,?用時:?00:00:25
完成?restore?于?11-11月-19

12、rman恢復(fù)undo表空間

RMAN> recover datafile 3;

啟動?recover?于?11-11月-19
使用通道?ORA_DISK_1
使用通道?ORA_DISK_2
正在開始介質(zhì)的恢復(fù)
線程?1?序列?265?的歸檔日志已作為文件?E:\APP\MY\ARCHIVELOG\TEST\ARCHIVELOG\2019_11_09\O1_MF_1_265_GWD86OCH_.ARC?存在于磁?盤上
線程?1?序列?266?的歸檔日志已作為文件?E:\APP\MY\ARCHIVELOG\TEST\ARCHIVELOG\2019_11_09\O1_MF_1_266_GWDOJ4YM_.ARC?存在于磁?盤上
線程?1?序列?267?的歸檔日志已作為文件?E:\APP\MY\ARCHIVELOG\TEST\ARCHIVELOG\2019_11_09\O1_MF_1_267_GWF73B77_.ARC?存在于磁?盤上
線程?1?序列?268?的歸檔日志已作為文件?E:\APP\MY\ARCHIVELOG\TEST\ARCHIVELOG\2019_11_09\O1_MF_1_268_GWFM7BTX_.ARC?存在于磁?盤上
線程?1?序列?269?的歸檔日志已作為文件?E:\APP\MY\ARCHIVELOG\TEST\ARCHIVELOG\2019_11_10\O1_MF_1_269_GWGN79RX_.ARC?存在于磁?盤上
線程?1?序列?270?的歸檔日志已作為文件?E:\APP\MY\ARCHIVELOG\TEST\ARCHIVELOG\2019_11_10\O1_MF_1_270_GWGPRNRB_.ARC?存在于磁?盤上
線程?1?序列?1?的歸檔日志已作為文件?E:\APP\MY\ARCHIVELOG\TEST\ARCHIVELOG\2019_11_11\O1_MF_1_1_GWKK3XM0_.ARC?存在于磁盤上
歸檔日志文件名=E:\APP\MY\ARCHIVELOG\TEST\ARCHIVELOG\2019_11_09\O1_MF_1_265_GWD86OCH_.ARC?線程=1?序列=265
歸檔日志文件名=E:\APP\MY\ARCHIVELOG\TEST\ARCHIVELOG\2019_11_09\O1_MF_1_266_GWDOJ4YM_.ARC?線程=1?序列=266
歸檔日志文件名=E:\APP\MY\ARCHIVELOG\TEST\ARCHIVELOG\2019_11_09\O1_MF_1_267_GWF73B77_.ARC?線程=1?序列=267
歸檔日志文件名=E:\APP\MY\ARCHIVELOG\TEST\ARCHIVELOG\2019_11_09\O1_MF_1_268_GWFM7BTX_.ARC?線程=1?序列=268
歸檔日志文件名=E:\APP\MY\ARCHIVELOG\TEST\ARCHIVELOG\2019_11_10\O1_MF_1_269_GWGN79RX_.ARC?線程=1?序列=269
歸檔日志文件名=E:\APP\MY\ARCHIVELOG\TEST\ARCHIVELOG\2019_11_10\O1_MF_1_270_GWGPRNRB_.ARC?線程=1?序列=270
介質(zhì)恢復(fù)完成,?用時:?00:00:05
完成?recover?于?11-11月-19

13、手動聯(lián)機undo表空間

SQL>?ALTER?DATABASE?DATAFILE?3?ONLINE;
Database?altered.

14、開啟數(shù)據(jù)庫并使用數(shù)據(jù)

SQL>?ALTER?DATABASE?OPEN;
Database?altered.
SQL>?select?SEGMENT_NAME?,STATUS?,TABLESPACE_NAME?from?dba_rollback_segs;
SEGMENT_NAME???????????????????STATUS???????????TABLESPACE_NAME
------------------------------?----------------?------------------------------
SYSTEM?????????????????????????ONLINE???????????SYSTEM
_SYSSMU15_4237028966$??????????OFFLINE??????????UNDOTBS1
_SYSSMU14_4188919565$??????????OFFLINE??????????UNDOTBS1
_SYSSMU10_600653064$???????????ONLINE???????????UNDOTBS1
_SYSSMU9_902607226$????????????ONLINE???????????UNDOTBS1
_SYSSMU8_3123962168$???????????ONLINE???????????UNDOTBS1
_SYSSMU7_362778077$????????????ONLINE???????????UNDOTBS1
_SYSSMU6_2560781624$???????????ONLINE???????????UNDOTBS1
_SYSSMU5_2656872754$???????????ONLINE???????????UNDOTBS1
_SYSSMU4_2554663710$???????????ONLINE???????????UNDOTBS1
_SYSSMU3_3036648903$???????????ONLINE???????????UNDOTBS1
_SYSSMU2_237578013$????????????ONLINE???????????UNDOTBS1
_SYSSMU1_1880814008$???????????ONLINE???????????UNDOTBS1
13?rows?selected
SQL>?select?*?from?v$datafile;
?????FILE#?CREATION_CHANGE#?CREATION_TIME????????TS#?????RFILE#?STATUS??ENABLED????CHECKPOINT_CHANGE#?CHECKPOINT_TIME?UNRECOVERABLE_CHANGE#?UNRECOVERABLE_TIME?LAST_CHANGE#?LAST_TIME???OFFLINE_CHANGE#?ONLINE_CHANGE#?ONLINE_TIME??????BYTES?????BLOCKS?CREATE_BYTES?BLOCK_SIZE?NAME?????????????????????????????????????????????????????????????????????????????PLUGGED_IN?BLOCK1_OFFSET?AUX_NAME?????????????????????????????????????????????????????????????????????????FIRST_NONLOGGED_SCN?FIRST_NONLOGGED_TIME?FOREIGN_DBID?FOREIGN_CREATION_CHANGE#?FOREIGN_CREATION_TIME?PLUGGED_READONLY?PLUGIN_CHANGE#?PLUGIN_RESETLOGS_CHANGE#?PLUGIN_RESETLOGS_TIME
----------?----------------?-------------?----------?----------?-------?----------?------------------?---------------?---------------------?------------------?------------?-----------?---------------?--------------?-----------?----------?----------?------------?----------?--------------------------------------------------------------------------------?----------?-------------?--------------------------------------------------------------------------------?-------------------?--------------------?------------?------------------------?---------------------?----------------?--------------?------------------------?---------------------
?????????1????????????????7?2013/10/9?18:??????????0??????????1?SYSTEM??READ?WRITE??????9645449528191?2019/11/11?10:5?????????????????????0???????????????????????????????????????????????9645449493420??9645449493421?2019/11/11???943718400?????115200????????????0???????8192?E:\APP\MY\ORADATA\TEST\SYSTEM01.DBF???????????????????????????????????????????????????????0??????????8192?NONE???????????????????????????????????????????????????????????????????????????????????????????????0?????????????????????????????????0????????????????????????0???????????????????????NO????????????????????????????0????????????????????????0?
?????????2?????????????1835?2013/10/9?18:??????????1??????????2?ONLINE??READ?WRITE??????9645449528191?2019/11/11?10:5?????????????????????0???????????????????????????????????????????????9645449493420??9645449493421?2019/11/11??1426063360?????174080????????????0???????8192?E:\APP\MY\ORADATA\TEST\SYSAUX01.DBF???????????????????????????????????????????????????????0??????????8192?NONE???????????????????????????????????????????????????????????????????????????????????????????????0?????????????????????????????????0????????????????????????0???????????????????????NO????????????????????????????0????????????????????????0?
?????????3???????????894817?2013/10/9?19:??????????2??????????3?ONLINE??READ?WRITE??????9645449528191?2019/11/11?10:5?????????????????????0???????????????????????????????????????????????9645449493420??9645449493421?2019/11/11??1646264320?????200960????????????0???????8192?E:\APP\MY\ORADATA\TEST\UNDOTBS01.DBF??????????????????????????????????????????????????????0??????????8192?NONE???????????????????????????????????????????????????????????????????????????????????????????????0?????????????????????????????????0????????????????????????0???????????????????????NO????????????????????????????0????????????????????????0?
?????????4????????????15975?2013/10/9?18:??????????4??????????4?ONLINE??READ?WRITE??????9645449528191?2019/11/11?10:5?????????????????????0???????????????????????????????????????????????9645449493420??9645449493421?2019/11/11?????6553600????????800????????????0???????8192?E:\APP\MY\ORADATA\TEST\USERS01.DBF????????????????????????????????????????????????????????0??????????8192?NONE???????????????????????????????????????????????????????????????????????????????????????????????0?????????????????????????????????0????????????????????????0???????????????????????NO????????????????????????????0????????????????????????0?
?????????5???????????924208?2019/3/7?0:39??????????6??????????5?ONLINE??READ?WRITE??????9645449528191?2019/11/11?10:5?????????????????????0?2019/11/2?7:16:36?????????????????????????????9645449493420??9645449493421?2019/11/11???352583680??????43040????104857600???????8192?E:\APP\MY\ORADATA\TEST\EXAMPLE01.DBF??????????????????????????????????????????????????????0??????????8192?NONE???????????????????????????????????????????????????????????????????????????????????????????????0????????????????????????4157061354???????????????????897480?2013/10/9?19:11:49????NO???????????????????????914234???????????????????897124?2019/3/7?0:37:46
?????????6????9617581639380?2019/11/2?23:??????????7??????????6?ONLINE??READ?WRITE??????9645449528191?2019/11/11?10:5?????????????????????0???????????????????????????????????????????????9645449493420??9645449493421?2019/11/11???104857600??????12800????104857600???????8192?E:\APP\MY\ORADATA\TEST\YMM01.DBF??????????????????????????????????????????????????????????0??????????8192?NONE???????????????????????????????????????????????????????????????????????????????????????????????0?????????????????????????????????0????????????????????????0???????????????????????NO????????????????????????????0????????????????????????0?
?????????7??????????1365579?2019/4/24?22:??????????8??????????7?ONLINE??READ?WRITE??????9645449528191?2019/11/11?10:5?????????????????????0???????????????????????????????????????????????9645449493420??9645449493421?2019/11/11????10485760???????1280???2147483648???????8192?E:\APP\MY\ORADATA\TEST\P_MANAGE_1.DBF?????????????????????????????????????????????????????0??????????8192?NONE???????????????????????????????????????????????????????????????????????????????????????????????0?????????????????????????????????0????????????????????????0???????????????????????NO????????????????????????????0????????????????????????0?
?????????8????9565206324637?2019/10/29?19?????????13??????????8?ONLINE??READ?WRITE??????9645449528191?2019/11/11?10:5?????????????????????0???????????????????????????????????????????????9645449493420??9645449493421?2019/11/11????41943040???????5120????104857600???????8192?E:\APP\MY\ORADATA\TEST\FDA01.DBF??????????????????????????????????????????????????????????0??????????8192?NONE???????????????????????????????????????????????????????????????????????????????????????????????0?????????????????????????????????0????????????????????????0???????????????????????NO????????????????????????????0????????????????????????0?
?????????9????9606240743994?2019/11/2?8:4?????????14??????????9?ONLINE??READ?WRITE??????9645449528191?2019/11/11?10:5?????????????????????0???????????????????????????????????????????????9645449493420??9645449493421?2019/11/11????15728640???????1920?????15728640???????8192?E:\APP\MY\ORADATA\TEST\RMANCATLOG01.DBF???????????????????????????????????????????????????0??????????8192?NONE???????????????????????????????????????????????????????????????????????????????????????????????0?????????????????????????????????0????????????????????????0???????????????????????NO????????????????????????????0????????????????????????0?
9?rows?selected備份與恢復(fù)UNDO表空間講解


向AI問一下細節(jié)

免責(zé)聲明：本站發(fā)布的內(nèi)容（圖片、視頻和文字）以原創(chuàng)、轉(zhuǎn)載和分享為主，文章觀點不代表本網(wǎng)站立場，如果涉及侵權(quán)請聯(lián)系站長郵箱：is@yisu.com進行舉報，并提供相關(guān)證據(jù)，一經(jīng)查實，將立刻刪除涉嫌侵權(quán)內(nèi)容。

AI
助
手