建立计划任务，实现自动备份 

1. 开启块跟踪 

[oracle@aix213 ~]$sqlplus / as sysdba 
 
SQL*Plus:  Release  10.2.0.1.0  -  Production  on  Tue  Jun  17 
14:24:48 2014 
 
Copyright (c) 1982, 2005, Oracle.  All rights reserved. 
 
 
Connected to: 
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 
64bit Production 
With the Partitioning, OLAP and Data Mining options 
 
SQL> select status from v$instance; 
 
STATUS 
------------ 
OPEN 
 
SQL> alter database enable block change tracking using file '/home/oracle/bctrack.log'; 

Database altered. 


2. 0 级备份脚本 


[oracle@aix213 ~]$cat autobackup0.sh  
#!/usr/bin/bash 
#env 
export ORACLE_SID=zhang1 
export ORACLE_BASE=/u01/app/oracle  
export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1 
export PATH=$ORACLE_HOME/bin:/usr/bin 
 
#back 
$ORACLE_HOME/bin/rman<<EOF 
connect target 
 
crosscheck backup; 
 
crosscheck archivelog all; 
 
report obsolete; 
 
delete noprompt obsolete ; 

run { 
allocate  channel  c1  device  type  disk  format 
'/back/mirror/zhang_%U.bak' ; 
backup incremental level 0 database plus archivelog; 
release channel c1; 
} 
exit; 
EOF 

3. 1 级备份 
[oracle@aix213 ~]$cat autobackup1.sh  
#!/usr/bin/bash 
#env 
export ORACLE_SID=zhang1 
export ORACLE_BASE=/u01/app/oracle  
export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1 
export PATH=$ORACLE_HOME/bin:/usr/bin 
 
#back 
 
$ORACLE_HOME/bin/rman<<EOF 
connect target 

crosscheck backup; 
 
crosscheck archivelog all; 
 
report obsolete; 
 
delete noprompt obsolete; 
  
run { 
allocate  channel  c1  device  type  disk  format 
'/back/mirror/zhang_%U.bak' ; 
backup incremental level 1 database plus archivelog; 
release channel c1; 
} 
 
exit; 
EOF 
4. Crontab 设置计划 
[oracle@aix213 ~]$crontab -l 
0  *  *  *  *  sh  /home/oracle/autobackup0.sh  >> 
/home/oracle/autobackup0.log 2>&1 
15,30,45  *  *  *  *  sh  /home/oracle/autobackup1.sh  >> 
/home/oracle/autobackup1.log 2>&1