掉电后小机重启后数据库备份出了问题，大虾救命啊？

renda

12月22日以前备份的情况是这样的。（正常不报错）

1．查看数据库oracle是否备份成功
登陆10.117.202.8  
Cd  /u01/rman/  

使用命令查看用命令：cat fullbackup.log 如下为正确

Recovery Manager: Release 9.2.0.4.0 - 64bit Production

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

connected to target database: RAC (DBID=2163719603)

RMAN> run{
2> allocate channel t1 type 'sbt_tape' parms 'ENV=(tdpo_optfile=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)' connect 'sys/change_o
n_install@rac1';
3> backup full tag 'dbfull' format 'dbfull_%t_%s_%p' diskratio=0 database include current controlfile;
4> sql 'alter system archive log current';
5> backup format 'arch%t_%s_%p' diskratio=0 archivelog all delete input;  
6> release channel t1;
7> crosscheck backup;
8> report obsolete;
9> delete noprompt obsolete;
10> }
11>
using target database controlfile instead of recovery catalog
allocated channel: t1
channel t1: sid=17 devtype=SBT_TAPE
channel t1: Tivoli Data Protection for Oracle: version 5.2.0.0

Starting backup at 13-SEP-06
channel t1: starting full datafile backupset
channel t1: specifying datafile(s) in backupset
including current SPFILE in backupset
including current controlfile in backupset
input datafile fno=00006 name=/dev/rrac_data_20g_01
input datafile fno=00007 name=/dev/rrac_data_20g_02
input datafile fno=00008 name=/dev/rrac_data_20g_03
input datafile fno=00009 name=/dev/rrac_data_20g_04
input datafile fno=00010 name=/dev/rrac_data_20g_05
input datafile fno=00011 name=/dev/rrac_index_20g_0
input datafile fno=00012 name=/dev/rrac_index_20g_1
input datafile fno=00001 name=/dev/rrac_system01
input datafile fno=00002 name=/dev/rrac_undo01
input datafile fno=00004 name=/dev/rrac_undo02
input datafile fno=00003 name=/dev/rrac_tools
input datafile fno=00005 name=/dev/rrac_users
channel t1: starting piece 1 at 13-SEP-06
channel t1: finished piece 1 at 13-SEP-06
piece handle=dbfull_601075967_58_1 comment=API Version 2.0,MMS Version 5.2.0.0
channel t1: backup set complete, elapsed time: 00:15:07
Finished backup at 13-SEP-06

sql statement: alter system archive log current

Starting backup at 13-SEP-06
current log archived
channel t1: starting archive log backupset
channel t1: specifying archive log(s) in backup set
input archive log thread=1 sequence=416 recid=812 stamp=599656473
i4
input archive log thread=2 sequence=424 recid=862 stamp=601076875
input archive log thread=2 sequence=425 recid=864 stamp=601076875
channel t1: starting piece 1 at 13-SEP-06
channel t1: finished piece 1 at 13-SEP-06
piece handle=arch601076876_59_1 comment=API Version 2.0,MMS Version 5.2.0.0
channel t1: backup set complete, elapsed time: 00:01:16
channel t1: deleting archive log(s)
archive log filename=/archive/arc_1_416.arc recid=812 stamp=599656473
archive log filename=/archive/arc_2_424.arc recid=862 stamp=601076875
archive log filename=/archive/arc_2_425.arc recid=864 stamp=601076875
Finished backup at 13-SEP-06
released channel: t1
allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: sid=31 devtype=SBT_TAPE
channel ORA_SBT_TAPE_1: Tivoli Data Protection for Oracle: version 5.2.0.0
allocated channel: ORA_SBT_TAPE_2
channel ORA_SBT_TAPE_2: sid=40 devtype=SBT_TAPE
channel ORA_SBT_TAPE_2: Tivoli Data Protection for Oracle: version 5.2.0.0
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=34 devtype=DISK
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=dbfull_601074289_57_1 recid=47 stamp=601074291
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=dbfull_601075967_58_1 recid=48 stamp=601075969
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=arch601076876_59_1 recid=49 stamp=601076877
Crosschecked 3 objects

crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=arch575894130_18_1 recid=15 stamp=575894131
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=arch575894684_24_1 recid=20 stamp=575894685
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=arch575896692_28_1 recid=24 stamp=575896693
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=arch575909933_33_1 recid=29 stamp=575909934
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=arch575922302_38_1 recid=35 stamp=575922303
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=arch575939236_43_1 recid=39 stamp=575939237
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=arch576025531_48_1 recid=45 stamp=576025532
Crosschecked 7 objects
RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 7 days
using channel ORA_SBT_TAPE_1
using channel ORA_SBT_TAPE_2
using channel ORA_DISK_1
no obsolete backups found

Recovery Manager complete.
[xxzx_p550_1]/u01/rman$
备份失败的话有如下信息
RMAN-00571: ===========================================================
RMAN-00569: === ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "identifier": expecting one of: "allocate, alter, backup, spool, startup, shutdown, send, show, test, upgrade, validate"
RMAN-01008: the bad identifier was: kds
RMAN-01007: at line 1 column 1 file: standard input



另外一种查看备份是否成功的方法
[xxzx_p550_1] #su - oracle
[xxzx_p550_1]/u01$rman target /

Recovery Manager: Release 9.2.0.4.0 - 64bit Production

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

connected to target database: RAC (DBID=2163719603)

RMAN> list backup summary;

using target database controlfile instead of recovery catalog

List of Backups
===============
Key     TY LV S Device Type Completion Time #Pieces #Copies Tag
------- -- -- - ----------- --------------- ------- ------- ---
15      B  A  X SBT_TAPE    01-DEC-05       1       1       TAG20051201T103534
20      B  A  X SBT_TAPE    01-DEC-05       1       1       TAG20051201T104448
24      B  A  X SBT_TAPE    01-DEC-05       1       1       TAG20051201T111817
29      B  A  X SBT_TAPE    01-DEC-05       1       1       TAG20051201T145858
35      B  A  X SBT_TAPE    01-DEC-05       1       1       TAG20051201T182507
39      B  A  X SBT_TAPE    01-DEC-05       1       1       TAG20051201T230721
45      B  A  X SBT_TAPE    02-DEC-05       1       1       TAG20051202T230536
47      B  F  A SBT_TAPE    13-SEP-06       1       1       DBFULL
48      B  F  A SBT_TAPE    13-SEP-06       1       1       DBFULL
49      B  A  A SBT_TAPE    13-SEP-06       1       1       TAG20060913T214755
50      B  F  A SBT_TAPE    13-SEP-06       1       1       DBFULL
51      B  F  A SBT_TAPE    14-SEP-06       1       1       DBFULL
52      B  A  A SBT_TAPE    14-SEP-06       1       1       TAG20060914T091441
53      B  F  A SBT_TAPE    14-SEP-06       1       1       DBFULL
54      B  A  A SBT_TAPE    14-SEP-06       1       1       TAG20060914T101531
55      B  F  A SBT_TAPE    14-SEP-06       1       1       DBFULL
56      B  F  A SBT_TAPE    14-SEP-06       1       1       DBFULL
57      B  F  A SBT_TAPE    14-SEP-06       1       1       DBFULL
58      B  F  A SBT_TAPE    14-SEP-06       1       1       DBFULL
59      B  A  A SBT_TAPE    14-SEP-06       1       1       TAG20060914T121059

可以看Completion Time 时间，例如14-SEP-06就是9月14日备份过了，而且成功了。

如何修改备份的时间：
登陆到10.117.202.8
执行命令crontab –e 通过vi修改最后一行。语法结构为
第一列代表分，第二列代表时，第三列代表日，第四列代表月，第五列代表周，*代表全部

下面的例子就是 每月每日每天每周 23点执行oracle_fullbackup.sh 这个脚本就是备份oracle的命令。

