Summary of automatic backup scripts for Oracle databases in linux and windows

Oracle DatabaseIn operation, database backup is one of the most important operations because it involves database security. Database Administrators often set the databaseAutomatic BackupTo back up the database, how do I set automatic backup? What are the differences between the settings of different operating system platforms? This article mainly introduces this part of content, hoping to help you.

Backup of Oracle databases in Linux:

 
 

  
  
FIELNAME=/home/oracle/dmp/`date +%Y%m%d`.dmp  
  
  
echo $FIELNAME > /home/oracle/dmp/filename  
  
  
/home/oracle/product/9.2/bin/exp ccbip/'und\=2008CN(Y|N)' full=y file=$FIELNAME  
  
  
bzip2 $FIELNAME 
 
 

Note: All created files are in the Oracle user oinstall group.

Automatic backup script for Oracle databases in Windows:

ExpData. bat content:

 
 

  
  
exp system/system@orcl file=c:\oracle_bak\tne%date:~4,10%.dmp owner=tne   
  
  
exp system/system@orcl file=c:\oracle_bak\prt%date:~4,10%.dmp owner=prt   
  
  
exp system/system@orcl file=c:\oracle_bak\sec%date:~4,10%.dmp owner=sec   
  
  
exp system/system@orcl file=c:\oracle_bak\tea%date:~4,10%.dmp owner=tea   
  
  
exp system/system@orcl file=c:\oracle_bak\pic%date:~4,10%.dmp owner=pic   
  
  
exp system/system@orcl file=c:\oracle_bak\system%date:~4,10%.dmp owner=system   
  
  
path=D:\WinRAR 3.20  
  
  
rar a Data%date:~4,10%.rar *%date:~4,10%.dmp  
  
  
del *%date:~4,10%.dmp 
 
 

The above is all the content of the script for automatic backup of Oracle databases in linux and windows. We will introduce it here. If you want to know more about Oracle databases, you can also take a look at this article: http://database.51cto.com/oracle/. I believe you can bring it to us!