SQL> archive log list

Database log mode           Archive Mode

Automatic archival            Enabled

Archive destination           /u01/app/oracle/product/11.2.0/db_1/dbs/arch

Oldest online log sequence     23

Next log sequence to archive   25

Current log sequence        25

SQL>

vim rman_bak_level0.sh 

#! /bin/bash 

export ORACLE_BASE=$ORACEL_BASE

export ORACLE_HOME=$ORACLE_HOME 

export PATH=$ORACLE_HOME/bin:$PATH 

export ORACLE_SID=orcl 

export NLS_LANG='AMERICAN_AMERICA.ZHS16GBK' 

rman target / <<EOF 

run{ 

allocate channel c1 type disk; 

allocate channel c2 type disk; 

backup incremental level 0 database format '/u01/backup/level0_%d_%s_%p_%u.bak'; 

sql 'alter system archive log current'; 

backup archivelog all delete input format '/u01/backup/archivelog_%d_%s_%p_%u.bak'; 

crosscheck backup; 

delete noprompt obsolete; 

release channel c1; 

release channel c2; 

} 

>>EOF 

vim rman_bak_level1.sh  

#! /bin/bash 

export ORACLE_BASE=$ORACLE_BASE 

export ORACLE_HOME=$ORACLE_HOME 

export PATH=$ORACLE_HOME/bin:$PATH 

export ORACLE_SID=orcl

export NLS_LANG='AMERICAN_AMERICA.ZHS16GBK' 

rman target / <<EOF 

run{ 

allocate channel c1 type disk; 

allocate channel c2 type disk; 

backup incremental level 1 database format '/u01/backup/level1_%d_%s_%p_%u.bak'; 

sql 'alter system archive log current'; 

backup archivelog all delete input format '/u01/backup/archivelog_%d_%s_%p_%u.bak'; 

crosscheck backup; 

delete noprompt obsolete; 

release channel c1; 

release channel c2; 

} 

>>EOF 

vim rman_bak_level2.sh 

#! /bin/bash 

export ORACLE_SID=orcl 

export NLS_LANG='AMERICAN_AMERICA.ZHS16GBK' 

$ORACLE_HOME/bin/rman target / <<EOF 

run{ 

allocate channel c1 type disk; 

allocate channel c2 type disk; 

backup incremental level 2 database format '/u01/backup/level2_%d_%s_%p_%u.bak'; 

sql 'alter system archive log current'; 

backup archivelog all delete input format '/u01/backup/archivelog_%d_%s_%p_%u.bak'; 

crosscheck backup; 

delete noprompt obsolete; 

release channel c1; 

release channel c2; 

} 

>>EOF