[xxzx_p550_1]/#crontab -l
0 23 * * * /u01/rman/oracle_fullbackup.sh 1>/dev/null 2>/dev/null #backup oracle full everyday
[xxzx_p550_1]/#


*****而现在备份出现问题并且出现了报错信息 (我今天执行了多次fullbackup 脚本但状态和原来不一样了，数据全部备了，而rac2 报错啊)****

RMAN> list backup summary;

using target database controlfile instead of recovery catalog

List of Backups
===============
Key     TY LV S Device Type Completion Time #Pieces #Copies Tag
------- -- -- - ----------- --------------- ------- ------- ---
428     B  F  A SBT_TAPE    02-JAN-07       1       1       DBFULL
429     B  F  A SBT_TAPE    03-JAN-07       1       1       DBFULL
430     B  F  A SBT_TAPE    04-JAN-07       1       1       DBFULL
431     B  F  A SBT_TAPE    05-JAN-07       1       1       DBFULL
432     B  A  A SBT_TAPE    05-JAN-07       1       1       TAG20070105T231642
433     B  F  A SBT_TAPE    05-JAN-07       1       1      
434     B  F  A SBT_TAPE    06-JAN-07       1       1       DBFULL
435     B  F  A SBT_TAPE    07-JAN-07       1       1       DBFULL
436     B  F  A SBT_TAPE    08-JAN-07       1       1       DBFULL
437     B  F  A SBT_TAPE    09-JAN-07       1       1       DBFULL
438     B  A  A SBT_TAPE    10-JAN-07       1       1       TAG20070110T152532
439     B  A  A SBT_TAPE    10-JAN-07       1       1       TAG20070110T152532
440     B  A  A SBT_TAPE    10-JAN-07       1       1       TAG20070110T152532
441     B  F  A SBT_TAPE    10-JAN-07       1       1      
442     B  F  A SBT_TAPE    10-JAN-07       1       1       DBFULL

RMAN> list backup             k list bakupset ?

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "identifier": expecting one of: "archivelog, backup, backuppiece, backupset, backed, completed, copy, controlfilecopy, datafilecopy, device, expired, incarnation, like, proxy, recoverable, tag"
RMAN-01008: the bad identifier was: bakupset
RMAN-01007: at line 1 column 6 file: standard input
***脚本执行后错误

run{
2> crosscheck archivelog all;
3> allocate channel t1 type 'sbt_tape' parms 'ENV=(tdpo_optfile=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)' connect 'sys/change_on_install@rac1';
4> backup full tag 'da bfull' forman t 'dbfull_%t% _%s_%p' diskratio=0 database include current controlfile;
5> backup format 'arch%t_%s_%p' diskratio=0 archivelog all delete input;
6> release channel t1;
7> crosscheck backup;
8> report obsolete;
9> delete noprompt obsolete;
10> }

allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=26 devtype=DISK
validation failed for archived log
archive log filename=/archive/arc_2_779.arc recid=1459 stamp=610499698
validation failed for archived log
archive log filename=/archive/arc_2_780.arc recid=1463 stamp=610541313
validation failed for archived log
archive log filename=/archive/arc_2_781.arc recid=1465 stamp=610562597
validation failed for archived log
archive log filename=/archive/arc_2_782.arc recid=1467 stamp=610622618
validation failed for archived log
archive log filename=/archive/arc_2_783.arc recid=1470 stamp=610672520
validation failed for archived log
archive log filename=/archive/arc_2_784.arc recid=1473 stamp=610758949
validation failed for archived log
archive log filename=/archive/arc_2_785.arc recid=1476 stamp=610845310
validation failed for archived log
archive log filename=/archive/arc_2_786.arc recid=1479 stamp=610931750
validation failed for archived log
archive log filename=/archive/arc_2_787.arc recid=1482 stamp=611018110
validation failed for archived log
archive log filename=/archive/arc_2_789.arc recid=1489 stamp=611190918
validation failed for archived log
archive log filename=/archive/arc_2_790.arc recid=1492 stamp=611277349
validation failed for archived log
archive log filename=/archive/arc_2_791.arc recid=1494 stamp=611363719
validation failed for archived log
archive log filename=/archive/arc_2_792.arc recid=1497 stamp=611450347
Crosschecked 13 objects


