代码改变世界

Oracle程序备份

2018-07-29 16:01  WWJD_DBA  阅读(341)  评论(0)  编辑  收藏  举报

 

 

 1 --使用root用户备份
 2 su - root
 3 mkdir -p /oracle/data_dump/backup_soft
 4 nohup tar -cvf /oracle/data_dump/backup_soft/oracle_`date +\%Y\%m\%d`.tar            /oracle/app/oracle             >/oracle/data_dump/backup_soft/oracle.tar.log &
 5 nohup tar -cvf /oracle/data_dump/backup_soft/12.1.0_`date +\%Y\%m\%d`.tar            /oracle/app/12.1.0             >/oracle/data_dump/backup_soft/12.1.0.tar.log &
 6 nohup tar -cvf /oracle/data_dump/backup_soft/grid_`date +\%Y\%m\%d`.tar              /oracle/app/grid               >/oracle/data_dump/backup_soft/grid.tar.log &
 7 nohup tar -cvf /oracle/data_dump/backup_soft/oraInventory_`date +\%Y\%m\%d`.tar      /oracle/app/oraInventory       >/oracle/data_dump/backup_soft/oraInventory.tar.log &
 8 nohup tar -cvf /oracle/data_dump/backup_soft/etc_`date +\%Y\%m\%d`.tar               /etc                           >/oracle/data_dump/backup_soft/etc.tar.log &
 9
10 --当前数据库程序目录
11 drwxrwxrwx    3 grid     oinstall        256 Jul 16 10:05 12.1.0
12 drwxrwxrwx   11 grid     oinstall       4096 Jul 27 11:44 grid
13 drwxrwxrwx    6 grid     oinstall        256 Jul 27 11:43 oraInventory
14 drwxrwxrwx    8 oracle   oinstall        256 Jul 25 15:57 oracle
15 
16 --修改程序目录名
17 su - root
18 mv 12.1.0        12.1.0_20180727
19 mv grid          grid_20180727
20 mv oraInventory  oraInventory_20180727
21 mv oracle        oracle_20180727
22 
23 --解压备份的程序文件,解压后权限都在,直接启集群即可（AIX环境会解压到原路径，Linux则不会解压到原路径！）
24 tar -xvf /oracle/data_dump/backup_soft/oracle.tar
25 tar -xvf /oracle/data_dump/backup_soft/12.1.0.tar
26 tar -xvf /oracle/data_dump/backup_soft/grid.tar
27 tar -xvf /oracle/data_dump/backup_soft/oraInventory.tar

 

mkdir -p /data/backup_soft

nohup tar -cvf /data/backup_soft/`date +\%Y\%m\%d`_oracle.tar            /oracle/app/oracle            >/data/backup_soft/`date +\%Y\%m\%d`_oracle.tar.log &

nohup tar -cvf /data/backup_soft/`date +\%Y\%m\%d`_12.2.0.tar            /oracle/app/12.2.0            >/data/backup_soft/`date +\%Y\%m\%d`_12.2.0.tar.log &

nohup tar -cvf /data/backup_soft/`date +\%Y\%m\%d`_grid.tar              /oracle/app/grid              >/data/backup_soft/`date +\%Y\%m\%d`_grid.tar.log &

nohup tar -cvf /data/backup_soft/`date +\%Y\%m\%d`_oraInventory.tar      /oracle/app/oraInventory      >/data/backup_soft/`date +\%Y\%m\%d`_oraInventory.tar.log &

nohup tar -cvf /data/backup_soft/`date +\%Y\%m\%d`_etc.tar               /etc                          >/data/backup_soft/`date +\%Y\%m\%d`_etc.tar.log &