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
,推荐阅读
-
ORACLE 数据库RMAN备份恢复
-
win平台oracle rman备份和删除dg备库归档日志脚本
-
Oracle 11g R2 RAC with ASM存储迁移--Rman copy&ASM Rebalance(一)
-
ORACLE 数据库RMAN备份恢复
-
oracle数据库中rman备份归档日志的常用脚本
-
rman_oracle数据库备份脚本整理
-
win平台oracle rman备份和删除dg备库归档日志脚本
-
oracle之rman备份教程
-
Oracle RMAN自动备份控制文件方法介绍
-
Oracle 11g R2 RAC with ASM存储迁移--Rman copy&ASM Rebalance(一)