首頁 資料庫 mysql教程 Oracle 10g RAC 备份 RMAN

Oracle 10g RAC 备份 RMAN

Jun 07, 2016 pm 05:20 PM
數據

[Oracle@node1 dbs]$ rman target / Recovery Manager: Release 10.2.0.1.0- Production on Thu Sep 27 16:37:55 2012 Copyrig

[Oracle@node1 dbs]$ rman target / 

Recovery Manager: Release 10.2.0.1.0- Production on Thu Sep 27 16:37:55 2012 

Copyright (c) 1982, 2005, Oracle.  All rights reserved. 

connected to target database: MYRAC(DBID=4177338842) 

RMAN> list backup; 

using target database control file insteadof recovery catalog

 

RMAN> show all;

 

RMAN configuration parameters are:

CONFIGURE RETENTION POLICY TO REDUNDANCY 1;# default

CONFIGURE BACKUP OPTIMIZATION OFF; #default

CONFIGURE DEFAULT DEVICE TYPE TO DISK; #default

CONFIGURE CONTROLFILE AUTOBACKUP OFF; #default

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FORDEVICE TYPE DISK TO '%F'; # default

CONFIGURE DEVICE TYPE DISK PARALLELISM 1BACKUP TYPE TO BACKUPSET; # default

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICETYPE DISK TO 1; # default

CONFIGURE ARCHIVELOG BACKUP COPIES FORDEVICE TYPE DISK TO 1; # default

CONFIGURE MAXSETSIZE TO UNLIMITED; #default

CONFIGURE ENCRYPTION FOR DATABASE OFF; #default

CONFIGURE ENCRYPTION ALGORITHM 'AES128'; #default

CONFIGURE ARCHIVELOG DELETION POLICY TONONE; # default

CONFIGURE SNAPSHOT CONTROLFILE NAME TO'/opt/oracle/database/product/10.2.0/db_1/dbs/snapcf_MYRAC1.f';# default

 

RMAN> backup database plus archivelog;

 

 

Starting backup at 27-SEP-12

current log archived

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=133 instance=MYRAC1devtype=DISK

channel ORA_DISK_1: starting archive logbackupset

channel ORA_DISK_1: specifying archivelog(s) in backup set

input archive log thread=1 sequence=88recid=1 stamp=795093263

input archive log thread=1 sequence=89recid=2 stamp=795108837

input archive log thread=1 sequence=90recid=4 stamp=795112903

input archive log thread=2 sequence=47recid=3 stamp=795108939

input archive log thread=2 sequence=48recid=5 stamp=795112824

channel ORA_DISK_1: starting piece 1 at27-SEP-12

channel ORA_DISK_1: finished piece 1 at27-SEP-12

piece handle=/opt/oracle/database/product/10.2.0/db_1/dbs/01nm8tei_1_1tag=TAG20120927T164152 comment=NONE

channel ORA_DISK_1: backup set complete,elapsed time: 00:00:07

Finished backup at 27-SEP-12

 

Starting backup at 27-SEP-12

using channel ORA_DISK_1

channel ORA_DISK_1: starting full datafilebackupset

channel ORA_DISK_1: specifying datafile(s)in backupset

input datafile fno=00001name=+DATA/myrac/datafile/system.259.772910401

input datafile fno=00003name=+DATA/myrac/datafile/sysaux.261.772910481

input datafile fno=00002name=+DATA/myrac/datafile/undotbs1.260.772910465

input datafile fno=00004 name=+DATA/myrac/datafile/undotbs2.263.772910521

input datafile fno=00005name=+DATA/myrac/datafile/users.264.772910533

channel ORA_DISK_1: starting piece 1 at27-SEP-12

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

RMAN-00569: =============== ERROR MESSAGESTACK FOLLOWS ===============

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

RMAN-03002: failure of backup plusarchivelog command at 09/27/2012 16:42:58

ORA-19502: write error on file"/opt/oracle/database/product/10.2.0/db_1/dbs/02nm8ter_1_1",blockno 63361 (blocksize=8192)

ORA-27072: File I/O error

Linux Error: 2: No such file or directory

Additional information: 4

Additional information: 63361

Additional information: 102400

 

重新配置路径

RMAN> configure device type disk backuptype to compressed backupset;

 

new RMAN configuration parameters:

CONFIGURE DEVICE TYPE DISK BACKUP TYPE TOCOMPRESSED BACKUPSET PARALLELISM 1;

new RMAN configuration parameters aresuccessfully stored

released channel: ORA_DISK_1

RMAN> configure channel 1 device typedisk format '+backup/bak_%U';

 

new RMAN configuration parameters:

CONFIGURE CHANNEL 1 DEVICE TYPE DISKFORMAT   '+backup/bak_%U';

new RMAN configuration parameters aresuccessfully stored

