我看有一本书上说oracle11g r2不支持2级增量备份,我想知道11g到底支不支持2级增量备份。oracle11grman
解决方案 »
- 一些基础的Oracle DBA笔试题和面试题目
- 关于to_date和to_char oracle数据库数据的查找和修改
- sql优化
- 求助:数据库运行一段时间后就提示ORA-01033错误
- 如何把Oracle(某些表某些字段)数据导到另一个ORACLE数据中表中,表名和字段名都可能不同!
- 咋办咋办啊..
- 请教高手 oracle中的sql语句如何改写成sqlserver中sql
- 我导出的表是TABLE1,imp的时候,我可以把表名导入为TABLE2吗??
- 在VB中,如何对ORACLE中的BLOB字段进行存取操作
- ORACLE存储过程编写问题????(ORACLE菜鸟)
- VS2010连接Oracle11g报错 ORA-12560:TNS错误
- 【求助】OTL使用一个问题,程序core掉,蛋疼
# incremental level 0 backup scriptsource /home/oracle/.bash_profilecurrent_day=`date +%Y%m%d`
full_day=102_full_$current_day
mkdir /data/oracle/ora_backup/$full_day
echo '-------------------------------------------------------------------------'
echo "-- Begin Full Backup of DB 10.103.23.102 DateTime: `date` --"
echo '-------------------------------------------------------------------------'
rman target / <<EOF
run
{
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 14 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/data/oracle/ora_backup/$full_day/PID-%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 4;
crosscheck backup;
delete noprompt obsolete;
delete noprompt expired backup;
allocate channel dev1 type disk maxpiecesize=30720M;
allocate channel dev2 type disk maxpiecesize=30720M;
allocate channel dev3 type disk maxpiecesize=30720M;
allocate channel dev4 type disk maxpiecesize=30720M;
backup as compressed backupset incremental level 0 tag='db0'
format '/data/oracle/ora_backup/$full_day/%n_%T_%U' database;
sql 'alter system archive log current';
backup archivelog all format '/data/oracle/ora_backup/$full_day/arc_%n_%T_%U' delete all input;
release channel dev1;
release channel dev2;
release channel dev3;
release channel dev4;
}
EOF
echo '------------------------------------------------------------------------'
echo "-- End Full Backup of DB 10.103.23.102 DateTime: `date` --"
echo '------------------------------------------------------------------------'
scp -l 51200 -r /data/oracle/ora_backup/$full_day [email protected]:/data/oracle/ora_backup102 &
wait
echo '------------------------------------------------------------------------'
echo "-- End of Send file to 10.103.23.103 DateTime: `date` --"
echo '------------------------------------------------------------------------'
echo ''
echo ''
# incremental level 0 backup scriptsource /home/oracle/.bash_profilecurrent_day=`date +%Y%m%d`
incr_day=102_incr_$current_day
mkdir /data/oracle/ora_backup/$incr_day
echo '-------------------------------------------------------------------------'
echo "-- Begin Increment Backup of DB 10.103.23.102 DateTime: `date` --"
echo '-------------------------------------------------------------------------'
rman target / <<EOF
run
{
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 14 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/data/oracle/ora_backup/$incr_day/PID-%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 4;
crosscheck backup;
delete noprompt obsolete;
delete noprompt expired backup;
allocate channel dev1 type disk maxpiecesize=30720M;
allocate channel dev2 type disk maxpiecesize=30720M;
allocate channel dev3 type disk maxpiecesize=30720M;
allocate channel dev4 type disk maxpiecesize=30720M;
backup as compressed backupset incremental level 1 tag='db1'
format '/data/oracle/ora_backup/$incr_day/%n_%T_%U' database;
sql 'alter system archive log current';
backup archivelog all format '/data/oracle/ora_backup/$incr_day/arc_%n_%T_%U' delete all input;
release channel dev1;
release channel dev2;
release channel dev3;
release channel dev4;
}
EOF
echo '------------------------------------------------------------------------'
echo "-- End Increment Backup of DB 10.103.23.102 DateTime: `date` --"
echo '------------------------------------------------------------------------'
scp -l 51200 -r /data/oracle/ora_backup/$incr_day [email protected]:/data/oracle/ora_backup102 &
wait
echo '------------------------------------------------------------------------'
echo "-- End of Send file to 10.103.23.103 DateTime: `date` --"
echo '------------------------------------------------------------------------'
echo ''
echo ''