| 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
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