RMAN> CONFIGURE CONTROLFILE AUTOBACKUPFORMAT FOR DEVICE TYPE DISK TO '+backup/autobackup_control_%F';

 

old RMAN configuration parameters:

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FORDEVICE TYPE DISK TO '+DATA/MYRAC/controlfile/autobackup_control_%F';

new RMAN configuration parameters:

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FORDEVICE TYPE DISK TO '+backup/autobackup_control_%F';

new RMAN configuration parameters aresuccessfully stored

 

RMAN> CONFIGURE SNAPSHOT CONTROLFILENAME TO '+backup/snapcf_myrac1.f';

 

snapshot control file name set to:+backup/snapcf_myrac1.f

new RMAN configuration parameters aresuccessfully stored

RMAN> show all;

 

RMAN configuration parameters are:

CONFIGURE RETENTION POLICY TO REDUNDANCY 1;# default

CONFIGURE BACKUP OPTIMIZATION OFF; #default

CONFIGURE DEFAULT DEVICE TYPE TO DISK; #default

CONFIGURE CONTROLFILE AUTOBACKUP ON;

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FORDEVICE TYPE DISK TO '+backup/autobackup_control_%F';

CONFIGURE DEVICE TYPE DISK BACKUP TYPE TOCOMPRESSED BACKUPSET PARALLELISM 1;

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICETYPE DISK TO 1; # default

CONFIGURE ARCHIVELOG BACKUP COPIES FORDEVICE TYPE DISK TO 1; # default

CONFIGURE CHANNEL 1 DEVICE TYPE DISKFORMAT   '+backup/bak_%U';

CONFIGURE MAXSETSIZE TO UNLIMITED; #default

CONFIGURE ENCRYPTION FOR DATABASE OFF; #default

CONFIGURE ENCRYPTION ALGORITHM 'AES128'; #default

CONFIGURE ARCHIVELOG DELETION POLICY TONONE; # default

CONFIGURE SNAPSHOT CONTROLFILE NAME TO'+BACKUP/snapcf_myrac1.f';

 

RMAN> backup database plus archivelog;

 

 

Starting backup at 27-SEP-12

current log archived

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=133 instance=MYRAC1devtype=DISK

channel ORA_DISK_1: starting compressedarchive log backupset

channel ORA_DISK_1: specifying archivelog(s) in backup set

input archive log thread=1 sequence=88recid=1 stamp=795093263

input archive log thread=1 sequence=89recid=2 stamp=795108837

input archive log thread=1 sequence=90recid=4 stamp=795112903

input archive log thread=1 sequence=91recid=7 stamp=795115175

input archive log thread=2 sequence=47 recid=3stamp=795108939

input archive log thread=2 sequence=48recid=5 stamp=795112824

input archive log thread=2 sequence=49recid=6 stamp=795115090

channel ORA_DISK_1: starting piece 1 at27-SEP-12

channel ORA_DISK_1: finished piece 1 at27-SEP-12

piece handle=+BACKUP/bak_03nm8vl8_1_1tag=TAG20120927T171935 comment=NONE

channel ORA_DISK_1: backup set complete,elapsed time: 00:00:11

Finished backup at 27-SEP-12

 

Starting backup at 27-SEP-12

using channel ORA_DISK_1

channel ORA_DISK_1: starting compressedfull datafile backupset

channel ORA_DISK_1: specifying datafile(s)in backupset

input datafile fno=00001name=+DATA/myrac/datafile/system.259.772910401

input datafile fno=00003name=+DATA/myrac/datafile/sysaux.261.772910481

input datafile fno=00002name=+DATA/myrac/datafile/undotbs1.260.772910465

input datafile fno=00004name=+DATA/myrac/datafile/undotbs2.263.772910521

input datafile fno=00005name=+DATA/myrac/datafile/users.264.772910533

channel ORA_DISK_1: starting piece 1 at27-SEP-12

channel ORA_DISK_1: finished piece 1 at27-SEP-12

piece handle=+BACKUP/bak_04nm8vll_1_1tag=TAG20120927T171949 comment=NONE

channel ORA_DISK_1: backup set complete,elapsed time: 00:01:35

Finished backup at 27-SEP-12

 

Starting backup at 27-SEP-12

current log archived

using channel ORA_DISK_1

channel ORA_DISK_1: starting compressedarchive log backupset

channel ORA_DISK_1: specifying archivelog(s) in backup set

input archive log thread=1 sequence=92recid=8 stamp=795115285

input archive log thread=2 sequence=50recid=9 stamp=795115204

channel ORA_DISK_1: starting piece 1 at27-SEP-12

channel ORA_DISK_1: finished piece 1 at27-SEP-12

piece handle=+BACKUP/bak_05nm8vos_1_1tag=TAG20120927T172132 comment=NONE

