Home » RDBMS Server » Backup & Recovery » RMAN : incremental backup for tables only (11G, Redhat 5)
RMAN : incremental backup for tables only [message #598345] Mon, 14 October 2013 03:24 Go to next message
mamingui
Messages: 83
Registered: July 2006
Member
Hi All,

I've a little question : Is it possible to use RMMAN to backup 2 tables incrementally ?
I don't want to backup all the database but only these 2 tables.
Thanks in advance for your answer.
Re: RMAN : incremental backup for tables only [message #598346 is a reply to message #598345] Mon, 14 October 2013 03:32 Go to previous messageGo to next message
John Watson
Messages: 4569
Registered: January 2010
Location: Global Village
Senior Member
Think it through, and the answer will be clear. Backing up a table would require identifying which blocks make up the table. That would require access to the data dictionary, where this information is stored (and visible in views such as dba_extents). Therefore, to make a table backup would require the database to be open - otherwise, the data dictionary cannot be read. So if table backups were possible, a cold backup would be impossible. A backup tool that could not backup a closed database would be useless.
Does that help? I find that thinking about architecture will answer most questions.
--
update - minor typo

[Updated on: Mon, 14 October 2013 03:33]

Report message to a moderator

icon2.gif  Re: RMAN : incremental backup for tables only [message #598347 is a reply to message #598345] Mon, 14 October 2013 03:42 Go to previous messageGo to next message
Michel Cadot
Messages: 59147
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You cannot backup tables but if the tables are alone on one or several tablespaces, you can then backup these tablespaces.

Re: RMAN : incremental backup for tables only [message #598348 is a reply to message #598345] Mon, 14 October 2013 03:42 Go to previous messageGo to next message
Lalit Kumar B
Messages: 2346
Registered: May 2013
Location: World Wide on the Web
Senior Member
mamingui wrote on Mon, 14 October 2013 13:54
Is it possible to use RMMAN to backup 2 tables incrementally ?
I don't want to backup all the database but only these 2 tables.


Read the documentation, it says, the goal of an RMAN incremental backup is to backup only those data blocks......

http://docs.oracle.com/cd/B19306_01/backup.102/b14192/bkup004.htm

[Updated on: Mon, 14 October 2013 03:43]

Report message to a moderator

Re: RMAN : incremental backup for tables only [message #598358 is a reply to message #598346] Mon, 14 October 2013 05:05 Go to previous message
gazzag
Messages: 316
Registered: November 2010
Location: Bristol, UK
Senior Member
Sorry, am I missing something? Where does the OP mention backing up a closed database?
Previous Topic: Database Recovery
Next Topic: Connection to Rman
Goto Forum:
  


Current Time: Sat Sep 20 23:58:58 CDT 2014

Total time taken to generate the page: 0.08020 seconds