oracle导入错误1401,都是crosscheck惹的祸,备份归档失败

备份是大事,有的时候睡觉都惊醒,忘备份了

如果备份不细检查备份环节就更可怕了

RMAN> list archivelog all;

List of Archived Log Copies

Key     Thrd Seq     S Low Time  Name

------- ---- ------- - --------- ----

1224    2    107     X 25-DEC-07 /home/oracle/archive/2_107_640546001.arc

1225    2    108     X 25-DEC-07 /home/oracle/archive/2_108_640546001.arc

1226    2    109     X 26-DEC-07 /home/oracle/archive/2_109_640546001.arc

1228    2    110     X 26-DEC-07 /home/oracle/archive/2_110_640546001.arc

1229    2    111     X 26-DEC-07 /home/oracle/archive/2_111_640546001.arc

1231    2    112     X 26-DEC-07 /home/oracle/archive/2_112_640546001.arc

1232    2    113     X 26-DEC-07 /home/oracle/archive/2_113_640546001.arc

1234    2    114     X 26-DEC-07 /home/oracle/archive/2_114_640546001.arc

1235    2    115     X 26-DEC-07 /home/oracle/archive/2_115_640546001.arc

1236    2    116     X 26-DEC-07 /home/oracle/archive/2_116_640546001.arc

查看系统的归档,看到status为X,并没有在意,直接备份

但备份以后,发现RMAN不识别状态为X的归档,

RMAN> run

2> {

3> allocate channel c1 device type disk connect ;

4> allocate channel c2 device type disk connect ;

5> backup archivelog all delete all input;

6> }

released channel: ORA_DISK_1

released channel: ORA_DISK_2

allocated channel: c1

channel c1: sid=918 instance=baan1 devtype=DISK

allocated channel: c2

channel c2: sid=1080 instance=baan2 devtype=DISK

Starting backup at 21-MAR-08

current log archived

channel c1: starting archive log backupset

channel c1: specifying archive log(s) in backup set

input archive log thread=1 sequence=385 recid=1808 stamp=649954597

input archive log thread=1 sequence=386 recid=1811 stamp=649954670

channel c1: starting piece 1 at 21-MAR-08

根本没有去读第2个节点的归档,crosscheck archivelog all;以后,状态为available,

rman才重新识别,太可怕了,如果没有注意的话,一旦出现介质故障,就毁了

channel c2: starting piece 1 at 21-MAR-08

channel c1: finished piece 1 at 21-MAR-08

piece handle=+BACKUP/baan/backupset/2008_03_21/annnf0_tag20080321t145751_0.271.649954675 tag=TAG20080321T145751 comment=NONE

channel c1: backup set complete, elapsed time: 00:00:03

channel c1: deleting archive log(s)

archive log filename=/home/oracle/archive/1_385_640546001.arc recid=1808 stamp=649954597

archive log filename=/home/oracle/archive/1_386_640546001.arc recid=1811 stamp=649954670

channel c2: finished piece 1 at 21-MAR-08

piece handle=+BACKUP/baan/backupset/2008_03_21/annnf0_tag20080321t145751_0.273.649954675 tag=TAG20080321T145751 comment=NONE

channel c2: backup set complete, elapsed time: 00:05:19

channel c2: deleting archive log(s)

archive log filename=/home/oracle/archive/2_212_640546001.arc recid=1388 stamp=643726675

archive log filename=/home/oracle/archive/2_213_640546001.arc recid=1389 stamp=643727323

archive log filename=/home/oracle/archive/2_214_640546001.arc recid=1391 stamp=643727824

archive log filename=/home/oracle/archive/2_215_640546001.arc recid=1392 stamp=643728326

archive log filename=/home/oracle/archive/2_216_640546001.arc recid=1393 stamp=643728836

archive log filename=/home/oracle/archive/2_217_640546001.arc recid=1395 stamp=643729304

archive log filename=/home/oracle/archive/2_218_640546001.arc recid=1396 stamp=643729580

archive log filename=/home/oracle/archive/2_219_640546001.arc recid=1397 stamp=643730043

archive log filename=/home/oracle/archive/2_220_640546001.arc recid=1399 stamp=643730527

archive log filename=/home/oracle/archive/2_221_640546001.arc recid=1400 stamp=643730960

archive log filename=/home/oracle/archive/2_222_640546001.arc recid=1401 stamp=643731342