released channel: ORA_DISK_1
allocated channel: t1
channel t1: sid=42 devtype=SBT_TAPE
channel t1: Tivoli Data Protection for Oracle: version 5.2.0.0

Starting backup at 10-JAN-07
channel t1: starting full datafile backupset
channel t1: specifying datafile(s) in backupset
including current controlfile in backupset
input datafile fno=00006 name=/dev/rrac_data_20g_01
input datafile fno=00007 name=/dev/rrac_data_20g_02
input datafile fno=00008 name=/dev/rrac_data_20g_03
input datafile fno=00009 name=/dev/rrac_data_20g_04
input datafile fno=00010 name=/dev/rrac_data_20g_05
input datafile fno=00011 name=/dev/rrac_index_20g_0
input datafile fno=00012 name=/dev/rrac_index_20g_1
input datafile fno=00001 name=/dev/rrac_system01
input datafile fno=00002 name=/dev/rrac_undo01
input datafile fno=00004 name=/dev/rrac_undo02
input datafile fno=00003 name=/dev/rrac_tools
input datafile fno=00005 name=/dev/rrac_users
channel t1: starting piece 1 at 10-JAN-07
channel t1: finished piece 1 at 10-JAN-07
piece handle=dbfull_611508964_469_1 comment=API Version 2.0,MMS Version 5.2.0.0
channel t1: backup set complete, elapsed time: 00:16:13
Finished backup at 10-JAN-07

Starting backup at 10-JAN-07
current log archived
released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 01/10/2007 15:52:28
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file /archive/arc_2_795.arc
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: A file or directory in the path name does not exist.
Additional information: 3

MAN> list backupset;


