RMAN 非归档模式 备份shell脚本:
0级备份
#!/bin/sh
export PATH
export TMP=/tmp
export TMPDIR=/tmp
export ORACLE_BASE=/opt/oracle
exportORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
export ORACLE_SID=orclbj
export PATH=$PATH:$ORACLE_HOME/bin:
exportLD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
rman target / nocatalog msglog=bak0.log<< EOF
run{
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FORDEVICE TYPE DISK TO '/opt/bak/con_%F_%T.tar.bz2';
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
configure device type disk parallelism 1backup type to compressed backupset;
report obsolete;
delete noprompt obsolete;
crosscheck backup;
delete noprompt expired backup;
shutdown immediate;
startup mount;
backup incremental level=0 database format'/opt/bak/bak_%T_%t_%d.tar.bz2';
shutdown immediate;
startup;
}
EOF
1级累积备份:
#!/bin/sh
#### 2011.6.27 ####
#level=1#
export PATH
export TMP=/tmp
export TMPDIR=/tmp
export ORACLE_BASE=/opt/oracle
exportORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
export ORACLE_SID=orclbj
export PATH=$PATH:$ORACLE_HOME/bin:
exportLD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export BAKFILE=/opt/bak/bak1.log
rman nocatalog target / msglog $BAKFILE<< EOF
run{
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FORDEVICE TYPE DISK TO '/opt/bak/con1_%F_%T.tar.bz2';
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
configure device type disk parallelism 1backup type to compressed backupset;
report obsolete;
delete noprompt obsolete;
crosscheck backup;
delete noprompt expired backup;
shutdown immediate;
startup mount;
backup incremental level=1 cumulativedatabase format '/opt/bak/bak1_%T_%t_%d.tar.bz2';
shutdown immediate;
startup;
}
EOF