Oracle服务器A :Windows2003+Oracle10g 周五0备,周1到周4 二级备份
备机B:Windows2003将A机的Oracle系统的备份恢复到B机
周6恢复0备,周2到周5恢复2级备份
这个脚本怎么写哈
备机B:Windows2003将A机的Oracle系统的备份恢复到B机
周6恢复0备,周2到周5恢复2级备份
这个脚本怎么写哈
解决方案 »
- 如何查看用户对oracle的相关操作
- 用PL/SQL Developer 怎么创建用户阿
- oracle 817 在vmware下的win2003安装失败
- 如何在9i中给新加的一个用户定义只有对一个视图只读的权限。我已添加了一个用户,只是不知怎么定义才能只有只读一个视图的权限
- pl/sql与sql*plus worksheet显示结果不一样?
- 表分区:能否在现使用的表上进行表分区?而不用重新rename?
- 如何用sql语句得到数据库中得所有表名
- oracle 数据库备份与恢复
- oracle817的问题——我用sysman进入了console,为什么看不到数据库?
- 我要写一个触发器 目的在于记录当这张表有insert操作的时候 再往此表插入一条别的记录
- 两个关于恢复和备份的问题
- 求助,Oracle监听的问题
http://topic.csdn.net/u/20090908/09/7f32515a-94fb-4cba-9aee-d7ce35abdc23.html?8110
和
http://bbs.inthirties.com/viewthread.jsp?tid=5&extra=page%3D1不过这里只有linux下的脚本,window的脚步,整理好以后贴上来。
# $Header: hot_database_backup.sh,v 1.9 2002/02/06 16:48:56 lstrub Stab $
#
#bcpyrght
#***************************************************************************
#* $VRTScprght: Copyright 1993 - 2002 VERITAS Software 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 /u01/app/oracle/product/10.2.0.3, below, with the Oracle home path.
# --------------------------------------------------------------------------- ORACLE_HOME=/u01/app/oracle/product/10.2.0.3
export ORACLE_HOME # ---------------------------------------------------------------------------
# Replace ora81, below, with the Oracle SID of the target database.
# --------------------------------------------------------------------------- ORACLE_SID=test
export ORACLE_SID # ---------------------------------------------------------------------------
# Replace oracle 10g, below, with the Oracle DBA user id (account).
# --------------------------------------------------------------------------- ORACLE_USER=oracle
export ORACLE_USER
# ---------------------------------------------------------------------------
# Set the Oracle Recovery Manager name.
# --------------------------------------------------------------------------- RMAN=$ORACLE_HOME/bin/rman # --------------------------------------------------------------------------
# Recovery Catalog Connect String
# --------------------------------------------------------------------------
# ---------------------------------------------------------------------------
# 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
修改下在Server 2003下也差不多能用的了。