netbackup之oracle的备份恢复

root# ./install

Symantec Installation Script

Copyright 1993 - 2012 Symantec Corporation, All Rights Reserved.

Installing NetBackup Client Software

Please review the SYMANTEC SOFTWARE LICENSE AGREEMENT located on

the installation media before proceeding. The agreement includes

details on the NetBackup Product Improvement Program.

Do you wish to continue? [y,n] (y) y

Do you want to install the NetBackup client software for this client? [y,n] (y) y

This package will install Solaris/Solaris10 client.

This package will install NetBackup client 7.5.

Enter the name of the NetBackup server : prd-nbu7

Would you like to use "sacnsun02102" as the configured

name of the NetBackup client? [y,n] (y) y

验证查看是否生成了/usr/openv/netbackup目录

# ls -l /usr/openv/netbackup

[root@localhost ~]# su - oracle

[oracle@localhost ~]$ cd /usr/openv/netbackup/bin

[oracle@localhost bin]$ ./oracle_link

2012年 08月 25日 星期六 09:43:28 CST

All Oracle instances should be shutdown before running this script.

Please log into the Unix system as the Oracle owner for running this script

Do you want to continue? (y/n) [n] y

LIBOBK path: /usr/openv/netbackup/bin

ORACLE_HOME: /orcl/oracle

Oracle version: 10.2.0.1.0

Platform type: i686

Linking LIBOBK:

ln -s /usr/openv/netbackup/bin/libobk.so /orcl/oracle/lib/libobk.so

Done

Please check the trace file located in /tmp/make_trace.4459

to make sure the linking process was successful.

[root@localhost ~]# mkdir -p /usr/openv/netbackup/script

[root@localhost ~]# cd /usr/openv/netbackup/ext/db_ext/oracle/samples/rman

[root@localhost rman]# ls

cold_database_backup.sh database_restore.sh hot_tablespace_backup.sh

cold_duplex_database_backup_full.sh hot_database_backup.sh pit_database_restore.sh

[root@localhost rman]# cp hot_database_backup.sh /usr/openv/netbackup/script/

[root@localhost rman]# cd /usr/openv/netbackup/script/

[root@localhost script]# ls

hot_database_backup.sh

[root@localhost script]# mv hot_database_backup.sh rman.sh

[root@localhost script]# chmod o+x rman.sh 一定要授权执行权限,否则NBU调用不了

[root@localhost script]# vi rman.sh

Oracle热备份脚本举例如下：

#!/bin/sh

# $Header: hot_database_backup.sh,v 1.2 2002/08/06 23:51:42 $

#

#bcpyrght

#***************************************************************************

#* $VRTScprght: Copyright 1993 - 2008 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=/u01/app/oracle/product/11.2.0/

export ORACLE_HOME

Oracle HOME目录，可通过env命令查出

# ---------------------------------------------------------------------------

# Replace ora81, below, with the Oracle SID of the target database.

# ---------------------------------------------------------------------------

ORACLE_SID=orcl

export ORACLE_SID

Oracle实例名

# ---------------------------------------------------------------------------

# Replace ora81, below, with the Oracle DBA user id (account).

# ---------------------------------------------------------------------------

ORACLE_USER=oracle

Oracle系统账户

# ---------------------------------------------------------------------------

# Set the target connect string.

# Replace "sys/manager", below, with the target connect string.

# ---------------------------------------------------------------------------

TARGET_CONNECT_STR=sys/Qweasd123

Sys用户及其密码

# ---------------------------------------------------------------------------

# Set the Oracle Recovery Manager name.

# ---------------------------------------------------------------------------

RMAN=$ORACLE_HOME/bin/rman

# ---------------------------------------------------------------------------

# Print out the value of the variables set by this script.

# ---------------------------------------------------------------------------

#中间代码不用更改，此处略

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‘;

echo send ‘NB_ORA_POLICY=your_policy, NB_ORA_SERV=your_serverí‘;

发送备份信息给相对应的备份策略，当每一台Oracle只有一个NBU备份策略时，次句可以不写

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‘;

ALLOCATE CHANNEL ch01 TYPE ‘SBT_TAPE‘;

echo send ‘NB_ORA_POLICY=your_policy, NB_ORA_SERV=your_serverí‘;

发送备份信息给相对应的备份策略，当每一台Oracle只有一个NBU备份策略时，次句可以不写

BACKUP

filesperset 20

FORMAT ‘al_%s_%p_%t‘

ARCHIVELOG ALL;

RELEASE CHANNEL ch00;

RELEASE CHANNEL ch01;

ALLOCATE CHANNEL ch00 TYPE ‘SBT_TAPE‘;

DELETE NOPROMPT ARCHIVELOG ALL COMPLETED BEFORE ‘SYSDATE-7‘;

RELEASE CHANNEL ch00;

原脚本备份后直接删除归档日志，可以如上编写，删除7天前的归档日志

#

# 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;

}

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

echo >> $RMAN_LOG_FILE

echo Script $0 >> $RMAN_LOG_FILE

echo ==== $LOGMSG on `date` ==== >> $RMAN_LOG_FILE

echo >> $RMAN_LOG_FILE

exit $RSTAT

Use the following procedure to remove all NetBackup client software components

from a UNIX client.

To remove NetBackup software from a UNIX client

1、 Log in to the client system as the root user.

2、Stop the NetBackup daemons by entering the following command:

/usr/openv/netbackup/bin/bp.kill_all

3、Identify any installed add-on products by using the following command:

AIX lslpp -L

HP-UX swlist

Linux rpm -qa

Solaris pkginfo

Remove each identified add-on product.

………………

11、For all clients, navigate to the /usr/openv directory and proceed as follows:

Warning: The rm -f /usr/openv command also removes any add-on products

that are installed on this computer.

■ If /usr/openv is the actual directory, run the following command:

rm -rf /usr/openv

■ If /usr/openv is a symbolic link to that directory, run the following

commands:

cd /usr/openv

pwd

ls

Warning: Before you continue, make sure that you are at the correct

location and verify that the subdirectories are what you expect them to

be. To help prevent removing the wrong directories, the previous

commands verify your current location and list the files in that directory.

After you verify the directory location and its contents, remove the

directory with the next commands.

rm -rf *

cd /

rm -f /usr/openv

12、For Linux systems only:

If you modified the startup and the shutdown scripts, run the following

command:

/sbin/chkconfig --del netbackup

13 Remove the following startup scripts:

AIX

/etc/rc.netbackup.aix

Linux Red Hat

/etc/rc.d/init.d/netbackup

/etc/rc.d/rc0.d/K01netbackup

/etc/rc.d/rc1.d/K01netbackup

/etc/rc.d/rc2.d/S77netbackup

/etc/rc.d/rc3.d/S77netbackup

/etc/rc.d/rc5.d/S77netbackup

/etc/rc.d/rc6.d/K01netbackup

Other clients

/etc/init.d/netbackup

/etc/rc0.d/K01netbackup

/etc/rc1.d/K01netbackup

/etc/rc2.d/S77netbackup