Shulou(Shulou.com)05/31 Report--

How to understand the data pump and rman script, many novices are not very clear about this, in order to help you solve this problem, the following editor will explain for you in detail, people with this need can come to learn, I hope you can gain something.

The main logic of the script: the database of the read instance is backed up in the full library, and the attached functional files (spfile,controlfile control file, listener listening file, password file orapw [instance _ name]) are compressed and sent to the remote server.

(PS: a behavior comment that begins with # in the body of the script, which can be used by directly copying the following code without affecting the operation.)

one。 First of all, it is backed up by the data pump expdp/impdp:

#! / bin/bash

# backup oracle instances' full databases with datapump (expdp)

# oracleDB_fullbackup_expdp.sh

# DATA_PUMP_DIR=/opt/ora11g/admin/$ {instance_name} / dpdump/

# created by dc at 2015-12-08

Source / home/oracle/.bash_profile

# read the environment variables of the user oracle to directly read the relevant variables defined using the contents of the file

ORACLE_BIN_HOME=$ {ORACLE_HOME} / bin/

BACKUPTOOL_HOME=$ {ORACLE_BASE} / dba/OracleTools/

BACKUP_HOME=$ {BACKUPTOOL_HOME} DBbackup/

# define relevant variables to point to the working directory, ORACLE_BIN_HOME is the directory where the oracle tools (sqlplus,rman,dbca,emctl, etc.) are located; BACKUPTOOL_HOME is the directory where the relevant files of the script tool are located, BACKUP_HOME is the backup file storage directory, ORACLE_HOME and ORACLE_BASE are the environment variables read from the .bash _ profile file, referring to the home directory of oracle and the root directory of oracle, respectively

Echo "fullbackup job start at $(date +% Y-%m-%d_%T)" > > ${BACKUPTOOL_HOME} fullbackup.result

# record the following backup work start time to the file fullbackup.result in local statistics to help determine the time required for scheduled tasks

For instance_name in `cat ${BACKUPTOOL_HOME} instances_ all`

# for loop reads all instance names recorded in the instances_all file to do the following

Do

DATA_PUMP_DIR=$ {ORACLE_BASE}'/ admin/'$ {instance_name}'/ dpdump/'

# define the path where the variable DATA_PUMP_DIR stores the exported file

Expdp system/password@$ {instance_name} DIRECTORY=DATA_PUMP_DIR DUMPFILE=full_$ {instance_name} _ $(date +% Y-%m-%d) _ systemExpdp.dmp LOG=full_$ {instance_name} _ $(date +% Y-%m-%d) _ systemExpdp.log FULL=y

# use the full database of the system account to export the data of the instance. The export directory is DATA_PUMP_DIR (you can query the corresponding directory in the backend sqlplus environment, and note that the system directory really exists). The export file is defined after the name of the option "DUMPFILE=". Similarly, the log of the export process is defined in the option "LOG=", and "FULL=y" means full library export. Note that @ ${instance_name} refers to the tnsname of the current instance, that is, the instance resolution name. For more information, please see the settings under $ORACLE_HOME/network/admin/tnsname.ora

Mv ${DATA_PUMP_DIR} 'full_'$ {instance_name} * .dmp ${BACKUP_HOME}' tarfileDIR/'$ {instance_name}'/ datafile/'

Mv ${DATA_PUMP_DIR} 'full_'$ {instance_name} * .log ${BACKUP_HOME}' tarfileDIR/'$ {instance_name}'/ datafile/'

# transfer the data files and log files obtained from the previous export to the corresponding instance classification directory

Cp ${ORACLE_HOME}'/ dbs/orapw'$ {instance_name} ${BACKUP_HOME} 'tarfileDIR/'$ {instance_name}' / passwdfile/'

Cp ${ORACLE_HOME} / network/admin/ {listener.ora,tnsnames.ora,sqlnet.ora} ${BACKUP_HOME} 'tarfileDIR/'$ {instance_name} / listenerfile/

# copy database user password to store files and monitor related files to classification directory

Done

Cd ${BACKUP_HOME}

Tar-zcpf full_$ (date +% Y-%m-%d) _ systemExpdp.tar.gz tarfileDIR

# compressed and packaged after all instances have been exported

Rm-rf ${BACKUP_HOME} tarfileDIR

# Delete the packaged original files for use in the next backup

For instance_name in `cat ${BACKUPTOOL_HOME} instances_ all`

Do

Mkdir-p ${BACKUP_HOME} tarfileDIR/$ {instance_name} / {datafile,listenerfile,passwdfile}

Done

# re-establish all instances to store data directories for next use

/ usr/bin/expect ${BACKUPTOOL_HOME} dailyfullbackup.result

# write to the log and record the end time of script execution locally

two。 Then there is the RMAN full library backup script:

#! / bin/bash

# full backup oracle instances' databases with RMAN

# oracleDB_fullbackup_rman.sh

# recovery directory is "/ opt/ora11g/dba/OracleTools/DBbackup/restoreDIR_daily/", it concerns about your backup level,put the DBbackup tar file into the destination server's same directory then extracts it when you need to recover the database

# created by dc at 2015-12-08

# add script interpreter / bin/bash statement and other additional script instructions. Note that the data recovery path here is the corresponding folder under the / opt/ora11g/dba/OracleTools/DBbackup/restoreDIR_daily directory. As described below, since RMAN is used for import and export, please try to keep the import and export directory consistent. For more information, please refer to my previous article: using rman to migrate oracle instances on the same platform.

Source / home/oracle/.bash_profile

# Import environment variables in / home/oracle/.bash_profile file

ORACLE_BIN_HOME=$ {ORACLE_HOME} / bin/

BACKUPTOOL_HOME=$ {ORACLE_BASE} / dba/OracleTools/

BACKUP_HOME=$ {BACKUPTOOL_HOME} DBbackup/

# define the directory variable $ORACLE_BIN_HOME where the oracle comes with tools, the backup script tool directory $BACKUPTOOL_HOME and the backup export file storage directory $BACKUP_HOME

Echo "tlm,txmy's dailyfullbackup job start at $(date +% Y-%m-%d_%T)" > > ${BACKUPTOOL_HOME} dailyfullbackup.result

# record the start time of the following script operation to dailyfullbackup.result

For instance_name in `cat ${BACKUPTOOL_HOME} instances_ daily`

Do

Export ORACLE_SID=$instance_name

# use the for loop to extract the instance names recorded in the instances_daily file in turn and import the environment variables

${ORACLE_BIN_HOME} 'rman' target / ${BACKUP_HOME} tarfileDIR_daily/full/readme.txt

# write down the restore path used by rman to the help document readme.txt

Echo "The DB base directory is ${ORACLE_BASE}" > > ${BACKUP_HOME} tarfileDIR_daily/full/readme.txt

# write down the root directory of the source database to the content of the help document

Echo "Please extract the tarfile with option-P, like tar-zxPf xxx.tar.gz" > > ${BACKUP_HOME} tarfileDIR_daily/full/readme.txt

# use the-P parameter to the content of the help document when recording and decompressing

Tar-zcPpf ${BACKUP_HOME} tarfileDIR_daily/full_all_$ (date +% Y-%m-%d). Tar.gz ${BACKUP_HOME} tarfileDIR_daily/full

# package all the data exported from the instance and send it to the storage destination later

Rm-rf ${BACKUP_HOME} tarfileDIR_daily/full

# deleting packaged files saves space

/ usr/bin/expect ${BACKUPTOOL_HOME} dailyfullbackup.result

# record the end time of the above operations in the local dailyfullbackup.result file, and count the start time in response to the beginning

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.