Oracle 10g RAC 备份 RMAN
[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

熱AI工具

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

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

Undress AI Tool
免費脫衣圖片

Clothoff.io
AI脫衣器

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

熱門文章

熱工具

記事本++7.3.1
好用且免費的程式碼編輯器

SublimeText3漢化版
中文版,非常好用

禪工作室 13.0.1
強大的PHP整合開發環境

Dreamweaver CS6
視覺化網頁開發工具

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

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

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

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

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

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

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

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

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