Oracle 10g RAC 备份 RMAN-mysql教程-PHP中文網

首頁

資料庫

mysql教程

Oracle 10g RAC 备份 RMAN

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

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

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

您可以使用哪些工具來監視MySQL性能？Apr 23, 2025 am 12:21 AM

如何有效監控MySQL性能？使用mysqladmin、SHOWGLOBALSTATUS、PerconaMonitoringandManagement(PMM)和MySQLEnterpriseMonitor等工具。 1.使用mysqladmin查看連接數。 2.用SHOWGLOBALSTATUS查看查詢數。 3.PMM提供詳細性能數據和圖形化界面。 4.MySQLEnterpriseMonitor提供豐富的監控功能和報警機制。

MySQL與SQL Server有何不同？Apr 23, 2025 am 12:20 AM

MySQL和SQLServer的区别在于：1)MySQL是开源的，适用于Web和嵌入式系统，2)SQLServer是微软的商业产品，适用于企业级应用。两者在存储引擎、性能优化和应用场景上有显著差异，选择时需考虑项目规模和未来扩展性。

在哪些情況下，您可以選擇SQL Server而不是MySQL？Apr 23, 2025 am 12:20 AM

在需要高可用性、高級安全性和良好集成性的企業級應用場景下，應選擇SQLServer而不是MySQL。 1)SQLServer提供企業級功能，如高可用性和高級安全性。 2)它與微軟生態系統如VisualStudio和PowerBI緊密集成。 3)SQLServer在性能優化方面表現出色，支持內存優化表和列存儲索引。

MySQL如何處理角色集和碰撞？Apr 23, 2025 am 12:19 AM

mySqlManagesCharacterSetsetSandCollationsyutusututf-8asthEdeFault，允許ConfigurationAtdataBase，table和columnlevels，AndrequiringCarefullageLignmentToavoidMismatches.1）setDefeaultCharactersetTercharactersetEtCollacterSeteTandColletationForAdataBase.2）conformentcollecharactersettersetertersetcollatertersetcollationcollation

MySQL中有什麼觸發器？Apr 23, 2025 am 12:11 AM

MySQL觸發器是與表相關聯的自動執行的存儲過程，用於在特定數據操作時執行一系列操作。 1）觸發器定義與作用：用於數據校驗、日誌記錄等。 2）工作原理：分為BEFORE和AFTER，支持行級觸發。 3）使用示例：可用於記錄薪資變更或更新庫存。 4）調試技巧：使用SHOWTRIGGERS和SHOWCREATETRIGGER命令。 5）性能優化：避免複雜操作，使用索引，管理事務。

您如何在MySQL中創建和管理用戶帳戶？Apr 22, 2025 pm 06:05 PM

在MySQL中創建和管理用戶賬戶的步驟如下：1.創建用戶：使用CREATEUSER'newuser'@'localhost'IDENTIFIEDBY'password';2.分配權限：使用GRANTSELECT,INSERT,UPDATEONmydatabase.TO'newuser'@'localhost';3.修正權限錯誤：使用REVOKEALLPRIVILEGESONmydatabase.FROM'newuser'@'localhost';然後重新分配權限；4.優化權限：使用SHOWGRA

MySQL與Oracle有何不同？Apr 22, 2025 pm 05:57 PM

MySQL適合快速開發和中小型應用，Oracle適合大型企業和高可用性需求。 1）MySQL開源、易用，適用於Web應用和中小型企業。 2）Oracle功能強大，適合大型企業和政府機構。 3）MySQL支持多種存儲引擎，Oracle提供豐富的企業級功能。

與其他關係數據庫相比，使用MySQL的缺點是什麼？Apr 22, 2025 pm 05:49 PM

MySQL相比其他關係型數據庫的劣勢包括：1.性能問題：在處理大規模數據時可能遇到瓶頸，PostgreSQL在復雜查詢和大數據處理上表現更優。 2.擴展性：水平擴展能力不如GoogleSpanner和AmazonAurora。 3.功能限制：在高級功能上不如PostgreSQL和Oracle，某些功能需要更多自定義代碼和維護。

See all articles