OraFAQ Forum: Backup & Recovery » Rman incremental backup size increased.

Home » RDBMS Server » Backup & Recovery » Rman incremental backup size increased. (oracle 11g)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Rman incremental backup size increased. [message #458174]

Thu, 27 May 2010 13:09

nadvi
Messages: 46
Registered: May 2006
Location: Canada

Member

In a two node RAC database, usually the RMAN incremental file size is around 400-500 MB and RMAN full file size is around 10GB.
Suddenly the RMAN incremental file size has increased to around 16-17 GB and there were no expansion on datafile size/data volume/DB block size etc.

it's an incremental backup,

Following command used for RMAN.

crosscheck archivelog all;
delete noprompt expired archivelog all;
backup format '/u04/rman/DB_INC_%T_%U' INCREMENTAL LEVEL 1 TAG = 'weekly_incremental' as compressed backupset database plus archivelog format '/u04/rman/DB_ARCH_%T_%U' delete input;
delete noprompt obsolete;

No changes are done in rman settings or rman command.

No significant changes observed in data size too. And it seems like, the rman has taken full backup considering the file size.

What could be reason for sudden increase of RMAN incremental file size?

Thanks

Database:
BANNER
Oracle Database 11g Release 11.1.0.6.0 - 64bit Production
PL/SQL Release 11.1.0.6.0 - Production
CORE 11.1.0.6.0 Production
TNS for Linux: Version 11.1.0.6.0 - Production
NLSRTL Version 11.1.0.6.0 - Production

OS:
Linux node1 2.6.18-92.1.22.el5 #1 SMP Tue Dec 16 11:57:43 EST 2008 x86_64 x86_64 x86_64 GNU/Linux

Report message to a moderator

Re: Rman incremental backup size increased. [message #458179 is a reply to message #458174]

Thu, 27 May 2010 13:32

Mahesh Rajendran
Messages: 10572
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Increased transactions?
Check the number of archived logs generated for the specified period of time.

Report message to a moderator

Re: Rman incremental backup size increased. [message #458180 is a reply to message #458179]

Thu, 27 May 2010 14:05

nadvi
Messages: 46
Registered: May 2006
Location: Canada

Member

Archived log number, size and transaction count checked and found almost similiar to recent days.

Report message to a moderator

Re: Rman incremental backup size increased. [message #458949 is a reply to message #458180]

Wed, 02 June 2010 12:51

cloeffel
Messages: 2
Registered: June 2010
Location: Canada

Junior Member

Check if you don't have new materialized view on the DB.

This can increase redolog by the refresh frequency.

Report message to a moderator

Previous Topic:	error occurred while backup the database
Next Topic:	CREATE CONTROLFILE failed, physical block size 2048 does not match size 512 of other members

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 19 06:25:45 CDT 2013

Total time taken to generate the page: 0.12076 seconds