Home » RDBMS Server » Backup & Recovery » Incremental Backup (10g,xp)
Incremental Backup [message #471487] Sun, 15 August 2010 11:41 Go to next message
zahidbashir
Messages: 34
Registered: September 2009
Member
Oracle documentation says "Incremental backups capture on a block-by-block basis changes in your database since a previous incremental backup".
I created level 0 backup
RMAN> backup incremental level 0 tablespace users;


Now after creating the level 0 backup, i created the level 1 backup

RMAN> backup incremental level 1 tablespace users;


RMAN successfully created level 1 backup, creating a file in flash_recovery_area.
I executed the above two RMAN command simultaneously. During this time, nothing changed in the database. So what exactly the new level 1 backup contains? As none of the blocks are changed.
Re: Incremental Backup [message #471488 is a reply to message #471487] Sun, 15 August 2010 11:45 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Are you sure nothing changed? Oracle is ALWAYS working in the background.

Regards
Michel

[Updated on: Sun, 15 August 2010 11:46]

Report message to a moderator

Re: Incremental Backup [message #471489 is a reply to message #471488] Sun, 15 August 2010 11:52 Go to previous messageGo to next message
zahidbashir
Messages: 34
Registered: September 2009
Member
Yeah you are right Smile I mean i didn't change anything in the users tablespace.
Re: Incremental Backup [message #471579 is a reply to message #471487] Mon, 16 August 2010 04:02 Go to previous messageGo to next message
Yasir Hashmi
Messages: 304
Registered: April 2006
Senior Member
Did you compare the size of the two backups?

RMAN>list backup of tablespace users;
Re: Incremental Backup [message #471580 is a reply to message #471579] Mon, 16 August 2010 04:03 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Even if users don't do anything, Oracle may, for instance for incremental checkpoint.

Regards
Michel
Previous Topic: Ctrl+x of the database files. Can I restore it?
Next Topic: Flash Recovery Area
Goto Forum:
  


Current Time: Thu Mar 28 18:48:58 CDT 2024