channel ORA_DISK_1: backup set complete,elapsed time: 00:00:03

Finished backup at 27-SEP-12

 

Starting Control File and SPFILE Autobackupat 27-SEP-12

piecehandle=+BACKUP/autobackup_control_c-4177338842-20120927-00 comment=NONE

Finished Control File and SPFILE Autobackupat 27-SEP-12

 

共享磁盘查看:

ASMCMD> pwd

+backup

ASMCMD> ls

MYRAC/

autobackup_control_c-4177338842-20120927-00

bak_03nm8vl8_1_1

bak_04nm8vll_1_1

bak_05nm8vos_1_1

snapcf_myrac1.f

ASMCMD>

其实这些都是快捷方式 连接到 MYRAC下面

ASMCMD> ls -ls

Type        Redund  Striped  Time             Sys  Block_Size Blocks      Bytes      Space Name

                                              Y                                             MYRAC/

                                               N                                             autobackup_control_c-4177338842-20120927-00 =>+BACKUP/MYRAC/AUTOBACKUP/2012_09_27/s_795115295.260.795115299

                                              N                                              bak_03nm8vl8_1_1=>+BACKUP/MYRAC/BACKUPSET/2012_09_27/annnf0_TAG20120927T171935_0.256.795115181

                                              N                                             bak_04nm8vll_1_1 => +BACKUP/MYRAC/BACKUPSET/2012_09_27/nnndf0_TAG20120927T171949_0.257.795115191

                                              N                                             bak_05nm8vos_1_1 =>+BACKUP/MYRAC/BACKUPSET/2012_09_27/annnf0_TAG20120927T172132_0.258.795115295

                                               N                                             snapcf_myrac1.f => +BACKUP/MYRAC/CONTROLFILE/Backup.259.795115295

linux

本網站聲明
本文內容由網友自願投稿,版權歸原作者所有。本站不承擔相應的法律責任。如發現涉嫌抄襲或侵權的內容,請聯絡admin@php.cn

熱AI工具

Undresser.AI Undress

Undresser.AI Undress

人工智慧驅動的應用程序,用於創建逼真的裸體照片

AI Clothes Remover

AI Clothes Remover

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

Undress AI Tool

Undress AI Tool

免費脫衣圖片

Clothoff.io

Clothoff.io

AI脫衣器

Video Face Swap

Video Face Swap

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

熱工具

記事本++7.3.1

記事本++7.3.1

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

SublimeText3漢化版

SublimeText3漢化版

中文版,非常好用

禪工作室 13.0.1

禪工作室 13.0.1

強大的PHP整合開發環境

Dreamweaver CS6

Dreamweaver CS6

視覺化網頁開發工具

SublimeText3 Mac版

SublimeText3 Mac版

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

使用ddrescue在Linux上恢復數據 使用ddrescue在Linux上恢復數據 Mar 20, 2024 pm 01:37 PM

DDREASE是一種用於從檔案或區塊裝置(如硬碟、SSD、RAM磁碟、CD、DVD和USB儲存裝置)復原資料的工具。它將資料從一個區塊設備複製到另一個區塊設備,留下損壞的資料區塊,只移動好的資料區塊。 ddreasue是一種強大的恢復工具,完全自動化,因為它在恢復操作期間不需要任何干擾。此外,由於有了ddasue地圖文件,它可以隨時停止和恢復。 DDREASE的其他主要功能如下:它不會覆寫恢復的數據,但會在迭代恢復的情況下填補空白。但是,如果指示工具明確執行此操作,則可以將其截斷。將資料從多個檔案或區塊還原到單

開源!超越ZoeDepth! DepthFM:快速且精確的單目深度估計! 開源!超越ZoeDepth! DepthFM:快速且精確的單目深度估計! Apr 03, 2024 pm 12:04 PM

0.這篇文章乾了啥?提出了DepthFM:一個多功能且快速的最先進的生成式單目深度估計模型。除了傳統的深度估計任務外,DepthFM還展示了在深度修復等下游任務中的最先進能力。 DepthFM效率高,可以在少數推理步驟內合成深度圖。以下一起來閱讀這項工作~1.論文資訊標題:DepthFM:FastMonocularDepthEstimationwithFlowMatching作者:MingGui,JohannesS.Fischer,UlrichPrestel,PingchuanMa,Dmytr

如何多條件使用Excel過濾功能 如何多條件使用Excel過濾功能 Feb 26, 2024 am 10:19 AM

如果您需要了解如何在Excel中使用具有多個條件的篩選功能,以下教學將引導您完成對應步驟,確保您可以有效地篩選資料和排序資料。 Excel的篩選功能是非常強大的,能夠幫助您從大量資料中提取所需的資訊。這個功能可以根據您設定的條件,過濾資料並只顯示符合條件的部分,讓資料的管理變得更有效率。透過使用篩選功能,您可以快速找到目標數據,節省了尋找和整理數據的時間。這個功能不僅可以應用在簡單的資料清單上,還可以根據多個條件進行篩選,幫助您更精準地定位所需資訊。總的來說,Excel的篩選功能是一個非常實用的

