а天堂中文最新一区二区三区,国产成年女人特黄特色毛片免

首頁

資料庫

mysql教程

RMAN恢復案例之--不完全恢復錯誤案例

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 07, 2016 pm 04:48 PM

oracle RMAN

RMAN恢復案例之--不完全恢復錯誤案例RMAN恢復案例：不完全恢復，由于在先前的數(shù)據(jù)文件備份有誤，導致恢復失敗。[oracle@rh6~]$rmantarget/RecoveryManager:Relea

RMAN恢復案例之--不完全恢復錯誤案例

RMAN恢復案例：

不完全恢復，由于在先前的數(shù)據(jù)文件備份有誤，導致恢復失敗。

[oracle@rh6?~]$?rman?target?/ Recovery?Manager:?Release?11.2.0.1.0?-?Production?on?Sat?Sep?20?15:54:25?2014 Copyright?(c)?1982,?2009,?Oracle?and/or?its?affiliates.??All?rights?reserved. connected?to?target?database:?TEST1?(DBID=1195893416) RMAN>?run?{ 2>?shutdown?immediate; 3>?startup?mount; 4>?set?until?time?'2014-09-20?15:49:36'; 5>?restore?database; 6>?recover?database?; 7>?alter?database?open?resetlogs; 8>?sql'alter?system?switch?logfile'; 9>?} using?target?database?control?file?instead?of?recovery?catalog database?closed database?dismounted Oracle?instance?shut?down connected?to?target?database?(not?started) Oracle?instance?started database?mounted Total?System?Global?Area?????175767552?bytes Fixed?Size?????????????????????1335276?bytes Variable?Size????????????????142606356?bytes Database?Buffers??????????????29360128?bytes Redo?Buffers???????????????????2465792?bytes executing?command:?SET?until?clause Starting?restore?at?20-SEP-14 allocated?channel:?ORA_DISK_1 channel?ORA_DISK_1:?SID=18?device?type=DISK flashing?back?control?file?to?SCN?9601534 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?00002?to?/u01/app/oracle/oradata/test1/sysaux01.dbf channel?ORA_DISK_1:?restoring?datafile?00004?to?/u01/app/oracle/oradata/test1/users01.dbf channel?ORA_DISK_1:?restoring?datafile?00005?to?/u01/app/oracle/oradata/test1/perfs.dbf channel?ORA_DISK_1:?restoring?datafile?00007?to?/u01/app/oracle/oradata/test1/undotbs2.dbf channel?ORA_DISK_1:?restoring?datafile?00010?to?/u01/app/oracle/oradata/test1/index01.dbf channel?ORA_DISK_1:?reading?from?backup?piece?/dsk1/backup/test1/TEST1_240.bak channel?ORA_DISK_1:?piece?handle=/dsk1/backup/test1/TEST1_240.bak?tag=TAG20140920T152720 channel?ORA_DISK_1:?restored?backup?piece?1 channel?ORA_DISK_1:?restore?complete,?elapsed?time:?00:00:35 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?00013?to?/u01/app/oracle/oradata/test1/tbs_16.dbf channel?ORA_DISK_1:?reading?from?backup?piece?/dsk1/backup/test1/TEST1_241.bak channel?ORA_DISK_1:?piece?handle=/dsk1/backup/test1/TEST1_241.bak?tag=TAG20140920T152720 channel?ORA_DISK_1:?restored?backup?piece?1 channel?ORA_DISK_1:?restore?complete,?elapsed?time:?00:00:01 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?/u01/app/oracle/oradata/test1/system01.dbf channel?ORA_DISK_1:?restoring?datafile?00003?to?/u01/app/oracle/oradata/test1/test1.dbf channel?ORA_DISK_1:?restoring?datafile?00006?to?/u01/app/oracle/oradata/test1/dict1.dbf channel?ORA_DISK_1:?reading?from?backup?piece?/dsk1/backup/test1/TEST1_239.bak channel?ORA_DISK_1:?piece?handle=/dsk1/backup/test1/TEST1_239.bak?tag=TAG20140920T152720 channel?ORA_DISK_1:?restored?backup?piece?1 channel?ORA_DISK_1:?restore?complete,?elapsed?time:?00:00:45 Finished?restore?at?20-SEP-14 Starting?recover?at?20-SEP-14 using?channel?ORA_DISK_1 starting?media?recovery

recover 失敗......

media recovery failed

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of recover command at 09/20/2014 15:59:01

RMAN-20505: create datafile during recovery

