Data backup is almost a task that every system administrator has to do every day. However, this is very tedious-if the system automatically backs up data at a fixed time every day, that would be nice! Next, I will talk about how to implement automatic Oracle Database Backup in a UNIX environment based on my practical experience.
We plan to allow the database to perform eXPort backup at a.m., copy the backup file to the tape at a.m., and copy the backup file to another UNIX machine at a.m, to do this, we can perform the following operations:
1. Export an Oracle database
The export command backs up data in the database into a binary file. There are usually three modes: user mode, table mode, and whole database mode. This document uses the user mode. before backup, you must create a backup directory to hold backup files. For example, you can create a/backup directory. Then we can create two files, ora-backup and tar-backup, respectively, in the Oracle directory of UNIX (or another directory. It should be noted that the Oracle parameter needs to be initialized in the previous file. For convenience, we may wish to put the initialization command in a file (the file name should be set to ora-env ), then the first file calls it.
1. The ora-env file initializes Oracle parameters. The content is as follows:
ORACLE-HOME = $ ORACLE-HOME; export ORACLE-HOME
ORACLE-SID = ora73; export ORACLE-SID
ORACLE-TERM = sun; export ORACLE-TERM
LD-LIBRARY-PATH = $ ORACLE-HOME/lib; export LD-LIBRARY-PATH
ORA-NLS32 = $ ORACLE-HOME/ocommon/nls/admin/data; export ORA-NLS
PATH =.:/usr/ccs/bin:/usr/UCb: $ ORACLE-HOME/bin: $ PATH; export PATH
DISPLAY = host1: 0; export DISPLAY
NLS-LANG = american-america.zhs16cgb231280; export NLS-LANG
2. the ora-backup file exports the Database export, and the exported file name can be set at will. This document specifies the letter "xx" and the date of the day, that is, if the date of the day is January 1, December 10, the exported file name is "xx1210.dmp", which is different from the backup file of other dates.
Ora-backup file content:
./Oracle/ora-env
# Initializing an Oracle database
Rq = 'date + "% m % d ″′
# Assign the date of the day to the variable rq
Rm/backup/
# Clearing/backup directories
Exp test/test file =/backup/xx $ rq. dmp log =/backup/xx $ rq. log
This command is used to export the data of the user test (whose password is also test) at the $ prompt. The exported files and logs are stored in the/backup directory.