Home » RDBMS Server » Backup & Recovery » Rman backup mechanism (Unix,10.2.0.4)
Rman backup mechanism [message #481225] Tue, 02 November 2010 01:23 Go to next message
sekar52
Messages: 141
Registered: May 2010
Location: Mumbai
Senior Member
Hi I want to know how Rman backs up database on a block by block basis.
Consider a situation in which DBWR is writing to a datafile.Now we are backing up the datafile using RMAN.RMAN reads the datafile block by block to avoid fractured blocks.But if DBWR updates rows in 5 blocks and RMAN copies 2 blocks after DBWR updated and 3 blocks before DBWR could write wont the backup be inconsistent???


What will happen if we restore the backup in this case?
Re: Rman backup mechanism [message #481234 is a reply to message #481225] Tue, 02 November 2010 02:04 Go to previous messageGo to next message
Michel Cadot
Messages: 58595
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
A hot backup (a backup made when the database is open) is ALWAYS inconsistent, anyway you do it, this is why you have to also backup the archived logs generated during the backup.

Regards
Michel

[Updated on: Tue, 02 November 2010 02:04]

Report message to a moderator

Re: Rman backup mechanism [message #481247 is a reply to message #481234] Tue, 02 November 2010 03:21 Go to previous messageGo to next message
sekar52
Messages: 141
Registered: May 2010
Location: Mumbai
Senior Member
Then What is the advantage of taking backup with RMAN rather than taking it with begin backup mode.They say RMAn doesnt put database in backup mode..So how is archive log generation when we use RMAN for taking backup
Re: Rman backup mechanism [message #481248 is a reply to message #481247] Tue, 02 November 2010 03:30 Go to previous message
Michel Cadot
Messages: 58595
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is no difference in log generation with RMAN as the instance does not know it is currently backed up.
The advantage is not in this, it is on ALL RMAN features which is not just to not put the database in backup mode.

Regards
Michel
Previous Topic: BAckup set,backup and backup piecec
Next Topic: need inputs on RMAN Backup and Recovery for multiple restore of clean backup.
Goto Forum:
  


Current Time: Mon Jul 28 00:00:54 CDT 2014

Total time taken to generate the page: 0.04383 seconds