首頁 資料庫 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脫衣器

AI Hentai Generator

AI Hentai Generator

免費產生 AI 無盡。

熱門文章

R.E.P.O.能量晶體解釋及其做什麼(黃色晶體)
2 週前 By 尊渡假赌尊渡假赌尊渡假赌
倉庫:如何復興隊友
4 週前 By 尊渡假赌尊渡假赌尊渡假赌
Hello Kitty Island冒險:如何獲得巨型種子
3 週前 By 尊渡假赌尊渡假赌尊渡假赌

熱工具

記事本++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

使用ddrescue在Linux上恢復數據

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

開源!超越ZoeDepth! DepthFM:快速且精確的單目深度估計!

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

如何多條件使用Excel過濾功能

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

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

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

Google狂喜:JAX性能超越Pytorch、TensorFlow!或成GPU推理訓練最快選擇

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

iPhone上的蜂窩數據網路速度慢:修復

美國空軍高調展示首個AI戰鬥機!部長親自試駕全程未乾預,10萬行代碼試飛21次 美國空軍高調展示首個AI戰鬥機!部長親自試駕全程未乾預,10萬行代碼試飛21次 May 07, 2024 pm 05:00 PM

美國空軍高調展示首個AI戰鬥機!部長親自試駕全程未乾預,10萬行代碼試飛21次

首個自主完成人類任務機器人出現,五指靈活速度超人,大模型加持虛擬空間訓練 首個自主完成人類任務機器人出現,五指靈活速度超人,大模型加持虛擬空間訓練 Mar 11, 2024 pm 12:10 PM

首個自主完成人類任務機器人出現,五指靈活速度超人,大模型加持虛擬空間訓練

See all articles