| RMAN : incremental backup for tables only [message #598345] |
Mon, 14 October 2013 03:24  |
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  |
John Watson
Messages: 8964
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 |
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
