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

linux

版权声明:本文内容由互联网用户自发贡献,该文观点仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容, 请发送邮件至253000106@qq.com举报,一经查实,本站将立刻删除。

发布者:PHP中文网,转转请注明出处:https://www.chuangxiangniao.com/p/1914848.html

(0)
上一篇 2025年2月22日 17:49:34
下一篇 2025年2月22日 17:49:52

AD推荐 黄金广告位招租... 更多推荐

相关推荐

  • navicat怎么添加数据

    打开Navicat。 打开数据表所在的数据库,右击需要新增记录的数据库表,然后点击“打开表”。 相关推荐:《Navicat for mysql使用图文教程》 此时显示数据库表已有数据,例中并无记录。 直接在表中输入第一条记录的信息,一般字段…

    2025年2月23日 数据库
    100
  • navicat怎么导出数据

    当我们对mysql数据库进行了误操作,造成某个数据表中的部分数据丢失时,肯定就要利用备份的数据库,对丢失部分的数据进行导出、导入操作了。Navicat工具正好给我们提供了一个数据表的导入导出功能。 导出数据表 Navicat导出数据表的格式…

    2025年2月23日 数据库
    100
  • Excel数据如何批量导入navicat

    打开电脑上的Navicat,点击左上角的“连接”。 选择数据库类型。 填写相关的信息。 创建好之后就会显示存在的数据库名。 相关推荐:《Navicat for mysql使用图文教程》 选择指定的数据库名,右键单击,选择导入向导。 选择文件…

    2025年2月23日 数据库
    100
  • RMAN的crosscheck和obsolete的用法

    一直对rman的crosschcek和obsolete的用法理解的不清楚,而且有点混乱,这样对rman的备份集甚至备份的管理造成很大的影响,今天还 一直对rman的crosschcek和obsolete的用法理解的不清楚,而且有点混乱,这样…

    数据库 2025年2月23日
    100
  • 不同备份策略不兼容引起的磁盘空间故障解决实例

    最近接收一个系统,上线运维一年余。交接时候,业务部门反映曾经出现磁盘空间占满故障。当时引起整个系统瘫痪,最后联系开发商介 应用系统生命周期是一个整体,除了最开始的需求调研、开发测试和上线,更长的时期是在运维方面。应用系统的价值体现也就是在运…

    数据库 2025年2月23日
    100
  • Oracle并行执行特性应用初探

    在历史数据转出测试过程中,通过不断的优化,包括SQL调整和数据库调整,从AWR中看到,基本上难以进行更多的性能提升,于是准备试 1. 序 在历史数据转出测试过程中,通过不断的优化,包括sql调整和数据库调整,从awr中看到,基本上难以进行更…

    数据库 2025年2月23日
    100
  • Oracle生产环境RMAN备份脚本

    题记:这里分享一下我们Oracle的备份脚本,这些脚本均在生产库运行,正确无误! 环境:SUSE Linux 10sp2 + Oracle 11gR1 说明:小 题记:这里分享一下我们oracle的备份脚本,这些脚本均在生产库运行,正确无误…

    数据库 2025年2月23日
    100
  • xtraBackup备份原理剖析

    xtrabackup作为innodb的hotbackup工具,由percona公司开发,因开源,热备份和物理备份而在mysql中部署广泛,详情的说明可见之前的 xtrabackup作为innodb的hotbackup工具,由percona公…

    数据库 2025年2月23日
    100
  • 再说MySQL中的 table_id

    最近线上一个实例出现了主从数据不一致的情况,也即从库丢失数据的情况。根本原因:由于table_list-gt;table_id为uint,而m_table 【背景】最近线上一个实例出现了主从数据不一致的情况,也即从库丢失数据的情况。根本原因…

    数据库 2025年2月23日
    100
  • 更改Oracle数据库连接端口

    Oracle数据库默认数据库监听与连接端口是1521, 但是有时候项目中需要更改默认端口,这样做很多时候客户要求,基于安全考虑. 以Ora oracle数据库默认数据库监听与连接端口是1521, 但是有时候项目中需要更改默认端口,,这样做很…

    数据库 2025年2月23日
    100

发表回复

登录后才能评论