Home » RDBMS Server » Backup & Recovery » Rman incremental backup size increased. (oracle 11g)
Rman incremental backup size increased. [message #458174] Thu, 27 May 2010 13:09 Go to next message
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

Re: Rman incremental backup size increased. [message #458179 is a reply to message #458174] Thu, 27 May 2010 13:32 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10621
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Increased transactions?
Check the number of archived logs generated for the specified period of time.
Re: Rman incremental backup size increased. [message #458180 is a reply to message #458179] Thu, 27 May 2010 14:05 Go to previous messageGo to next message
nadvi
Messages: 46
Registered: May 2006
Location: Canada
Member

Archived log number, size and transaction count checked and found almost similiar to recent days.
Re: Rman incremental backup size increased. [message #458949 is a reply to message #458180] Wed, 02 June 2010 12:51 Go to previous message
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.
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:
  


Current Time: Mon Sep 01 03:13:23 CDT 2014

Total time taken to generate the page: 0.23837 seconds