Oracle Data regular backup

There is a simple requirement for regular oracle Data Backup: the oracle database is placed on host-a, and I want to back up host-a to specify oracle table data at host-B at every morning. Step 1. Install the oracle environment or oracle instant client on host-B. Step 2. Configure TNS Name Java code on host-B # edit and add the following configuration vi/u01/app/oracle/ network/admin/tnsnames. ora Java code host_a_db = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = host-a) (PORT = 1521 ))) (CONNECT_DATA = (SID = logstat) (SERVER = DEDICATED) Step 3. Compile the shell script Java code vi backup. sh # The content is as follows: exp logstat/xxxx @ host_a_db FILE = snda-'date-d yesterday + % Y % m % d '. dmp TABLES = T1, T2 BUFFER = 64000 # retain only the seven-day backup find/home/oracle/snda_bak-name '*. dmp '-mtime + 6-exec rm-fr {}\; backup file name contains the date of the day before the current date, such effect 'snda-20130415.dmp' Step 4: click crontab 3 3 *** source. bash_profile;/home/oracle/backup. sh> out. log -- end