当前位置:  数据库>oracle

Oracle 10g RAC 备份 RMAN

    来源: 互联网  发布时间：2017-05-09

    本文导语: [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 recov...

[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


    
 
 

您可能感兴趣的文章:

  • 如何将Aix上的oracle 物理备份 然后再在linux 系统上还原oracle
  • Oracle数据库设置任务计划备份一周的备份记录
  • Oracle数据库备份和恢复工具 RMan
  • oracle10g 数据备份与导入
  • aix下自动备份oracle 的输出日志问题，急！！
  • hp unix下备份oracle表的问题
  • linux小白提问linux备份oracle数据库的问题
  • 请问su oracle 和su - oracle有什么不同？ iis7站长之家
  • Oracle数据库逻辑备份的SH文件
  • Linux环境中Oracle数据导入与导出备份操作
  • oracle数据库备份急？？？？？？？？？？？
  • oracle定时备份压缩的实现步骤
  • Unix系统下如何将oracle数据库备份
  • 详解如何应用改变跟踪技术加速Oracle递增备份
  • Oracle中备份表的简单sql命令语句
  • 实战Oracle数据库备份与恢复
  • Linux下实现自动备份Oracle数据库
  • oracle备份恢复的具体方法
  • 利用windows任务计划实现oracle的定期备份
  • Oracle11g备份和恢复功能的提高
  • win平台oracle rman备份和删除dg备库归档日志脚本
  • Oracle相关：Rman Crosscheck删除失效归档
  • ORACLE 数据库RMAN备份恢复
  • rman恢复方案和oracle异机恢复
  • Oracle RMAN快速入门指南
    •  
    本站(WWW.)旨在分享和传播互联网科技相关的资讯和技术，将尽最大努力为读者提供更好的信息聚合和浏览方式。
    本站(WWW.)站内文章除注明原创外，均为转载、整理或搜集自网络。欢迎任何形式的转载，转载请注明出处。












  • 相关文章推荐
  • Oracle 12c发布简单介绍及官方下载地址
  • 在linux下安装oracle,如何设置让oracle自动启动！也就是让oracle那个服务自动启动，不是手动的
  • oracle 11g最新版官方下载地址
  • 请问su oracle 和su - oracle有什么不同？
  • Oracle 数据库(oracle Database)Select 多表关联查询方式
  • 虚拟机装Oracle R12与Oracle10g
  • Oracle数据库(Oracle Database)体系结构及基本组成介绍
  • Oracle 数据库开发工具 Oracle SQL Developer
  • 如何设置让Oracle SQL Developer显示的时间包含时分秒
  • Oracle EBS R12 支持 Oracle Database 11g
  • Oracle 10g和Oracle 11g网格技术介绍
  • SCO unix下安装oracle，但没有光盘，请大家推荐一个oracle下载站点（unix版本的）。谢谢！！！！
  • oracle中如何把表中具有相同值列的多行数据合并成一行
  • 请问大家用oracle数据库, 用import oracle.*;下的东西么? 还是用标准库?
  • Oracle 数据库(oracle Database)性能调优技术详解
  • Linux /$ORACLE_HOME $ORACLE_HOME
  • ORACLE日期相关操作
  • Linux系统下Oracle的启动与Oracle监听的启动
  • ORACLE数据库常用字段数据类型介绍
  • 请问在solaris下安装ORACLE，用root用户和用oracle用户安装有什么区别么？
  • Oracle 12c的九大最新技术特性介绍
  • 网间Oracle的连接，远程连接Oracle服务器？？


    • 站内导航:


    特别声明:169IT网站部分信息来自互联网,如果侵犯您的权利,请及时告知,本站将立即删除！

    ©2012-2021,