List of Backup Sets
===================

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
428     Full    25G        SBT_TAPE    00:15:47     02-JAN-07      
        BP Key: 428   Status: AVAILABLE   Tag: DBFULL
        Piece Name: dbfull_610844403_451_1
  Controlfile Included: Ckp SCN: 51969413     Ckp time: 02-JAN-07
  List of Datafiles in backup set 428
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 51969414   02-JAN-07 /dev/rrac_system01
  2       Full 51969414   02-JAN-07 /dev/rrac_undo01
  3       Full 51969414   02-JAN-07 /dev/rrac_tools
  4       Full 51969414   02-JAN-07 /dev/rrac_undo02
  5       Full 51969414   02-JAN-07 /dev/rrac_users
  6       Full 51969414   02-JAN-07 /dev/rrac_data_20g_01
  7       Full 51969414   02-JAN-07 /dev/rrac_data_20g_02
  8       Full 51969414   02-JAN-07 /dev/rrac_data_20g_03
  9       Full 51969414   02-JAN-07 /dev/rrac_data_20g_04
  10      Full 51969414   02-JAN-07 /dev/rrac_data_20g_05
  11      Full 51969414   02-JAN-07 /dev/rrac_index_20g_0
  12      Full 51969414   02-JAN-07 /dev/rrac_index_20g_1

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
429     Full    26G        SBT_TAPE    00:16:35     03-JAN-07      
        BP Key: 429   Status: AVAILABLE   Tag: DBFULL
        Piece Name: dbfull_610930802_452_1
  Controlfile Included: Ckp SCN: 52239364     Ckp time: 03-JAN-07
  List of Datafiles in backup set 429
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 52239366   03-JAN-07 /dev/rrac_system01
  2       Full 52239366   03-JAN-07 /dev/rrac_undo01
  3       Full 52239366   03-JAN-07 /dev/rrac_tools
  4       Full 52239366   03-JAN-07 /dev/rrac_undo02
  5       Full 52239366   03-JAN-07 /dev/rrac_users
  6       Full 52239366   03-JAN-07 /dev/rrac_data_20g_01
  7       Full 52239366   03-JAN-07 /dev/rrac_data_20g_02
  8       Full 52239366   03-JAN-07 /dev/rrac_data_20g_03
  9       Full 52239366   03-JAN-07 /dev/rrac_data_20g_04
  10      Full 52239366   03-JAN-07 /dev/rrac_data_20g_05
  11      Full 52239366   03-JAN-07 /dev/rrac_index_20g_0
  12      Full 52239366   03-JAN-07 /dev/rrac_index_20g_1

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
430     Full    26G        SBT_TAPE    00:15:49     04-JAN-07      
        BP Key: 430   Status: AVAILABLE   Tag: DBFULL
        Piece Name: dbfull_611017202_453_1
  Controlfile Included: Ckp SCN: 52534745     Ckp time: 04-JAN-07
  List of Datafiles in backup set 430
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 52534748   04-JAN-07 /dev/rrac_system01
  2       Full 52534748   04-JAN-07 /dev/rrac_undo01
  3       Full 52534748   04-JAN-07 /dev/rrac_tools
  4       Full 52534748   04-JAN-07 /dev/rrac_undo02
  5       Full 52534748   04-JAN-07 /dev/rrac_users
  6       Full 52534748   04-JAN-07 /dev/rrac_data_20g_01
  7       Full 52534748   04-JAN-07 /dev/rrac_data_20g_02
  8       Full 52534748   04-JAN-07 /dev/rrac_data_20g_03
  9       Full 52534748   04-JAN-07 /dev/rrac_data_20g_04
  10      Full 52534748   04-JAN-07 /dev/rrac_data_20g_05
  11      Full 52534748   04-JAN-07 /dev/rrac_index_20g_0
  12      Full 52534748   04-JAN-07 /dev/rrac_index_20g_1

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
431     Full    26G        SBT_TAPE    00:16:33     05-JAN-07      
        BP Key: 431   Status: AVAILABLE   Tag: DBFULL
        Piece Name: dbfull_611103603_454_1
  Controlfile Included: Ckp SCN: 52703073     Ckp time: 05-JAN-07
  List of Datafiles in backup set 431
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 52703075   05-JAN-07 /dev/rrac_system01
  2       Full 52703075   05-JAN-07 /dev/rrac_undo01
  3       Full 52703075   05-JAN-07 /dev/rrac_tools
  4       Full 52703075   05-JAN-07 /dev/rrac_undo02
  5       Full 52703075   05-JAN-07 /dev/rrac_users
  6       Full 52703075   05-JAN-07 /dev/rrac_data_20g_01
  7       Full 52703075   05-JAN-07 /dev/rrac_data_20g_02
  8       Full 52703075   05-JAN-07 /dev/rrac_data_20g_03
  9       Full 52703075   05-JAN-07 /dev/rrac_data_20g_04
  10      Full 52703075   05-JAN-07 /dev/rrac_data_20g_05
  11      Full 52703075   05-JAN-07 /dev/rrac_index_20g_0
  12      Full 52703075   05-JAN-07 /dev/rrac_index_20g_1

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------

chinadns

这么多，看的有点晕。。。
你最近有什么改动··

ORA-19625: error identifying file /archive/arc_2_795.arc
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: A file or directory in the path name does not exist.

你的1机能访问到2机得归档日志么？

football2006

run
{
allocate channel t1 device type 'sbt' parms
'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
backup database;
backup archivelog all delete input;
}

你手工运行上面的脚本看看行不行？你以前用的脚本都正常吗？

mayu

检查/archive/arc_2_795.arc
是否存在.
如果不存在，使用crosscheck archivelog all;
校验archivelog.

renda

你好，我用什么命令来检查能否访问2号机的归档卷呢？

herowangzj

通常做法2号机的归档日志通过NFS共享到1号机,TSM只在1号机上备份就可以了.