操作系统:HP-UX B.11.23 数据库 oracle 10203
总体思路是在rac的每个实例中都创建两个归档日志点其中一个存储在asm中,另一个存储在本地的文件系统中,本文仅为测试案例。
在节点2检查数据库的运行状态
oracle@ccnbjdc2[billbj2]:/home/oracle$ srvctl status database -d olivedb
Instance olivedb1 is running on node ccnbjdc1
Instance olivedb2 is running on node ccnbjdc2
oracle@ccnbjdc2[olivedb2]:/home/oracle$
在节点1检查数据库的运行状态
oracle@ccnbjdc1[olivedb1]:/home/oracle$ srvctl status database -d olivedb
Instance olivedb1 is running on node ccnbjdc1
Instance olivedb2 is running on node ccnbjdc2
oracle@olivedb1[olivedb1]:/home/oracle$
oracle@olivedb1[olivedb1]:/home/oracle$ echo $ORACLE_SID
olivedb1
oracle@olivedb1[olivedb1]:/home/oracle$ export ORACLE_SID=+ASM1
在ASM1中添加一个目录,用来存放归档日志
oracle@olivedb1[+ASM1]:/home/oracle$ sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.3.0 - Production on Thu Sep 6 18:28:52 2007
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
SQL> ALTER DISKGROUP DG_DATA_02 ADD DIRECTORY '+DG_DATA_02/olivedb/archivelog/';
Diskgroup altered.
SQL>
后来证明这种方法不可行,具体原因参考http://blog.chinaunix.net/u/7121/showart.php?id=379609
修改节点1的归档路径
oracle@olivedb1[olivedb1]:/home/oracle$ export ORACLE_SID=olivedb1
oracle@olivedb1[olivedb1]:/home/oracle$ echo $ORACLE_SID
olivedb1
oracle@olivedb1[olivedb1]:/home/oracle$ sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.3.0 - Production on Thu Sep 6 18:50:30 2007
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
SQL> alter system set log_archive_dest_2='location=+DG_DATA_02/olivedb/archivelog/' SID = 'olivedb1';
System altered.
SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_1 = 'LOCATION=/test1/archivelog' SID = 'olivedb1';
System altered.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 8589934592 bytes
Fixed Size 2059152 bytes
Variable Size 587203696 bytes
Database Buffers 7985954816 bytes
Redo Buffers 14716928 bytes
Database mounted.
SQL> alter database archivelog;
Database altered.
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination +DG_DATA_02/olivedb/archivelog/
Oldest online log sequence 5597
Next log sequence to archive 5598
Current log sequence 5598
SQL> alter database open;
Database altered.
SQL>
修改节点2的归档路径
oracle@ccnbjdc2[olivedb2]:/home/oracle$ echo $ORACLE_SID
olivedb2
oracle@ccnbjdc2[olivedb2]:/home/oracle$ sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.3.0 - Production on Thu Sep 6 18:52:04 2007
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
SQL> alter system set log_archive_dest_2='location=+DG_DATA_02/olivedb/archivelog/' SID = 'olivedb2';
System altered.
SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_1 = 'LOCATION=/test/archivelog' SID = 'olivedb2';
System altered.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 8589934592 bytes
Fixed Size 2059152 bytes
Variable Size 1023411312 bytes
Database Buffers 7549747200 bytes
Redo Buffers 14716928 bytes
Database mounted.
SQL> alter database archivelog;
Database altered.
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination +DG_DATA_02/olivedb/archivelog/
Oldest online log sequence 4597
Next log sequence to archive 4598
Current log sequence 4598
SQL> alter database open;
Database altered.
SQL>
在节点1进行进行备份测试
RMAN> backup database format '/test1/backup/%U.BAK';
Starting backup at 06-SEP-07
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00005 name=+DG_DATA_01/olivedb/datafile/undotbs2.267.631731425
input datafile fno=00009 name=+DG_DATA_01/olivedb/datafile/data_02_idx.276.631897249
input datafile fno=00022 name=+DG_DATA_01/olivedb/datafile/data_02_idx.291.632408725
input datafile fno=00012 name=+DG_DATA_01/olivedb/datafile/data_04.279.631897251
input datafile fno=00002 name=+DG_DATA_01/olivedb/datafile/undotbs1.258.631731333
input datafile fno=00013 name=+DG_DATA_01/olivedb/datafile/data_04_idx.280.631897253
input datafile fno=00010 name=+DG_DATA_01/olivedb/datafile/data_03.277.631897251
input datafile fno=00014 name=+DG_DATA_01/olivedb/datafile/tbs_defalut.281.631897253
input datafile fno=00027 name=+DG_DATA_02/olivedb/datafile/data_02_03.dbf
input datafile fno=00028 name=+DG_DATA_02/olivedb/datafile/data_02_04.dbf
input datafile fno=00029 name=+DG_DATA_01/olivedb/datafile/data_02_idx_01.dbf
input datafile fno=00030 name=+DG_DATA_01/olivedb/datafile/data_02_idx_02.dbf
input datafile fno=00031 name=+DG_DATA_02/olivedb/datafile/data_04_01.dbf
input datafile fno=00032 name=+DG_DATA_02/olivedb/datafile/data_04_02.dbf
input datafile fno=00033 name=+DG_DATA_02/olivedb/datafile/data_04_idx_01.dbf
input datafile fno=00034 name=+DG_DATA_02/olivedb/datafile/data_04_idx_02.dbf
input datafile fno=00035 name=+DG_DATA_01/olivedb/datafile/data_01_01.dbf
input datafile fno=00036 name=+DG_DATA_01/olivedb/datafile/data_01_02.dbf
input datafile fno=00037 name=+DG_DATA_01/olivedb/datafile/data_03_idx_01.dbf
input datafile fno=00038 name=+DG_DATA_01/olivedb/datafile/data_03_idx_02.dbf
input datafile fno=00039 name=+DG_DATA_01/olivedb/datafile/data_03_01.dbf
input datafile fno=00040 name=+DG_DATA_01/olivedb/datafile/data_03_02.dbf
input datafile fno=00008 name=+DG_DATA_01/olivedb/datafile/data_02.275.631897249
input datafile fno=00019 name=+DG_DATA_01/olivedb/datafile/data_03.288.632408675
input datafile fno=00011 name=+DG_DATA_01/olivedb/datafile/data_03_idx.278.631897251
input datafile fno=00007 name=+DG_DATA_01/olivedb/datafile/data_01_idx.274.631897237
input datafile fno=00018 name=+DG_DATA_01/olivedb/datafile/data_04_idx.287.632408635
input datafile fno=00017 name=+DG_DATA_01/olivedb/datafile/data_04.286.632408501
input datafile fno=00021 name=+DG_DATA_01/olivedb/datafile/data_02.290.632408713
input datafile fno=00006 name=+DG_DATA_01/olivedb/datafile/data_01.273.631732765
input datafile fno=00024 name=+DG_DATA_01/olivedb/datafile/data_01_idx.293.632408757
input datafile fno=00001 name=+DG_DATA_01/olivedb/datafile/system.256.631731331
input datafile fno=00023 name=+DG_DATA_01/olivedb/datafile/data_01.292.632408747
input datafile fno=00003 name=+DG_DATA_01/olivedb/datafile/sysaux.257.631731331
input datafile fno=00016 name=+DG_DATA_01/olivedb/datafile/data_01.285.632400945
input datafile fno=00015 name=+DG_DATA_02/olivedb/datafile/tbs_defalut_idx.256.632064211
input datafile fno=00020 name=+DG_DATA_01/olivedb/datafile/data_03_idx.289.632408685
input datafile fno=00025 name=+DG_DATA_01/olivedb/datafile/tbs_defalut.294.632408787
input datafile fno=00026 name=+DG_DATA_01/olivedb/datafile/tbs_defalut_idx.295.632408797
input datafile fno=00004 name=+DG_DATA_01/olivedb/datafile/users.259.631731333
channel ORA_DISK_1: starting piece 1 at 06-SEP-07
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 09/06/2007 19:07:03
ORA-19502: write error on file "/test1/backup/08ir9gg2_1_1.BAK", blockno 262017 (blocksize=8192)
ORA-27072: File I/O error
HPUX-ia64 Error: 11: Resource temporarily unavailable
Additional information: 4
Additional information: 262017
Additional information: 1040383
在节点2进行备份测试也报同样的错误。
开始以为是datafile 11的块262017坏了,所以最初尝试了修复。
RMAN> blockrecover datafile 11 block 262017 from backupset;
Starting blockrecover at 06-SEP-07
using channel ORA_DISK_1
starting media recovery
media recovery complete, elapsed time: 00:00:00
Finished blockrecover at 06-SEP-07
在节点2进行backup validate database;
RMAN> backup validate database;
Starting backup at 06-SEP-07
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=125 instance=olivedb2 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00005 name=+DG_DATA_01/olivedb/datafile/undotbs2.267.631731425
input datafile fno=00009 name=+DG_DATA_01/olivedb/datafile/data_02_idx.276.631897249
input datafile fno=00022 name=+DG_DATA_01/olivedb/datafile/data_02_idx.291.632408725
input datafile fno=00012 name=+DG_DATA_01/olivedb/datafile/data_04.279.631897251
input datafile fno=00002 name=+DG_DATA_01/olivedb/datafile/undotbs1.258.631731333
input datafile fno=00013 name=+DG_DATA_01/olivedb/datafile/data_04_idx.280.631897253
input datafile fno=00010 name=+DG_DATA_01/olivedb/datafile/data_03.277.631897251
input datafile fno=00014 name=+DG_DATA_01/olivedb/datafile/tbs_defalut.281.631897253
input datafile fno=00027 name=+DG_DATA_02/olivedb/datafile/data_02_03.dbf
input datafile fno=00028 name=+DG_DATA_02/olivedb/datafile/data_02_04.dbf
input datafile fno=00029 name=+DG_DATA_01/olivedb/datafile/data_02_idx_01.dbf
input datafile fno=00030 name=+DG_DATA_01/olivedb/datafile/data_02_idx_02.dbf
input datafile fno=00031 name=+DG_DATA_02/olivedb/datafile/data_04_01.dbf
input datafile fno=00032 name=+DG_DATA_02/olivedb/datafile/data_04_02.dbf
input datafile fno=00033 name=+DG_DATA_02/olivedb/datafile/data_04_idx_01.dbf
input datafile fno=00034 name=+DG_DATA_02/olivedb/datafile/data_04_idx_02.dbf
input datafile fno=00035 name=+DG_DATA_01/olivedb/datafile/data_01_01.dbf
input datafile fno=00036 name=+DG_DATA_01/olivedb/datafile/data_01_02.dbf
input datafile fno=00037 name=+DG_DATA_01/olivedb/datafile/data_03_idx_01.dbf
input datafile fno=00038 name=+DG_DATA_01/olivedb/datafile/data_03_idx_02.dbf
input datafile fno=00039 name=+DG_DATA_01/olivedb/datafile/data_03_01.dbf
input datafile fno=00040 name=+DG_DATA_01/olivedb/datafile/data_03_02.dbf
input datafile fno=00008 name=+DG_DATA_01/olivedb/datafile/data_02.275.631897249
input datafile fno=00019 name=+DG_DATA_01/olivedb/datafile/data_03.288.632408675
input datafile fno=00011 name=+DG_DATA_01/olivedb/datafile/data_03_idx.278.631897251
input datafile fno=00007 name=+DG_DATA_01/olivedb/datafile/data_01_idx.274.631897237
input datafile fno=00018 name=+DG_DATA_01/olivedb/datafile/data_04_idx.287.632408635
input datafile fno=00017 name=+DG_DATA_01/olivedb/datafile/data_04.286.632408501
input datafile fno=00021 name=+DG_DATA_01/olivedb/datafile/data_02.290.632408713
input datafile fno=00006 name=+DG_DATA_01/olivedb/datafile/data_01.273.631732765
input datafile fno=00024 name=+DG_DATA_01/olivedb/datafile/data_01_idx.293.632408757
input datafile fno=00001 name=+DG_DATA_01/olivedb/datafile/system.256.631731331
input datafile fno=00023 name=+DG_DATA_01/olivedb/datafile/data_01.292.632408747
input datafile fno=00003 name=+DG_DATA_01/olivedb/datafile/sysaux.257.631731331
input datafile fno=00016 name=+DG_DATA_01/olivedb/datafile/data_01.285.632400945
input datafile fno=00015 name=+DG_DATA_02/olivedb/datafile/tbs_defalut_idx.256.632064211
input datafile fno=00020 name=+DG_DATA_01/olivedb/datafile/data_03_idx.289.632408685
input datafile fno=00025 name=+DG_DATA_01/olivedb/datafile/tbs_defalut.294.632408787
input datafile fno=00026 name=+DG_DATA_01/olivedb/datafile/tbs_defalut_idx.295.632408797
input datafile fno=00004 name=+DG_DATA_01/olivedb/datafile/users.259.631731333
channel ORA_DISK_1: backup set complete, elapsed time: 00:17:06
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
including current SPFILE in backupset
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 06-SEP-07
RMAN>
结果成功,这时候怀疑是文件系统的问题,但是没有向文件系统进行下去。
RMAN> run{
2> allocate channel c1 device type disk format '/test/backup/%u';
3> backup database;
4> release channel c1;
5> }
allocated channel: c1
channel c1: sid=125 instance=olivedb2 devtype=DISK
Starting backup at 06-SEP-07
channel c1: starting full datafile backupset
channel c1: specifying datafile(s) in backupset
input datafile fno=00005 name=+DG_DATA_01/olivedb/datafile/undotbs2.267.631731425
input datafile fno=00009 name=+DG_DATA_01/olivedb/datafile/data_02_idx.276.631897249
input datafile fno=00022 name=+DG_DATA_01/olivedb/datafile/data_02_idx.291.632408725
input datafile fno=00012 name=+DG_DATA_01/olivedb/datafile/data_04.279.631897251
input datafile fno=00002 name=+DG_DATA_01/olivedb/datafile/undotbs1.258.631731333
input datafile fno=00013 name=+DG_DATA_01/olivedb/datafile/data_04_idx.280.631897253
input datafile fno=00010 name=+DG_DATA_01/olivedb/datafile/data_03.277.631897251
input datafile fno=00014 name=+DG_DATA_01/olivedb/datafile/tbs_defalut.281.631897253
input datafile fno=00027 name=+DG_DATA_02/olivedb/datafile/data_02_03.dbf
input datafile fno=00028 name=+DG_DATA_02/olivedb/datafile/data_02_04.dbf
input datafile fno=00029 name=+DG_DATA_01/olivedb/datafile/data_02_idx_01.dbf
input datafile fno=00030 name=+DG_DATA_01/olivedb/datafile/data_02_idx_02.dbf
input datafile fno=00031 name=+DG_DATA_02/olivedb/datafile/data_04_01.dbf
input datafile fno=00032 name=+DG_DATA_02/olivedb/datafile/data_04_02.dbf
input datafile fno=00033 name=+DG_DATA_02/olivedb/datafile/data_04_idx_01.dbf
input datafile fno=00034 name=+DG_DATA_02/olivedb/datafile/data_04_idx_02.dbf
input datafile fno=00035 name=+DG_DATA_01/olivedb/datafile/data_01_01.dbf
input datafile fno=00036 name=+DG_DATA_01/olivedb/datafile/data_01_02.dbf
input datafile fno=00037 name=+DG_DATA_01/olivedb/datafile/data_03_idx_01.dbf
input datafile fno=00038 name=+DG_DATA_01/olivedb/datafile/data_03_idx_02.dbf
input datafile fno=00039 name=+DG_DATA_01/olivedb/datafile/data_03_01.dbf
input datafile fno=00040 name=+DG_DATA_01/olivedb/datafile/data_03_02.dbf
input datafile fno=00008 name=+DG_DATA_01/olivedb/datafile/data_02.275.631897249
input datafile fno=00019 name=+DG_DATA_01/olivedb/datafile/data_03.288.632408675
input datafile fno=00011 name=+DG_DATA_01/olivedb/datafile/data_03_idx.278.631897251
input datafile fno=00007 name=+DG_DATA_01/olivedb/datafile/data_01_idx.274.631897237
input datafile fno=00018 name=+DG_DATA_01/olivedb/datafile/data_04_idx.287.632408635
input datafile fno=00017 name=+DG_DATA_01/olivedb/datafile/data_04.286.632408501
input datafile fno=00021 name=+DG_DATA_01/olivedb/datafile/data_02.290.632408713
input datafile fno=00006 name=+DG_DATA_01/olivedb/datafile/data_01.273.631732765
input datafile fno=00024 name=+DG_DATA_01/olivedb/datafile/data_01_idx.293.632408757
input datafile fno=00001 name=+DG_DATA_01/olivedb/datafile/system.256.631731331
input datafile fno=00023 name=+DG_DATA_01/olivedb/datafile/data_01.292.632408747
input datafile fno=00003 name=+DG_DATA_01/olivedb/datafile/sysaux.257.631731331
input datafile fno=00016 name=+DG_DATA_01/olivedb/datafile/data_01.285.632400945
input datafile fno=00015 name=+DG_DATA_02/olivedb/datafile/tbs_defalut_idx.256.632064211
input datafile fno=00020 name=+DG_DATA_01/olivedb/datafile/data_03_idx.289.632408685
input datafile fno=00025 name=+DG_DATA_01/olivedb/datafile/tbs_defalut.294.632408787
input datafile fno=00026 name=+DG_DATA_01/olivedb/datafile/tbs_defalut_idx.295.632408797
input datafile fno=00004 name=+DG_DATA_01/olivedb/datafile/users.259.631731333
channel c1: starting piece 1 at 06-SEP-07
released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on c1 channel at 09/06/2007 19:48:47
ORA-19502: write error on file "/test/backup/0gir9iu7", blockno 262017 (blocksize=8192)
ORA-27072: File I/O error
HPUX-ia64 Error: 11: Resource temporarily unavailable
Additional information: 4
Additional information: 262017
Additional information: 1040383
将数据备份到ASM中,结果成功。
RMAN> backup database format '+DG_DATA_02/olivedb/archivelog/%u.bak';
Starting backup at 07-SEP-07
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=142 instance=olivedb2 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00005 name=+DG_DATA_01/olivedb/datafile/undotbs2.267.631731425
input datafile fno=00009 name=+DG_DATA_01/olivedb/datafile/data_02_idx.276.631897249
input datafile fno=00022 name=+DG_DATA_01/olivedb/datafile/data_02_idx.291.632408725
input datafile fno=00012 name=+DG_DATA_01/olivedb/datafile/data_04.279.631897251
input datafile fno=00002 name=+DG_DATA_01/olivedb/datafile/undotbs1.258.631731333
input datafile fno=00013 name=+DG_DATA_01/olivedb/datafile/data_04_idx.280.631897253
input datafile fno=00010 name=+DG_DATA_01/olivedb/datafile/data_03.277.631897251
input datafile fno=00014 name=+DG_DATA_01/olivedb/datafile/tbs_defalut.281.631897253
input datafile fno=00027 name=+DG_DATA_02/olivedb/datafile/data_02_03.dbf
input datafile fno=00028 name=+DG_DATA_02/olivedb/datafile/data_02_04.dbf
input datafile fno=00029 name=+DG_DATA_01/olivedb/datafile/data_02_idx_01.dbf
input datafile fno=00030 name=+DG_DATA_01/olivedb/datafile/data_02_idx_02.dbf
input datafile fno=00031 name=+DG_DATA_02/olivedb/datafile/data_04_01.dbf
input datafile fno=00032 name=+DG_DATA_02/olivedb/datafile/data_04_02.dbf
input datafile fno=00033 name=+DG_DATA_02/olivedb/datafile/data_04_idx_01.dbf
input datafile fno=00034 name=+DG_DATA_02/olivedb/datafile/data_04_idx_02.dbf
input datafile fno=00035 name=+DG_DATA_01/olivedb/datafile/data_01_01.dbf
input datafile fno=00036 name=+DG_DATA_01/olivedb/datafile/data_01_02.dbf
input datafile fno=00037 name=+DG_DATA_01/olivedb/datafile/data_03_idx_01.dbf
input datafile fno=00038 name=+DG_DATA_01/olivedb/datafile/data_03_idx_02.dbf
input datafile fno=00039 name=+DG_DATA_01/olivedb/datafile/data_03_01.dbf
input datafile fno=00040 name=+DG_DATA_01/olivedb/datafile/data_03_02.dbf
input datafile fno=00008 name=+DG_DATA_01/olivedb/datafile/data_02.275.631897249
input datafile fno=00019 name=+DG_DATA_01/olivedb/datafile/data_03.288.632408675
input datafile fno=00011 name=+DG_DATA_01/olivedb/datafile/data_03_idx.278.631897251
input datafile fno=00007 name=+DG_DATA_01/olivedb/datafile/data_01_idx.274.631897237
input datafile fno=00018 name=+DG_DATA_01/olivedb/datafile/data_04_idx.287.632408635
input datafile fno=00017 name=+DG_DATA_01/olivedb/datafile/data_04.286.632408501
input datafile fno=00021 name=+DG_DATA_01/olivedb/datafile/data_02.290.632408713
input datafile fno=00006 name=+DG_DATA_01/olivedb/datafile/data_01.273.631732765
input datafile fno=00024 name=+DG_DATA_01/olivedb/datafile/data_01_idx.293.632408757
input datafile fno=00001 name=+DG_DATA_01/olivedb/datafile/system.256.631731331
input datafile fno=00023 name=+DG_DATA_01/olivedb/datafile/data_01.292.632408747
input datafile fno=00003 name=+DG_DATA_01/olivedb/datafile/sysaux.257.631731331
input datafile fno=00016 name=+DG_DATA_01/olivedb/datafile/data_01.285.632400945
input datafile fno=00015 name=+DG_DATA_02/olivedb/datafile/tbs_defalut_idx.256.632064211
input datafile fno=00020 name=+DG_DATA_01/olivedb/datafile/data_03_idx.289.632408685
input datafile fno=00025 name=+DG_DATA_01/olivedb/datafile/tbs_defalut.294.632408787
input datafile fno=00026 name=+DG_DATA_01/olivedb/datafile/tbs_defalut_idx.295.632408797
input datafile fno=00004 name=+DG_DATA_01/olivedb/datafile/users.259.631731333
channel ORA_DISK_1: starting piece 1 at 07-SEP-07
channel ORA_DISK_1: finished piece 1 at 07-SEP-07
piece handle=+DG_DATA_02/olivedb/archivelog/0kirb1j0.bak tag=TAG20070907T090328 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:16:16
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
including current SPFILE in backupset
channel ORA_DISK_1: starting piece 1 at 07-SEP-07
channel ORA_DISK_1: finished piece 1 at 07-SEP-07
piece handle=+DG_DATA_02/olivedb/archivelog/0lirb2hg.bak tag=TAG20070907T090328 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:04
Finished backup at 07-SEP-07
进行还原验证也没有问题。
RMAN> restore validate database;
Starting restore at 07-SEP-07
using channel ORA_DISK_1
channel ORA_DISK_1: starting validation of datafile backupset
channel ORA_DISK_1: reading from backup piece +DG_DATA_02/olivedb/archivelog/0kirb1j0.bak
channel ORA_DISK_1: restored backup piece 1
piece handle=+DG_DATA_02/olivedb/archivelog/0kirb1j0.bak tag=TAG20070907T090328
channel ORA_DISK_1: validation complete, elapsed time: 00:10:37
Finished restore at 07-SEP-07
RMAN>
RMAN> run{
2> allocate channel c1 device type disk format '/test/backup/%u';
3> backup database maxsetsize=20G;
4> release channel c1;
5> }
using target database control file instead of recovery catalog
allocated channel: c1
channel c1: sid=124 instance=olivedb2 devtype=DISK
Starting backup at 07-SEP-07
channel c1: starting full datafile backupset
channel c1: specifying datafile(s) in backupset
input datafile fno=00005 name=+DG_DATA_01/olivedb/datafile/undotbs2.267.631731425
input datafile fno=00017 name=+DG_DATA_01/olivedb/datafile/data_04.286.632408501
channel c1: starting piece 1 at 07-SEP-07
released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on c1 channel at 09/07/2007 10:33:52
ORA-19502: write error on file "/test/backup/0rirb6rd", blockno 262017 (blocksize=8192)
ORA-27072: File I/O error
HPUX-ia64 Error: 11: Resource temporarily unavailable
Additional information: 4
Additional information: 262017
Additional information: 1040383
检查块262017所在的表空间和区,然后对其进行相应的重建
SELECT tablespace_name, segment_type, owner, segment_name,block_id,blocks
FROM dba_extents
WHERE --file_id = 11 and
262017 between block_id AND block_id + blocks -1
UNDOTBS2 TYPE2 UNDO SYS _SYSSMU12$ 261769 1024
DATA_02 TABLE VIPBILL BIL_1700_2MON 262017 8
DATA_02_IDX INDEX PARTITION LOGBILL IX_DAILYTABLE_ALL 261641 1024
DATA_02_IDX INDEX PARTITION LOGBILL IX_DAILYTABLE_ALL 261129 1024
DATA_02_IDX INDEX LOGBILL PK_BANDWIDTH_DAILYTABLE 256905 8192
DATA_02_IDX INDEX LOGBILL PK_BANDWIDTH_DAILYTABLE 255881 8192
DATA_03 TABLE PARTITION LOGBILL BANDWIDTH_DAILYTABLE 261897 128
DATA_03 TABLE VIPBILL BIL_1202_3MON 261897 128
DATA_04 TABLE VIPBILL BIL_0482_4MON 261897 128
DATA_04_IDX INDEX VIPBILL SYS_C0026728 261897 128
SQL> alter index SYS_C0026728 rebuild;
Index altered
SQL> select count(*) from BIL_0482_4MON;
COUNT(*)
----------
13770
SQL> alter table BIL_0482_4MON rename to BIL_0482_4MON_bak;
Table altered
SQL> create table BIL_0482_4MON as select * from BIL_0482_4MON_bak;
Table created
SQL> drop table BIL_0482_4MON_bak;
。。。。
再次进行测试
RMAN> run{
2> allocate channel c1 device type disk format '/test/backup/%u';
3> backup validate tablespace DATA_02;
4> release channel c1;
5> }
allocated channel: c1
channel c1: sid=124 instance=olivedb2 devtype=DISK
Starting backup at 07-SEP-07
channel c1: starting full datafile backupset
channel c1: specifying datafile(s) in backupset
input datafile fno=00027 name=+DG_DATA_02/olivedb/datafile/data_02_03.dbf
input datafile fno=00028 name=+DG_DATA_02/olivedb/datafile/data_02_04.dbf
input datafile fno=00008 name=+DG_DATA_01/olivedb/datafile/data_02.275.631897249
input datafile fno=00021 name=+DG_DATA_01/olivedb/datafile/data_02.290.632408713
channel c1: backup set complete, elapsed time: 00:00:35
Finished backup at 07-SEP-07
released channel: c1
RMAN> run{
2> allocate channel c1 device type disk format '/test/backup/%u';
3> backup validate tablespace DATA_02_IDX;
4> release channel c1;
5> }
allocated channel: c1
channel c1: sid=124 instance=olivedb2 devtype=DISK
Starting backup at 07-SEP-07
channel c1: starting full datafile backupset
channel c1: specifying datafile(s) in backupset
input datafile fno=00009 name=+DG_DATA_01/olivedb/datafile/data_02_idx.276.631897249
input datafile fno=00022 name=+DG_DATA_01/olivedb/datafile/data_02_idx.291.632408725
input datafile fno=00029 name=+DG_DATA_01/olivedb/datafile/data_02_idx_01.dbf
input datafile fno=00030 name=+DG_DATA_01/olivedb/datafile/data_02_idx_02.dbf
channel c1: backup set complete, elapsed time: 00:02:15
Finished backup at 07-SEP-07
released channel: c1
RMAN>
RMAN> run{
2> allocate channel c1 device type disk format '/test/backup/%u';
3> backup validate tablespace DATA_03;
4> release channel c1;
5> }
allocated channel: c1
channel c1: sid=124 instance=olivedb2 devtype=DISK
Starting backup at 07-SEP-07
channel c1: starting full datafile backupset
channel c1: specifying datafile(s) in backupset
input datafile fno=00010 name=+DG_DATA_01/olivedb/datafile/data_03.277.631897251
input datafile fno=00039 name=+DG_DATA_01/olivedb/datafile/data_03_01.dbf
input datafile fno=00040 name=+DG_DATA_01/olivedb/datafile/data_03_02.dbf
input datafile fno=00019 name=+DG_DATA_01/olivedb/datafile/data_03.288.632408675
channel c1: backup set complete, elapsed time: 00:01:05
Finished backup at 07-SEP-07
released channel: c1
RMAN>
没有问题。
在文件系统中进行backup validate database,结果成功,到此我才完全从系统方面找原因,这中间走了好多弯路,如果是块损坏的话,backup database会将相应的错误信息写到alert_$ORACLE_SID.log中,的确我也查看过alert_$ORACLE_SID.log,没有找到错误信息,但是还是继续钻牛角了。
RMAN> run{
2> allocate channel c1 device type disk format '/test/backup/%u';
3> backup validate database;
4> release channel c1;
5> }
allocated channel: c1
channel c1: sid=124 instance=olivedb2 devtype=DISK
Starting backup at 07-SEP-07
channel c1: starting full datafile backupset
channel c1: specifying datafile(s) in backupset
input datafile fno=00005 name=+DG_DATA_01/olivedb/datafile/undotbs2.267.631731425
input datafile fno=00009 name=+DG_DATA_01/olivedb/datafile/data_02_idx.276.631897249
input datafile fno=00022 name=+DG_DATA_01/olivedb/datafile/data_02_idx.291.632408725
input datafile fno=00012 name=+DG_DATA_01/olivedb/datafile/data_04.279.631897251
input datafile fno=00002 name=+DG_DATA_01/olivedb/datafile/undotbs1.258.631731333
input datafile fno=00013 name=+DG_DATA_01/olivedb/datafile/data_04_idx.280.631897253
input datafile fno=00010 name=+DG_DATA_01/olivedb/datafile/data_03.277.631897251
input datafile fno=00014 name=+DG_DATA_01/olivedb/datafile/tbs_defalut.281.631897253
input datafile fno=00027 name=+DG_DATA_02/olivedb/datafile/data_02_03.dbf
input datafile fno=00028 name=+DG_DATA_02/olivedb/datafile/data_02_04.dbf
input datafile fno=00029 name=+DG_DATA_01/olivedb/datafile/data_02_idx_01.dbf
input datafile fno=00030 name=+DG_DATA_01/olivedb/datafile/data_02_idx_02.dbf
input datafile fno=00031 name=+DG_DATA_02/olivedb/datafile/data_04_01.dbf
input datafile fno=00032 name=+DG_DATA_02/olivedb/datafile/data_04_02.dbf
input datafile fno=00033 name=+DG_DATA_02/olivedb/datafile/data_04_idx_01.dbf
input datafile fno=00034 name=+DG_DATA_02/olivedb/datafile/data_04_idx_02.dbf
input datafile fno=00035 name=+DG_DATA_01/olivedb/datafile/data_01_01.dbf
input datafile fno=00036 name=+DG_DATA_01/olivedb/datafile/data_01_02.dbf
input datafile fno=00037 name=+DG_DATA_01/olivedb/datafile/data_03_idx_01.dbf
input datafile fno=00038 name=+DG_DATA_01/olivedb/datafile/data_03_idx_02.dbf
input datafile fno=00039 name=+DG_DATA_01/olivedb/datafile/data_03_01.dbf
input datafile fno=00040 name=+DG_DATA_01/olivedb/datafile/data_03_02.dbf
input datafile fno=00008 name=+DG_DATA_01/olivedb/datafile/data_02.275.631897249
input datafile fno=00019 name=+DG_DATA_01/olivedb/datafile/data_03.288.632408675
input datafile fno=00011 name=+DG_DATA_01/olivedb/datafile/data_03_idx.278.631897251
input datafile fno=00007 name=+DG_DATA_01/olivedb/datafile/data_01_idx.274.631897237
input datafile fno=00018 name=+DG_DATA_01/olivedb/datafile/data_04_idx.287.632408635
input datafile fno=00017 name=+DG_DATA_01/olivedb/datafile/data_04.286.632408501
input datafile fno=00021 name=+DG_DATA_01/olivedb/datafile/data_02.290.632408713
input datafile fno=00006 name=+DG_DATA_01/olivedb/datafile/data_01.273.631732765
input datafile fno=00024 name=+DG_DATA_01/olivedb/datafile/data_01_idx.293.632408757
input datafile fno=00001 name=+DG_DATA_01/olivedb/datafile/system.256.631731331
input datafile fno=00023 name=+DG_DATA_01/olivedb/datafile/data_01.292.632408747
input datafile fno=00003 name=+DG_DATA_01/olivedb/datafile/sysaux.257.631731331
input datafile fno=00016 name=+DG_DATA_01/olivedb/datafile/data_01.285.632400945
input datafile fno=00015 name=+DG_DATA_02/olivedb/datafile/tbs_defalut_idx.256.632064211
input datafile fno=00020 name=+DG_DATA_01/olivedb/datafile/data_03_idx.289.632408685
input datafile fno=00025 name=+DG_DATA_01/olivedb/datafile/tbs_defalut.294.632408787
input datafile fno=00026 name=+DG_DATA_01/olivedb/datafile/tbs_defalut_idx.295.632408797
input datafile fno=00004 name=+DG_DATA_01/olivedb/datafile/users.259.631731333
channel c1: backup set complete, elapsed time: 00:07:55
channel c1: starting full datafile backupset
channel c1: specifying datafile(s) in backupset
including current control file in backupset
including current SPFILE in backupset
channel c1: backup set complete, elapsed time: 00:00:03
Finished backup at 07-SEP-07
released channel: c1
RMAN>
此时从操作系统方面找原因,怀疑是VG方面的原因,经过查找原因是创建的文件系统没有取消2GB限制
系统版本HP-UX B.11.23
执行命令
fsadm -o largefiles /test
然后备份ok
olivedb1@[/]#fsadm -o largefiles /test
fsadm: /etc/default/fs is used for determining the file system type
RMAN> configure controlfile autobackup format for device type disk to '/test/backup/%F';
RMAN> backup database format '/test/backup/%u.bak';
Starting backup at 07-SEP-07
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00005 name=+DG_DATA_01/olivedb/datafile/undotbs2.267.631731425
input datafile fno=00009 name=+DG_DATA_01/olivedb/datafile/data_02_idx.276.631897249
input datafile fno=00022 name=+DG_DATA_01/olivedb/datafile/data_02_idx.291.632408725
input datafile fno=00012 name=+DG_DATA_01/olivedb/datafile/data_04.279.631897251
input datafile fno=00002 name=+DG_DATA_01/olivedb/datafile/undotbs1.258.631731333
input datafile fno=00013 name=+DG_DATA_01/olivedb/datafile/data_04_idx.280.631897253
input datafile fno=00010 name=+DG_DATA_01/olivedb/datafile/data_03.277.631897251
input datafile fno=00014 name=+DG_DATA_01/olivedb/datafile/tbs_defalut.281.631897253
input datafile fno=00027 name=+DG_DATA_02/olivedb/datafile/data_02_03.dbf
input datafile fno=00028 name=+DG_DATA_02/olivedb/datafile/data_02_04.dbf
input datafile fno=00029 name=+DG_DATA_01/olivedb/datafile/data_02_idx_01.dbf
input datafile fno=00030 name=+DG_DATA_01/olivedb/datafile/data_02_idx_02.dbf
input datafile fno=00031 name=+DG_DATA_02/olivedb/datafile/data_04_01.dbf
input datafile fno=00032 name=+DG_DATA_02/olivedb/datafile/data_04_02.dbf
input datafile fno=00033 name=+DG_DATA_02/olivedb/datafile/data_04_idx_01.dbf
input datafile fno=00034 name=+DG_DATA_02/olivedb/datafile/data_04_idx_02.dbf
input datafile fno=00035 name=+DG_DATA_01/olivedb/datafile/data_01_01.dbf
input datafile fno=00036 name=+DG_DATA_01/olivedb/datafile/data_01_02.dbf
input datafile fno=00037 name=+DG_DATA_01/olivedb/datafile/data_03_idx_01.dbf
input datafile fno=00038 name=+DG_DATA_01/olivedb/datafile/data_03_idx_02.dbf
input datafile fno=00039 name=+DG_DATA_01/olivedb/datafile/data_03_01.dbf
input datafile fno=00040 name=+DG_DATA_01/olivedb/datafile/data_03_02.dbf
input datafile fno=00008 name=+DG_DATA_01/olivedb/datafile/data_02.275.631897249
input datafile fno=00019 name=+DG_DATA_01/olivedb/datafile/data_03.288.632408675
input datafile fno=00011 name=+DG_DATA_01/olivedb/datafile/data_03_idx.278.631897251
input datafile fno=00007 name=+DG_DATA_01/olivedb/datafile/data_01_idx.274.631897237
input datafile fno=00018 name=+DG_DATA_01/olivedb/datafile/data_04_idx.287.632408635
input datafile fno=00017 name=+DG_DATA_01/olivedb/datafile/data_04.286.632408501
input datafile fno=00021 name=+DG_DATA_01/olivedb/datafile/data_02.290.632408713
input datafile fno=00006 name=+DG_DATA_01/olivedb/datafile/data_01.273.631732765
input datafile fno=00024 name=+DG_DATA_01/olivedb/datafile/data_01_idx.293.632408757
input datafile fno=00001 name=+DG_DATA_01/olivedb/datafile/system.256.631731331
input datafile fno=00023 name=+DG_DATA_01/olivedb/datafile/data_01.292.632408747
input datafile fno=00003 name=+DG_DATA_01/olivedb/datafile/sysaux.257.631731331
input datafile fno=00016 name=+DG_DATA_01/olivedb/datafile/data_01.285.632400945
input datafile fno=00015 name=+DG_DATA_02/olivedb/datafile/tbs_defalut_idx.256.632064211
input datafile fno=00020 name=+DG_DATA_01/olivedb/datafile/data_03_idx.289.632408685
input datafile fno=00025 name=+DG_DATA_01/olivedb/datafile/tbs_defalut.294.632408787
input datafile fno=00026 name=+DG_DATA_01/olivedb/datafile/tbs_defalut_idx.295.632408797
input datafile fno=00004 name=+DG_DATA_01/olivedb/datafile/users.259.631731333
channel ORA_DISK_1: starting piece 1 at 07-SEP-07
channel ORA_DISK_1: finished piece 1 at 07-SEP-07
piece handle=/test/backup/1circ3kh.bak tag=TAG20070907T184432 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:18:36
Finished backup at 07-SEP-07
Starting Control File and SPFILE Autobackup at 07-SEP-07
piece handle=/test/backup/c-2421612353-20070907-00 comment=NONE
Finished Control File and SPFILE Autobackup at 07-SEP-07
RMAN>
联系客服