RMAN-11003: failure during parse/execution of SQL statement: alter database recover if needed

?start until time 'SEP 20 2014 15:49:36'

ORA-00283: recovery session canceled due to errors

ORA-01244: unnamed datafile(s) added to control file by media recovery

ORA-01110: data file 8: '/u01/app/oracle/oradata/test1/tbs2.dbf'

查看備份信息：

本網(wǎng)站聲明

本文內(nèi)容由網(wǎng)友自願投稿，版權(quán)歸原作者所有。本站不承擔相應的法律責任。如發(fā)現(xiàn)涉嫌抄襲或侵權(quán)的內(nèi)容，請聯(lián)絡admin@php.cn

熱AI工具

Undress AI Tool

免費脫衣圖片

Undresser.AI Undress

人工智慧驅(qū)動的應用程序，用於創(chuàng)建逼真的裸體照片

AI Clothes Remover

用於從照片中去除衣服的線上人工智慧工具。

Clothoff.io

AI脫衣器

Video Face Swap

使用我們完全免費的人工智慧換臉工具，輕鬆在任何影片中換臉！

熱工具

記事本++7.3.1

好用且免費的程式碼編輯器

SublimeText3漢化版

中文版，非常好用

禪工作室 13.0.1

強大的PHP整合開發(fā)環(huán)境

Dreamweaver CS6

視覺化網(wǎng)頁開發(fā)工具

SublimeText3 Mac版

神級程式碼編輯軟體(SublimeText3)

熱門話題

Laravel 教程

1597

PHP教程

1488

Related knowledge

怎樣卸載MySQL並清理殘留文件 Apr 29, 2025 pm 04:03 PM

要安全、徹底地卸載MySQL並清理所有殘留文件，需遵循以下步驟：1.停止MySQL服務；2.卸載MySQL軟件包；3.清理配置文件和數(shù)據(jù)目錄；4.驗證卸載是否徹底。

甲骨文在商業(yè)世界中的作用 Apr 23, 2025 am 12:01 AM

Oracle不僅是數(shù)據(jù)庫公司，還是雲(yún)計算和ERP系統(tǒng)的領(lǐng)導者。 1.Oracle提供從數(shù)據(jù)庫到雲(yún)服務和ERP系統(tǒng)的全面解決方案。 2.OracleCloud挑戰(zhàn)AWS和Azure，提供IaaS、PaaS和SaaS服務。 3.Oracle的ERP系統(tǒng)如E-BusinessSuite和FusionApplications幫助企業(yè)優(yōu)化運營。

MongoDB vs. Oracle：為您的需求選擇正確的數(shù)據(jù)庫 Apr 22, 2025 am 12:10 AM

MongoDB適合非結(jié)構(gòu)化數(shù)據(jù)和高擴展性需求，Oracle適合需要嚴格數(shù)據(jù)一致性的場景。 1.MongoDB靈活存儲不同結(jié)構(gòu)數(shù)據(jù)，適合社交媒體和物聯(lián)網(wǎng)。 2.Oracle結(jié)構(gòu)化數(shù)據(jù)模型確保數(shù)據(jù)完整性，適用於金融交易。 3.MongoDB通過分片橫向擴展，Oracle通過RAC縱向擴展。 4.MongoDB維護成本低，Oracle維護成本高但支持完善。

MySQL與Oracle：許可，功能和福利 May 08, 2025 am 12:05 AM

MySQL和Oracle的主要區(qū)別在於許可證、功能和優(yōu)勢。 1.許可證：MySQL提供GPL許可證，免費使用，Oracle採用專有許可證，價格昂貴。 2.功能：MySQL功能簡單，適合Web應用和中小型企業(yè)，Oracle功能強大，適合大規(guī)模數(shù)據(jù)和復雜業(yè)務。 3.優(yōu)勢：MySQL開源免費，適合初創(chuàng)公司，Oracle性能可靠，適合大型企業(yè)。

MySQL和Oracle：探索性能和可伸縮性 Apr 29, 2025 am 12:12 AM

MySQL和Oracle在性能和可擴展性上的區(qū)別在於：1.MySQL在小型到中型數(shù)據(jù)集上表現(xiàn)更好，適合快速擴展和高效讀寫；2.Oracle在處理大型數(shù)據(jù)集和復雜查詢時更具優(yōu)勢，適合高可用性和復雜業(yè)務邏輯。 MySQL通過主從復制和分片技術(shù)實現(xiàn)擴展，而Oracle通過RAC實現(xiàn)高可用性和擴展性。