- 论坛徽章:
- 0
|
那位大侠能帮帮我，我的用户P550双机+Hacmp+Oracle 9i +磁盘柜DS4500+TSM ，由于前两天停电，系统每天备份 Oracle 数据库,rman 脚本完成，但是现在出现备份问题，TSM调度进程都有，小弟把windows SQL备份的问题解决了，但oracle 的备份没有搞定，小弟急的都病了，那位大侠能帮助解决。多谢了。
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> 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 'dbfull' format '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> }
11>
using target database controlfile instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=29 devtype=DISK
validation succeeded for archived log
archive log filename=/archive/arc_1_660.arc recid=1427 stamp=609845587
validation succeeded for archived log
archive log filename=/archive/arc_1_661.arc recid=1429 stamp=609861314
validation succeeded for archived log
archive log filename=/archive/arc_1_662.arc recid=1431 stamp=609894980
validation succeeded for archived log
archive log filename=/archive/arc_1_663.arc recid=1432 stamp=609969888
validation succeeded for archived log
archive log filename=/archive/arc_1_664.arc recid=1434 stamp=609981406
validation succeeded for archived log
archive log filename=/archive/arc_1_665.arc recid=1435 stamp=610032960
validation succeeded for archived log
archive log filename=/archive/arc_1_666.arc recid=1437 stamp=610067764
validation succeeded for archived log
archive log filename=/archive/arc_1_667.arc recid=1438 stamp=610109367
validation succeeded for archived log
archive log filename=/archive/arc_1_668.arc recid=1439 stamp=610123977
validation succeeded for archived log
archive log filename=/archive/arc_1_669.arc recid=1441 stamp=610154192
validation succeeded for archived log
archive log filename=/archive/arc_1_670.arc recid=1442 stamp=610212901
validation succeeded for archived log
archive log filename=/archive/arc_1_671.arc recid=1443 stamp=610215779
validation succeeded for archived log
archive log filename=/archive/arc_1_672.arc recid=1445 stamp=610239243
validation succeeded for archived log
archive log filename=/archive/arc_1_673.arc recid=1447 stamp=610240590
validation succeeded for archived log
archive log filename=/archive/arc_1_674.arc recid=1448 stamp=610278681
validation succeeded for archived log
archive log filename=/archive/arc_1_675.arc recid=1450 stamp=610279676
validation succeeded for archived log
archive log filename=/archive/arc_1_676.arc recid=1451 stamp=610280649
validation succeeded for archived log
archive log filename=/archive/arc_1_677.arc recid=1452 stamp=610292472
validation succeeded for archived log
archive log filename=/archive/arc_1_678.arc recid=1454 stamp=610327051
validation succeeded for archived log
archive log filename=/archive/arc_1_679.arc recid=1455 stamp=610384930
validation failed for archived log
archive log filename=/archive/arc_2_769.arc recid=1428 stamp=609861244
validation failed for archived log
archive log filename=/archive/arc_2_770.arc recid=1430 stamp=609894917
validation failed for archived log
archive log filename=/archive/arc_2_771.arc recid=1433 stamp=609981349
validation failed for archived log
archive log filename=/archive/arc_2_772.arc recid=1436 stamp=610067711
validation failed for archived log
archive log filename=/archive/arc_2_773.arc recid=1440 stamp=610154130
validation failed for archived log
archive log filename=/archive/arc_2_774.arc recid=1444 stamp=610239172
validation failed for archived log
archive log filename=/archive/arc_2_775.arc recid=1446 stamp=610240538
validation failed for archived log
archive log filename=/archive/arc_2_776.arc recid=1449 stamp=610279603
validation failed for archived log
archive log filename=/archive/arc_2_777.arc recid=1453 stamp=610326989
Crosschecked 29 objects
released channel: ORA_DISK_1
allocated channel: t1
channel t1: sid=41 devtype=SBT_TAPE
channel t1: Tivoli Data Protection for Oracle: version 5.2.0.0
Starting backup at 28-DEC-06
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 28-DEC-06
channel t1: finished piece 1 at 28-DEC-06
piece handle=dbfull_610412402_446_1 comment=API Version 2.0,MMS Version 5.2.0.0
channel t1: backup set complete, elapsed time: 00:16:26
Finished backup at 28-DEC-06
Starting backup at 28-DEC-06
current log archived
released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 12/28/2006 23:16:50
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file /archive/arc_2_778.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
Recovery Manager complete. |
|
免费注册
发表于 2007-01-02 20:20
