Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
RMAN blockrecover uses full backups only
0 views
Skip to first unread message
leczb...@gmail.com
Mar 6, 2006, 9:32:44 AM3/6/06
to
Hi!
I read in the fine Database Backup and Recovery Advanced User's Guide
(10.2.0.1), that
for using the BLOCKRECOVER feature...
"You must have a full RMAN backup. Incremental backups are not used by
block media recovery."
I would like to know if this restriction is caused by the existence of
a theoretical or a practical obstacle.
Any comments are welcome.
--
Baláz Lécz
System Engineer, Hungary
frank.va...@gmail.com
Mar 6, 2006, 9:38:17 AM3/6/06
to
Just guessing... the block is not included in the incremental backup,
or it would take too many incremental backups to find the block(s)?
or it would take too many incremental backups to find the block(s)?
Jsut 1c,
Frank van Bortel
leczb...@gmail.com
Mar 6, 2006, 9:51:36 AM3/6/06
to
Well, I just recovered _one_ corrupt block of a 120Gbyte database.
Unfortunately, the last full backup was 5 days old (we have a weekly
full backup and daily incrementals),
and the media recovery phase took 26 hours.
If the incremental backups could have been used in the first phase, the
media recovery wouldn't have taken so long (maybe 2 to 4 hours).
Unfortunately, the last full backup was 5 days old (we have a weekly
full backup and daily incrementals),
and the media recovery phase took 26 hours.
If the incremental backups could have been used in the first phase, the
media recovery wouldn't have taken so long (maybe 2 to 4 hours).
0 new messages