Chinaunix

标题: 掉电后小机重启后数据库备份出了问题，大虾救命啊？ [打印本页]

作者: renda 时间: 2007-01-11 01:37
标题: 掉电后小机重启后数据库备份出了问题，大虾救命啊？
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 时间: 2007-01-11 22:46
这么多，看的有点晕。。。
你最近有什么改动··

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 时间: 2007-01-12 13:26
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 时间: 2007-01-12 15:41
检查/archive/arc_2_795.arc
是否存在.
如果不存在，使用crosscheck archivelog all;
校验archivelog.

作者: renda 时间: 2007-01-14 10:55
标题: 回复 2楼 chinadns 的帖子
你好，我用什么命令来检查能否访问2号机的归档卷呢？

作者: herowangzj 时间: 2007-01-15 09:42
通常做法2号机的归档日志通过NFS共享到1号机,TSM只在1号机上备份就可以了.

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)