袁莎古筝梁祝视频:10g rac 归档 以及备份测试

来源：百度文库 编辑：九乡新闻网 时间：2024/05/15 06:03:46

操作系统：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>

10g rac 归档 以及备份测试 10g备份恢复测试 使用 CRS 在同一集群上配置 Oracle9i RAC 和 Oracle RAC 10g Oracle 10g r2 rac for aix 6.1 Redhat AS 5.0下配置Oracle 10g RAC RAC环境数据库的备份（一） 如何区分备份需求和归档需求？ Vmware+Linux+Oracle 10G RAC全程详细图解_实验准备 配置虚拟机 _Vmware+Linux+Oracle 10G RAC全程详细图解 在 Linux 和 iSCSI 上构建您自己的 Oracle RAC 10g 第 2 版集... 10G RAC DBCA报错 ORA-27504问题的解决 新建虚拟机_Vmware+Linux+Oracle 10G RAC全程详细图解 AIX5.3在使用HACMP安装ORACLE RAC 10G时的错误解决 集中讨论37 非归档模式下的用户管理备份与恢复 火狐备份插件以及设置的方法 WINCC+VBS+ADO访问归档数据（V6.2测试通过 拥有所有归档文件，但没有备份情况下的数据文件恢复 糖尿病患者饮食禁忌、以及注意事项。g WINCC+VBS+ADO访问归档数据（V6.2测试通过） 测试你的个性特征以及心理性格 如何简单测试Rman的备份恢复功能? 含有read only表空间备份与恢复测试 文件归档 [教程]刷机不再怕！！！教你如何单独备份你的通讯录、短信以及备忘录