Home » RDBMS Server » Backup & Recovery » Incermental backup taking too long to complete (oracle 11.2.0.1 RAC of two nodes,solaris10)
Incermental backup taking too long to complete [message #547894] Sun, 18 March 2012 08:21 Go to next message
janakors
Messages: 180
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 #547896 is a reply to message #547894] Sun, 18 March 2012 09:22 Go to previous messageGo to next message
Michel Cadot
Messages: 65848
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is a cumulative incremental backup so it takes longer each time until you take another level 0 backup.
Watch your IO and CPU.
Post your confugration.

Regards
Michel
Re: Incermental backup taking too long to complete [message #547901 is a reply to message #547894] Sun, 18 March 2012 10:53 Go to previous messageGo to next message
John Watson
Messages: 7619
Registered: January 2010
Location: Global Village
Senior Member
Have you enabled block change tracking, for fast incremental backups?
http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmbckba.htm#sthref876
Re: Incermental backup taking too long to complete [message #548099 is a reply to message #547901] Tue, 20 March 2012 05:53 Go to previous messageGo to next message
janakors
Messages: 180
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
Re: Incermental backup taking too long to complete [message #548101 is a reply to message #548099] Tue, 20 March 2012 05:58 Go to previous message
John Watson
Messages: 7619
Registered: January 2010
Location: Global Village
Senior Member
You have doubled the size of your database, and the backup takes twice as long. Now, who would have expected that?
I've already told you what to do about it.
Bored
Previous Topic: Restore failed - 10.2.0.1.0
Next Topic: RMAN command hang long time
Goto Forum:
  


Current Time: Sat Oct 20 03:14:03 CDT 2018