- 论坛徽章:
- 0
|
1.原来归档是都删的,但由于客户要配置DG所以让我把归档保留三天,通过脚本里加delete noprompt archivelog until time 'sysdate-3';来实现。
2.用户环境是Oracle10G RAC,数据文件放RAW里,归档分别放本地文件系统,OS是RHEL5.8
3.我是通过单节点放脚本备份,另一个节点只配置Default Application负责在通道二要备份归档时通过策略拉数据。
4.问题:当用all delete input时两边归档都删,当用保留三天归档的方式时放脚本的那个节点归档删了,但另一个节点归档不删。通过list archivelog all;查看发现在controlfile里的删记录里归档里是清除了,但在文件系统层面另一个节点没删。
5.以下放出备份脚本和.out文件,大家帮忙分析下问题出在哪儿。
备份脚本。
#!/bin/sh
# $Header: hot_database_backup.sh,v 1.2 2002/08/06 23:51:42 $
#
#bcpyrght
#***************************************************************************
#* $VRTScprght: Copyright 1993 - 2007 Symantec Corporation, All Rights Reserved $ *
#***************************************************************************
#ecpyrght
#
# ---------------------------------------------------------------------------
# hot_database_backup.sh
# ---------------------------------------------------------------------------
# This script uses Recovery Manager to take a hot (inconsistent) database
# backup. A hot backup is inconsistent because portions of the database are
# being modified and written to the disk while the backup is progressing.
# You must run your database in ARCHIVELOG mode to make hot backups. It is
# assumed that this script will be executed by user root. In order for RMAN
# to work properly we switch user (su -) to the oracle dba account before
# execution. If this script runs under a user account that has Oracle dba
# privilege, it will be executed using this user's account.
# ---------------------------------------------------------------------------
# ---------------------------------------------------------------------------
# Determine the user which is executing this script.
# ---------------------------------------------------------------------------
CUSER=`id |cut -d"(" -f2 | cut -d ")" -f1`
# ---------------------------------------------------------------------------
# Put output in <this file name>.out. Change as desired.
# Note: output directory requires write permission.
# ---------------------------------------------------------------------------
RMAN_LOG_FILE=${0}.out
# ---------------------------------------------------------------------------
# You may want to delete the output file so that backup information does
# not accumulate. If not, delete the following lines.
# ---------------------------------------------------------------------------
if [ -f "$RMAN_LOG_FILE" ]
then
rm -f "$RMAN_LOG_FILE"
fi
# -----------------------------------------------------------------
# Initialize the log file.
# -----------------------------------------------------------------
echo >> $RMAN_LOG_FILE
chmod 666 $RMAN_LOG_FILE
# ---------------------------------------------------------------------------
# Log the start of this script.
# ---------------------------------------------------------------------------
echo Script $0 >> $RMAN_LOG_FILE
echo ==== started on `date` ==== >> $RMAN_LOG_FILE
echo >> $RMAN_LOG_FILE
# ---------------------------------------------------------------------------
# Replace /db/oracle/product/ora81, below, with the Oracle home path.
# ---------------------------------------------------------------------------
ORACLE_HOME=/opt/ora10g/product/10.2.0/db_2
export ORACLE_HOME
# ---------------------------------------------------------------------------
# Replace ora81, below, with the Oracle SID of the target database.
# ---------------------------------------------------------------------------
ORACLE_SID=lhczdata2
export ORACLE_SID
# ---------------------------------------------------------------------------
# Replace ora81, below, with the Oracle DBA user id (account).
# ---------------------------------------------------------------------------
ORACLE_USER=oracle
# ---------------------------------------------------------------------------
# Set the target connect string.
# Replace "sys/manager", below, with the target connect string.
# ---------------------------------------------------------------------------
TARGET_CONNECT_STR=sys/oracle
# ---------------------------------------------------------------------------
# Set the Oracle Recovery Manager name.
# ---------------------------------------------------------------------------
RMAN=$ORACLE_HOME/bin/rman
# ---------------------------------------------------------------------------
# Print out the value of the variables set by this script.
# ---------------------------------------------------------------------------
echo >> $RMAN_LOG_FILE
echo "RMAN: $RMAN" >> $RMAN_LOG_FILE
echo "ORACLE_SID: $ORACLE_SID" >> $RMAN_LOG_FILE
echo "ORACLE_USER: $ORACLE_USER" >> $RMAN_LOG_FILE
echo "ORACLE_HOME: $ORACLE_HOME" >> $RMAN_LOG_FILE
# ---------------------------------------------------------------------------
# Print out the value of the variables set by bphdb.
# ---------------------------------------------------------------------------
echo >> $RMAN_LOG_FILE
echo "NB_ORA_FULL: $NB_ORA_FULL" >> $RMAN_LOG_FILE
echo "NB_ORA_INCR: $NB_ORA_INCR" >> $RMAN_LOG_FILE
echo "NB_ORA_CINC: $NB_ORA_CINC" >> $RMAN_LOG_FILE
echo "NB_ORA_SERV: $NB_ORA_SERV" >> $RMAN_LOG_FILE
echo "NB_ORA_POLICY: $NB_ORA_POLICY" >> $RMAN_LOG_FILE
# ---------------------------------------------------------------------------
# NOTE: This script assumes that the database is properly opened. If desired,
# this would be the place to verify that.
# ---------------------------------------------------------------------------
echo >> $RMAN_LOG_FILE
# ---------------------------------------------------------------------------
# If this script is executed from a NetBackup schedule, NetBackup
# sets an NB_ORA environment variable based on the schedule type.
# The NB_ORA variable is then used to dynamically set BACKUP_TYPE
# For example, when:
# schedule type is BACKUP_TYPE is
# ---------------- --------------
# Automatic Full INCREMENTAL LEVEL=0
# Automatic Differential Incremental INCREMENTAL LEVEL=1
# Automatic Cumulative Incremental INCREMENTAL LEVEL=1 CUMULATIVE
#
# For user initiated backups, BACKUP_TYPE defaults to incremental
# level 0 (full). To change the default for a user initiated
# backup to incremental or incremental cumulative, uncomment
# one of the following two lines.
# BACKUP_TYPE="INCREMENTAL LEVEL=1"
# BACKUP_TYPE="INCREMENTAL LEVEL=1 CUMULATIVE"
#
# Note that we use incremental level 0 to specify full backups.
# That is because, although they are identical in content, only
# the incremental level 0 backup can have incremental backups of
# level > 0 applied to it.
# ---------------------------------------------------------------------------
if [ "$NB_ORA_FULL" = "1" ]
then
echo "Full backup requested" >> $RMAN_LOG_FILE
BACKUP_TYPE="INCREMENTAL LEVEL=0"
elif [ "$NB_ORA_INCR" = "1" ]
then
echo "Differential incremental backup requested" >> $RMAN_LOG_FILE
BACKUP_TYPE="INCREMENTAL LEVEL=1"
elif [ "$NB_ORA_CINC" = "1" ]
then
echo "Cumulative incremental backup requested" >> $RMAN_LOG_FILE
BACKUP_TYPE="INCREMENTAL LEVEL=1 CUMULATIVE"
elif [ "$BACKUP_TYPE" = "" ]
then
echo "Default - Full backup requested" >> $RMAN_LOG_FILE
BACKUP_TYPE="INCREMENTAL LEVEL=0"
fi
# ---------------------------------------------------------------------------
# Call Recovery Manager to initiate the backup. This example does not use a
# Recovery Catalog. If you choose to use one, replace the option 'nocatalog'
# from the rman command line below with the
# 'rcvcat <userid>/<passwd>@<tns alias>' statement.
#
# Note: Any environment variables needed at run time by RMAN
# must be set and exported within the switch user (su) command.
# ---------------------------------------------------------------------------
# Backs up the whole database. This backup is part of the incremental
# strategy (this means it can have incremental backups of levels > 0
# applied to it).
#
# We do not need to explicitly request the control file to be included
# in this backup, as it is automatically included each time file 1 of
# the system tablespace is backed up (the inference: as it is a whole
# database backup, file 1 of the system tablespace will be backed up,
# hence the controlfile will also be included automatically).
#
# Typically, a level 0 backup would be done at least once a week.
#
# The scenario assumes:
# o you are backing your database up to two tape drives
# o you want each backup set to include a maximum of 5 files
# o you wish to include offline datafiles, and read-only tablespaces,
# in the backup
# o you want the backup to continue if any files are inaccessible.
# o you are not using a Recovery Catalog
# o you are explicitly backing up the control file. Since you are
# specifying nocatalog, the controlfile backup that occurs
# automatically as the result of backing up the system file is
# not sufficient; it will not contain records for the backup that
# is currently in progress.
# o you want to archive the current log, back up all the
# archive logs using two channels, putting a maximum of 20 logs
# in a backup set, and deleting them once the backup is complete.
#
# Note that the format string is constructed to guarantee uniqueness and
# to enhance NetBackup for Oracle backup and restore performance.
#
#
# NOTE WHEN USING TNS ALIAS: When connecting to a database
# using a TNS alias, you must use a send command or a parms operand to
# specify environment variables. In other words, when accessing a database
# through a listener, the environment variables set at the system level are not
# visible when RMAN is running. For more information on the environment
# variables, please refer to the NetBackup for Oracle Admin. Guide.
#
# ---------------------------------------------------------------------------
CMD_STR="
ORACLE_HOME=$ORACLE_HOME
export ORACLE_HOME
ORACLE_SID=$ORACLE_SID
export ORACLE_SID
$RMAN target $TARGET_CONNECT_STR nocatalog msglog $RMAN_LOG_FILE append << EOF
RUN {
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE';
BACKUP
$BACKUP_TYPE
SKIP INACCESSIBLE
TAG hot_db_bk_level0
FILESPERSET 5
# recommended format
FORMAT 'bk_%s_%p_%t'
DATABASE;
sql 'alter system archive log current';
RELEASE CHANNEL ch00;
RELEASE CHANNEL ch01;
# backup all archive logs
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE' connect sys/oracle@lhczdata1;
ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE' connect sys/oracle@lhczdata2;
BACKUP
filesperset 20
FORMAT 'al_%s_%p_%t'
ARCHIVELOG ALL;
delete noprompt archivelog until time 'sysdate-3';
RELEASE CHANNEL ch00;
RELEASE CHANNEL ch01;
#
# Note: During the process of backing up the database, RMAN also backs up the
# control file. This version of the control file does not contain the
# information about the current backup because "nocatalog" has been specified.
# To include the information about the current backup, the control file should
# be backed up as the last step of the RMAN section. This step would not be
# necessary if we were using a recovery catalog.
#
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
BACKUP
# recommended format
FORMAT 'cntrl_%s_%p_%t'
CURRENT CONTROLFILE;
RELEASE CHANNEL ch00;
allocate channel ch00 type disk;
copy current controlfile to '/nbu-scripts/c.ctl';
release channel ch00;
}
EOF
"
# Initiate the command string
if [ "$CUSER" = "root" ]
then
su - $ORACLE_USER -c "$CMD_STR" >> $RMAN_LOG_FILE
RSTAT=$?
else
/usr/bin/sh -c "$CMD_STR" >> $RMAN_LOG_FILE
RSTAT=$?
fi
# ---------------------------------------------------------------------------
# Log the completion of this script.
# ---------------------------------------------------------------------------
if [ "$RSTAT" = "0" ]
then
LOGMSG="ended successfully"
else
LOGMSG="ended in error"
fi
/usr/openv/netbackup/bin/bpbackup -p con-unix -s app /nbu-scripts/c.ctl
echo >> $RMAN_LOG_FILE
echo Script $0 >> $RMAN_LOG_FILE
echo ==== $LOGMSG on `date` ==== >> $RMAN_LOG_FILE
echo >> $RMAN_LOG_FILE
exit $RSTAT
==============================================================================================
==============================================================================================
.out输出文件Script /nbu-scripts/lhdata_backup3day.sh
==== started on Thu Oct 24 01:11:27 CST 2013 ====
RMAN: /opt/ora10g/product/10.2.0/db_2/bin/rman
ORACLE_SID: lhczdata2
ORACLE_USER: oracle
ORACLE_HOME: /opt/ora10g/product/10.2.0/db_2
NB_ORA_FULL: 1
NB_ORA_INCR: 0
NB_ORA_CINC: 0
NB_ORA_SERV: njlh-master
NB_ORA_POLICY: rac2_oracle_full
Full backup requested
Recovery Manager: Release 10.2.0.4.0 - Production on Thu Oct 24 01:11:27 2013
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: LHCZDATA (DBID=207955637)
using target database control file instead of recovery catalog
RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40> 41> 42> RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40> 41> 42>
allocated channel: ch00
channel ch00: sid=825 instance=lhczdata2 devtype=SBT_TAPE
channel ch00: Veritas NetBackup for Oracle - Release 7.5 (2012020801)
allocated channel: ch01
channel ch01: sid=827 instance=lhczdata2 devtype=SBT_TAPE
channel ch01: Veritas NetBackup for Oracle - Release 7.5 (2012020801)
Starting backup at 24-OCT-13
channel ch00: starting incremental level 0 datafile backupset
channel ch00: specifying datafile(s) in backupset
input datafile fno=00009 name=/dev/raw/raw304
input datafile fno=00013 name=/dev/raw/raw308
input datafile fno=00006 name=/dev/raw/raw301
input datafile fno=00003 name=/dev/raw/raw25
input datafile fno=00015 name=/dev/raw/raw310
channel ch00: starting piece 1 at 24-OCT-13
channel ch01: starting incremental level 0 datafile backupset
channel ch01: specifying datafile(s) in backupset
input datafile fno=00007 name=/dev/raw/raw302
input datafile fno=00011 name=/dev/raw/raw306
input datafile fno=00005 name=/dev/raw/raw32
channel ch01: starting piece 1 at 24-OCT-13
channel ch01: finished piece 1 at 24-OCT-13
piece handle=bk_595_1_829617090 tag=HOT_DB_BK_LEVEL0 comment=API Version 2.0,MMS Version 5.0.0.0
channel ch01: backup set complete, elapsed time: 01:00:27
channel ch01: starting incremental level 0 datafile backupset
channel ch01: specifying datafile(s) in backupset
input datafile fno=00010 name=/dev/raw/raw305
input datafile fno=00014 name=/dev/raw/raw309
input datafile fno=00004 name=/dev/raw/raw33
input datafile fno=00016 name=/dev/raw/raw501
channel ch01: starting piece 1 at 24-OCT-13
channel ch00: finished piece 1 at 24-OCT-13
piece handle=bk_594_1_829617090 tag=HOT_DB_BK_LEVEL0 comment=API Version 2.0,MMS Version 5.0.0.0
channel ch00: backup set complete, elapsed time: 01:01:22
channel ch00: starting incremental level 0 datafile backupset
channel ch00: specifying datafile(s) in backupset
input datafile fno=00008 name=/dev/raw/raw303
input datafile fno=00012 name=/dev/raw/raw307
input datafile fno=00002 name=/dev/raw/raw31
input datafile fno=00001 name=/dev/raw/raw24
channel ch00: starting piece 1 at 24-OCT-13
channel ch01: finished piece 1 at 24-OCT-13
piece handle=bk_596_1_829620717 tag=HOT_DB_BK_LEVEL0 comment=API Version 2.0,MMS Version 5.0.0.0
channel ch01: backup set complete, elapsed time: 00:39:42
channel ch01: starting incremental level 0 datafile backupset
channel ch01: specifying datafile(s) in backupset
including current control file in backupset
channel ch01: starting piece 1 at 24-OCT-13
channel ch01: finished piece 1 at 24-OCT-13
piece handle=bk_598_1_829623099 tag=HOT_DB_BK_LEVEL0 comment=API Version 2.0,MMS Version 5.0.0.0
channel ch01: backup set complete, elapsed time: 00:00:55
channel ch01: starting incremental level 0 datafile backupset
channel ch01: specifying datafile(s) in backupset
including current SPFILE in backupset
channel ch01: starting piece 1 at 24-OCT-13
channel ch01: finished piece 1 at 24-OCT-13
piece handle=bk_599_1_829623155 tag=HOT_DB_BK_LEVEL0 comment=API Version 2.0,MMS Version 5.0.0.0
channel ch01: backup set complete, elapsed time: 00:00:46
channel ch00: finished piece 1 at 24-OCT-13
piece handle=bk_597_1_829620772 tag=HOT_DB_BK_LEVEL0 comment=API Version 2.0,MMS Version 5.0.0.0
channel ch00: backup set complete, elapsed time: 00:47:14
Finished backup at 24-OCT-13
sql statement: alter system archive log current
released channel: ch00
released channel: ch01
allocated channel: ch00
channel ch00: sid=830 instance=lhczdata2 devtype=SBT_TAPE
channel ch00: Veritas NetBackup for Oracle - Release 7.5 (2012020801)
allocated channel: ch01
channel ch01: sid=647 instance=lhczdata1 devtype=SBT_TAPE
channel ch01: Veritas NetBackup for Oracle - Release 7.5 (2012020801)
Starting backup at 24-OCT-13
current log archived
channel ch00: starting archive log backupset
channel ch00: specifying archive log(s) in backup set
input archive log thread=2 sequence=910 recid=511 stamp=829364359
input archive log thread=2 sequence=911 recid=518 stamp=829416017
input archive log thread=2 sequence=912 recid=521 stamp=829416021
input archive log thread=2 sequence=913 recid=527 stamp=829450820
input archive log thread=2 sequence=914 recid=529 stamp=829450823
input archive log thread=2 sequence=915 recid=538 stamp=829519184
input archive log thread=2 sequence=916 recid=540 stamp=829537270
input archive log thread=2 sequence=917 recid=545 stamp=829537277
input archive log thread=2 sequence=918 recid=554 stamp=829623610
input archive log thread=2 sequence=919 recid=555 stamp=829623612
channel ch00: starting piece 1 at 24-OCT-13
channel ch01: starting archive log backupset
channel ch01: specifying archive log(s) in backup set
input archive log thread=1 sequence=955 recid=520 stamp=829416072
input archive log thread=1 sequence=956 recid=523 stamp=829416077
input archive log thread=1 sequence=957 recid=528 stamp=829450876
input archive log thread=1 sequence=958 recid=531 stamp=829450879
input archive log thread=1 sequence=959 recid=534 stamp=829481182
input archive log thread=1 sequence=960 recid=537 stamp=829519239
input archive log thread=1 sequence=961 recid=542 stamp=829537327
input archive log thread=1 sequence=962 recid=543 stamp=829537332
input archive log thread=1 sequence=963 recid=547 stamp=829569722
channel ch01: starting piece 1 at 24-OCT-13
channel ch00: finished piece 1 at 24-OCT-13
piece handle=al_600_1_829623616 tag=TAG20131024T030016 comment=API Version 2.0,MMS Version 5.0.0.0
channel ch00: backup set complete, elapsed time: 00:01:57
channel ch01: finished piece 1 at 24-OCT-13
piece handle=al_601_1_829623671 tag=TAG20131024T030016 comment=API Version 2.0,MMS Version 5.0.0.0
channel ch01: backup set complete, elapsed time: 00:02:52
channel ch01: starting archive log backupset
channel ch01: specifying archive log(s) in backup set
input archive log thread=1 sequence=964 recid=550 stamp=829605687
input archive log thread=1 sequence=965 recid=552 stamp=829623664
input archive log thread=1 sequence=966 recid=557 stamp=829623669
channel ch01: starting piece 1 at 24-OCT-13
channel ch01: finished piece 1 at 24-OCT-13
piece handle=al_602_1_829623843 tag=TAG20131024T030016 comment=API Version 2.0,MMS Version 5.0.0.0
channel ch01: backup set complete, elapsed time: 00:01:05
Finished backup at 24-OCT-13
List of Archived Log Copies
Key Thrd Seq S Low Time Name
------- ---- ------- - --------- ----
510 1 952 X 20-OCT-13 /archivelog/1_952_818033912.arc
513 1 953 X 21-OCT-13 /archivelog/1_953_818033912.arc
516 1 954 X 21-OCT-13 /archivelog/1_954_818033912.arc
511 2 910 A 21-OCT-13 /archivelog/2_910_818033912.arc
518 2 911 A 21-OCT-13 /archivelog/2_911_818033912.arc
deleted archive log
archive log filename=/archivelog/1_952_818033912.arc recid=510 stamp=829364410
deleted archive log
archive log filename=/archivelog/1_953_818033912.arc recid=513 stamp=829364415
deleted archive log
archive log filename=/archivelog/1_954_818033912.arc recid=516 stamp=829399094
deleted archive log
archive log filename=/archivelog/2_910_818033912.arc recid=511 stamp=829364359
deleted archive log
archive log filename=/archivelog/2_911_818033912.arc recid=518 stamp=829416017
Deleted 5 objects
released channel: ch00
released channel: ch01
allocated channel: ch00
channel ch00: sid=825 instance=lhczdata2 devtype=SBT_TAPE
channel ch00: Veritas NetBackup for Oracle - Release 7.5 (2012020801)
Starting backup at 24-OCT-13
channel ch00: starting full datafile backupset
channel ch00: specifying datafile(s) in backupset
including current control file in backupset
channel ch00: starting piece 1 at 24-OCT-13
channel ch00: finished piece 1 at 24-OCT-13
piece handle=cntrl_603_1_829623854 tag=TAG20131024T030414 comment=API Version 2.0,MMS Version 5.0.0.0
channel ch00: backup set complete, elapsed time: 00:00:45
Finished backup at 24-OCT-13
released channel: ch00
allocated channel: ch00
channel ch00: sid=825 instance=lhczdata2 devtype=DISK
Starting backup at 24-OCT-13
channel ch00: starting datafile copy
copying current control file
output filename=/nbu-scripts/c.ctl tag=TAG20131024T030500 recid=37 stamp=829623900
channel ch00: datafile copy complete, elapsed time: 00:00:01
Finished backup at 24-OCT-13
released channel: ch00
RMAN> RMAN>
Recovery Manager complete.
Script /nbu-scripts/lhdata_backup3day.sh
==== ended successfully on Thu Oct 24 03:05:01 CST 2013 ====
=============================================================================
=============================================================================
提示delete archive log的文件在另一个节点上全部存在并没有删。 |
|