- 论坛徽章:
- 0
|
****一号机文档信息*******
xxzx_p550_1]/archive#mount
node mounted mounted over vfs date options
-------- --------------- --------------- ------ ------------ ---------------
/dev/hd4 / jfs2 Jan 11 22:35 rw,log=/dev/hd8
/dev/hd2 /usr jfs2 Jan 11 22:35 rw,log=/dev/hd8
/dev/hd9var /var jfs2 Jan 11 22:35 rw,log=/dev/hd8
/dev/hd3 /tmp jfs2 Jan 11 22:35 rw,log=/dev/hd8
/dev/fwdump /var/adm/ras/platform jfs2 Jan 11 22:35 rw,log=/dev/hd8
/dev/hd1 /home jfs2 Jan 11 22:36 rw,log=/dev/hd8
/proc /proc procfs Jan 11 22:36 rw
/dev/hd10opt /opt jfs2 Jan 11 22:36 rw,log=/dev/hd8
/dev/lv00 /var/adm/csd jfs Jan 11 22:36 rw,log=/dev/loglv00
/dev/fslv00 /u01 jfs2 Jan 11 22:36 rw,log=/dev/hd8
/dev/lvarchive /archive jfs2 Jan 11 22:36 rw,log=/dev/hd8
[xxzx_p550_1]/archive#lsfs
Name Nodename Mount Pt VFS Size Options Auto Accounting
/dev/hd4 -- / jfs2 1048576 -- yes no
/dev/hd1 -- /home jfs2 262144 -- yes no
/dev/hd2 -- /usr jfs2 9699328 -- yes no
/dev/hd9var -- /var jfs2 2097152 -- yes no
/dev/hd3 -- /tmp jfs2 3145728 -- yes no
/proc -- /proc procfs -- -- yes no
/dev/hd10opt -- /opt jfs2 3407872 -- yes no
/dev/fwdump -- /var/adm/ras/platform jfs2 1835008 -- no no
/dev/lv00 -- /var/adm/csd jfs 262144 -- yes no
/dev/cd0 -- /cdrom cdrfs -- ro no no
/dev/fslv00 -- /u01 jfs2 16515072 rw yes no
/dev/lvarchive -- /archive jfs2 10485760 rw yes no
/dev/fslv01 -- /dumpcopy jfs2 2097152 rw no no
[xxzx_p550_1]/archive#df -
Filesystem 512-blocks Free %Used Iused %Iused Mounted on
/dev/hd4 1048576 795256 25% 2568 3% /
/dev/hd2 9699328 4418560 55% 66914 12% /usr
/dev/hd9var 2097152 1636224 22% 891 1% /var
/dev/hd3 3145728 2743328 13% 483 1% /tmp
/dev/fwdump 1835008 1834072 1% 4 1% /var/adm/ras/platform
/dev/hd1 262144 261328 1% 10 1% /home
/proc - - - - - /proc
/dev/hd10opt 3407872 1919864 44% 17216 8% /opt
/dev/lv00 262144 253824 4% 18 1% /var/adm/csd
/dev/fslv00 16515072 6554904 61% 31711 5% /u01
/dev/lvarchive 10485760 9936552 6%
[xxzx_p550_1]/archive#ls -l
total 546912
-rw-r----- 1 oracle dba 1859584 Jan 10 15:52 arc_1_711.arc
-rw-r----- 1 oracle dba 12230656 Jan 10 23:16 arc_1_712.arc
-rw-r----- 1 oracle dba 134217216 Jan 11 14:31 arc_1_713.arc
-rw-r----- 1 oracle dba 131293696 Jan 11 22:40 arc_1_714.arc
-rw-r----- 1 oracle dba 374784 Jan 11 23:16 arc_1_715.arc
drwxr-xr-x 2 root system 256 Nov 30 2005 lost+found
****二号机文档信息*******
[xxzx_p550_2]/#mount
node mounted mounted over vfs date options
-------- --------------- --------------- ------ ------------ ---------------
/dev/hd4 / jfs2 Jan 11 22:34 rw,log=/dev/hd8
/dev/hd2 /usr jfs2 Jan 11 22:34 rw,log=/dev/hd8
/dev/hd9var /var jfs2 Jan 11 22:34 rw,log=/dev/hd8
/dev/hd3 /tmp jfs2 Jan 11 22:34 rw,log=/dev/hd8
/dev/fwdump /var/adm/ras/platform jfs2 Jan 11 22:35 rw,log=/dev/hd8
/dev/hd1 /home jfs2 Jan 11 22:35 rw,log=/dev/hd8
/proc /proc procfs Jan 11 22:35 rw
/dev/hd10opt /opt jfs2 Jan 11 22:35 rw,log=/dev/hd8
/dev/lv00 /var/adm/csd jfs Jan 11 22:35 rw,log=/dev/loglv00
/dev/fslv00 /u01 jfs2 Jan 11 22:35 rw,log=/dev/hd8
/dev/lvarchive /archive jfs2 Jan 11 22:35 rw,log=/dev/hd8
[xxzx_p550_2]/#lsfs
Name Nodename Mount Pt VFS Size Options Auto Accounting
/dev/hd4 -- / jfs2 1048576 -- yes no
/dev/hd1 -- /home jfs2 262144 -- yes no
/dev/hd2 -- /usr jfs2 9961472 -- yes no
/dev/hd9var -- /var jfs2 2097152 -- yes no
/dev/hd3 -- /tmp jfs2 2097152 -- yes no
/proc -- /proc procfs -- -- yes no
/dev/hd10opt -- /opt jfs2 524288 -- yes no
/dev/fwdump -- /var/adm/ras/platform jfs2 1835008 -- no no
/dev/lv00 -- /var/adm/csd jfs 262144 -- yes no
/dev/cd0 -- /cdrom cdrfs -- ro no no
/dev/fslv00 -- /u01 jfs2 16515072 rw yes no
/dev/lvarchive -- /archive jfs2 10485760 rw yes no
/dev/fslv01 -- /dumpcopy jfs2 2097152 rw no no
*****这里的文档没有被整理
[xxzx_p550_2]/#cd archive
[xxzx_p550_2]/archive#ls -l
total 270416
-rw-r----- 1 oracle dba 1375744 Dec 22 13:54 arc_2_769.arc
-rw-r----- 1 oracle dba 2884096 Dec 22 23:15 arc_2_770.arc
-rw-r----- 1 oracle dba 7398400 Dec 23 23:15 arc_2_771.arc
-rw-r----- 1 oracle dba 7393792 Dec 24 23:15 arc_2_772.arc
-rw-r----- 1 oracle dba 7394816 Dec 25 23:15 arc_2_773.arc
-rw-r----- 1 oracle dba 7280128 Dec 26 22:52 arc_2_774.arc
-rw-r----- 1 oracle dba 117248 Dec 26 23:15 arc_2_775.arc
-rw-r----- 1 oracle dba 3349504 Dec 27 10:06 arc_2_776.arc
-rw-r----- 1 oracle dba 4056064 Dec 27 23:16 arc_2_777.arc
-rw-r----- 1 oracle dba 7392256 Dec 28 23:15 arc_2_778.arc
-rw-r----- 1 oracle dba 7388160 Dec 29 23:14 arc_2_779.arc
-rw-r----- 1 oracle dba 3462144 Dec 30 10:48 arc_2_780.arc
-rw-r----- 1 oracle dba 1802240 Dec 30 16:43 arc_2_781.arc
-rw-r----- 1 oracle dba 5174272 Dec 31 09:23 arc_2_782.arc
-rw-r----- 1 oracle dba 4267520 Dec 31 23:15 arc_2_783.arc
-rw-r----- 1 oracle dba 7399424 Jan 01 23:15 arc_2_784.arc
-rw-r----- 1 oracle dba 7391232 Jan 02 23:15 arc_2_785.arc
-rw-r----- 1 oracle dba 7401472 Jan 03 23:15 arc_2_786.arc
-rw-r----- 1 oracle dba 7393792 Jan 04 23:15 arc_2_787.arc
-rw-r----- 1 oracle dba 7394304 Jan 06 23:15 arc_2_789.arc
-rw-r----- 1 oracle dba 7405056 Jan 07 23:15 arc_2_790.arc
-rw-r----- 1 oracle dba 7397888 Jan 08 23:15 arc_2_791.arc
-rw-r----- 1 oracle dba 7427584 Jan 09 23:19 arc_2_792.arc
-rw-r----- 1 oracle dba 138240 Jan 10 15:51 arc_2_795.arc
-rw-r----- 1 oracle dba 2277376 Jan 10 23:15 arc_2_796.arc
-rw-r----- 1 oracle dba 5743616 Jan 11 22:40 arc_2_797.arc
-rw-r----- 1 oracle dba 220672 Jan 11 23:15 arc_2_798.arc
drwxr-xr-x 2 root system 256 Nov 30 2005 lost+found
*******备份错误日志*******
[xxzx_p550_1]/u01/rman#cat fullbackup.lg og
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=21 devtype=DISK
validation succeeded for archived log
archive log filename=/archive/arc_1_711.arc recid=1505 stamp=611509941
validation succeeded for archived log
archive log filename=/archive/arc_1_712.arc recid=1506 stamp=611536590
validation succeeded for archived log
archive log filename=/archive/arc_1_713.arc recid=1508 stamp=611591504
validation succeeded for archived log
archive log filename=/archive/arc_1_714.arc recid=1509 stamp=611620825
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
validation failed for archived log
archive log filename=/archive/arc_2_795.arc recid=1504 stamp=611509886
validation failed for archived log
archive log filename=/archive/arc_2_796.arc recid=1507 stamp=611536537
validation failed for archived log
archive log filename=/archive/arc_2_797.arc recid=1510 stamp=611620808
Crosschecked 20 objects
released channel: ORA_DISK_1
allocated channel: t1
channel t1: sid=22 devtype=SBT_TAPE
channel t1: Tivoli Data Protection for Oracle: version 5.2.0.0
Starting backup at 11-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 11-JAN-07
channel t1: finished piece 1 at 11-JAN-07
piece handle=dbfull_611622010_471_1 comment=API Version 2.0,MMS Version 5.2.0.0
channel t1: backup set complete, elapsed time: 00:16:36
Finished backup at 11-JAN-07
Starting backup at 11-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/11/2007 23:16:56
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file /archive/arc_2_798.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
[xxzx_p550_1]/u01/rman#crontab -l
# @(#)08 1.15.1.3 src/bos/usr/sbin/cron/root, cmdcntl, bos530 2/11/94 17:19:47
# IBM_PROLOG_BEGIN_TAG
# This is an automatically generated prolog.
#
# bos530 src/bos/usr/sbin/cron/root 1.15.1.3
#
# Licensed Materials - Property of IBM
#
# (C) COPYRIGHT International Business Machines Corp. 1989,1994
# All Rights Reserved
#
# US Government Users Restricted Rights - Use, duplication or
# disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
#
# IBM_PROLOG_END_TAG
#
# COMPONENT_NAME: (CMDCNTL) commands needed for basic system needs
#
# FUNCTIONS:
#
# ORIGINS: 27
#
# (C) COPYRIGHT International Business Machines Corp. 1989,1994
# All Rights Reserved
# Licensed Materials - Property of IBM
#
# US Government Users Restricted Rights - Use, duplication or
# disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
#
#0 3 * * * /usr/sbin/skulker
#45 2 * * 0 /usr/lib/spell/compress
#45 23 * * * ulimit 5000; /usr/lib/smdemon.cleanu > /dev/null
0 11 * * * /usr/bin/errclear -d S,O 30
0 12 * * * /usr/bin/errclear -d H 90
0 15 * * * /usr/lib/ras/dumpcheck >/dev/null 2>&1
# SSA warning : Deleting the next two lines may cause errors in redundant
# SSA warning : hardware to go undetected.
01 5 * * * /usr/lpp/diagnostics/bin/run_ssa_ela 1>/dev/null 2>/dev/null
0 * * * * /usr/lpp/diagnostics/bin/run_ssa_healthcheck 1>/dev/null 2>/dev/null
# SSA warning : Deleting the next line may allow enclosure hardware errors to go undetected
30 * * * * /usr/lpp/diagnostics/bin/run_ssa_encl_healthcheck 1>/dev/null 2>/dev/null
# SSA warning : Deleting the next line may allow link speed exceptions to go undetected
30 4 * * * /usr/lpp/diagnostics/bin/run_ssa_link_speed 1>/dev/null 2>/dev/null
0 0 * * * /usr/es/sbin/cluster/utilities/clcycle 1>/dev/null 2>/dev/null # HACMP for AIX Logfile rotation
00 23 * * * /u01/rman/oracle_fullbackup.sh 1>/dev/null 2>/dev/null #backup oracle full everyday
rman 下fullbackup脚本内容：
run{
crosscheck archivelog all;
allocate channel t1 type 'sbt_tape' parms 'ENV=(tdpo_optfile=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)' connect 'sys/change_on_install@rac1';
backup full tag 'dbfull' format 'dbfull_%t_%s_%p' diskratio=0 database include current controlfile;
backup format 'arch%t_%s_%p' diskratio=0 archivelog all delete input;
release channel t1;
crosscheck backup;
report obsolete;
delete noprompt obsolete;
}
出错在二号机的归档信息上，每天它都要从22号开始或者那天执行以前的 archive log filename=/archive/arc_2_781.arc recid=1465 stamp=610562597
validation failed for archived log
就会报错，我直接手工删除可以吗？那位高手帮忙解决，这个问题快让我崩溃了。提前先谢谢您了。 |
|
免费注册
发表于 2007-01-14 07:57