Google狂喜:JAX性能超越Pytorch、TensorFlow!或成GPU推理訓練最快選擇 Google狂喜:JAX性能超越Pytorch、TensorFlow!或成GPU推理訓練最快選擇 Apr 01, 2024 pm 07:46 PM

谷歌力推的JAX在最近的基準測試中表現已經超過Pytorch和TensorFlow,7項指標排名第一。而且測試並不是JAX性能表現最好的TPU上完成的。雖然現在在開發者中,Pytorch依然比Tensorflow更受歡迎。但未來,也許有更多的大型模型會基於JAX平台進行訓練和運行。模型最近,Keras團隊為三個後端(TensorFlow、JAX、PyTorch)與原生PyTorch實作以及搭配TensorFlow的Keras2進行了基準測試。首先,他們為生成式和非生成式人工智慧任務選擇了一組主流

iPhone上的蜂窩數據網路速度慢:修復 iPhone上的蜂窩數據網路速度慢:修復 May 03, 2024 pm 09:01 PM

在iPhone上面臨滯後,緩慢的行動數據連線?通常,手機上蜂窩互聯網的強度取決於幾個因素,例如區域、蜂窩網絡類型、漫遊類型等。您可以採取一些措施來獲得更快、更可靠的蜂窩網路連線。修復1–強制重啟iPhone有時,強制重啟設備只會重置許多內容,包括蜂窩網路連線。步驟1–只需按一次音量調高鍵並放開即可。接下來,按降低音量鍵並再次釋放它。步驟2–過程的下一部分是按住右側的按鈕。讓iPhone完成重啟。啟用蜂窩數據並檢查網路速度。再次檢查修復2–更改資料模式雖然5G提供了更好的網路速度,但在訊號較弱

特斯拉機器人進廠打工,馬斯克:手的自由度今年將達到22個! 特斯拉機器人進廠打工,馬斯克:手的自由度今年將達到22個! May 06, 2024 pm 04:13 PM

特斯拉機器人Optimus最新影片出爐,已經可以在工廠裡打工了。正常速度下,它分揀電池(特斯拉的4680電池)是這樣的:官方還放出了20倍速下的樣子——在小小的「工位」上,揀啊揀啊揀:這次放出的影片亮點之一在於Optimus在廠子裡完成這項工作,是完全自主的,全程沒有人為的干預。而且在Optimus的視角之下,它還可以把放歪了的電池重新撿起來放置,主打一個自動糾錯:對於Optimus的手,英偉達科學家JimFan給出了高度的評價:Optimus的手是全球五指機器人裡最靈巧的之一。它的手不僅有觸覺

超級智能體生命力覺醒!可自我更新的AI來了,媽媽再也不用擔心資料瓶頸難題 超級智能體生命力覺醒!可自我更新的AI來了,媽媽再也不用擔心資料瓶頸難題 Apr 29, 2024 pm 06:55 PM

哭死啊,全球狂煉大模型,一網路的資料不夠用,根本不夠用。訓練模型搞得跟《飢餓遊戲》似的,全球AI研究者,都在苦惱怎麼才能餵飽這群資料大胃王。尤其在多模態任務中,這問題尤其突出。一籌莫展之際,來自人大系的初創團隊,用自家的新模型,率先在國內把「模型生成數據自己餵自己」變成了現實。而且還是理解側和生成側雙管齊下,兩側都能產生高品質、多模態的新數據,對模型本身進行數據反哺。模型是啥?中關村論壇上剛露面的多模態大模型Awaker1.0。團隊是誰?智子引擎。由人大高瓴人工智慧學院博士生高一鑷創立,高

阿里7B多模態文件理解大模型拿下新SOTA 阿里7B多模態文件理解大模型拿下新SOTA Apr 02, 2024 am 11:31 AM

多模態文件理解能力新SOTA!阿里mPLUG團隊發布最新開源工作mPLUG-DocOwl1.5,針對高解析度圖片文字辨識、通用文件結構理解、指令遵循、外部知識引入四大挑戰,提出了一系列解決方案。話不多說,先來看效果。複雜結構的圖表一鍵識別轉換為Markdown格式:不同樣式的圖表都可以:更細節的文字識別和定位也能輕鬆搞定:還能對文檔理解給出詳細解釋:要知道,“文檔理解”目前是大語言模型實現落地的一個重要場景,市面上有許多輔助文檔閱讀的產品,有的主要透過OCR系統進行文字識別,配合LLM進行文字理

See all articles