| Incermental backup taking too long to complete [message #547894] |
Sun, 18 March 2012 08:21  |
janakors
Messages: 232
Registered: September 2009
|
Senior Member |
|
|
hi,
we have incremental backup taking too long to complete and initially it was taking 9 hours but now it is taking 23 hours and there is no activity performed on database so one can point that out , i am surprised by that behaviour. i increase the no of channels to two but no progress.backup script is as follows
ORACLE_HOME=/u01/app/oracle/db/product/11.2.0/dbhome
ORACLE_SID=db1
PATH=$PATH:$ORACLE_HOME/bin
export PATH
export ORACLE_HOME
export ORACLE_SID
BACKUP_MEDIA=DISK
BACKUP_TYPE=BACKUP_INCREMENTAL
TIMESTAMP=`date +%T-%m-%d-%Y`
export BACKUP_MEDIA
export BACKUP_TYPE
export TIMESTAMP
LOG=/export/home/oracle/dumps/pdumps/incr_dumps/${ORACLE_SID}_${BACKUP_TYPE}_${BACKUP_MEDIA}_${TIMESTAMP}.log
export LOG
$ORACLE_HOME/bin/rman log=$LOG <<EOF
connect target /
connect catalog rman/rman@service1
run
{
allocate channel c1 type disk format
'/export/home/oracle/dumps/pdumps/incr_dumps/${ORACLE_SID}_${BACKUP_TYPE}_${TIMESTAMP}_%p_%s.rman';
allocate channel c2 type disk format
'/export/home/oracle/dumps/pdumps/incr_dumps/${ORACLE_SID}_${BACKUP_TYPE}_${TIMESTAMP}_%p_%s.rman';
backup tag=incr_backup incremental level 1 cumulative database;
release channel c1;
release channel c2;
}
exit
EOF
kindly guide what should be tuned as dont have any clue
Regards
[Updated on: Sun, 18 March 2012 09:19] by Moderator Report message to a moderator |
|
|
|
|
|
|
|
| Re: Incermental backup taking too long to complete [message #548099 is a reply to message #547901] |
Tue, 20 March 2012 05:53  |
janakors
Messages: 232
Registered: September 2009
|
Senior Member |
|
|
thank you for reply but before the following changes, it was taking half of the current time.
let me brief you about the changes made to our database.
we had a tablespace, named DATA which contain all data files, now in our database there are two tables table1 and table2 which both contributing 98% of the total database size. so what we did is to create two different tablespaces and create these two tables (Table1 and Table2) with partitioning ON and drop old tables from DATA tablespace but didnt shrink that tablaspace, which means that if DATA tabalespace size 800 GB so the new two tablespace size is almost 800 gb
so my question is that during Incremental backup, it searches all the blocks for tracking any change which means that this backup will take double time as it now scanning DATA and other two tablespaces as well?
kindly comment
Regards
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
