tag:blogger.com,1999:blog-2530682427657016426.post4728530247071300030..comments2024-03-28T08:29:25.033+01:00Comments on Marko Sutic's Database Blog: Using Flashback Database to perform PITRMarko Sutichttp://www.blogger.com/profile/08926232581329666732noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-2530682427657016426.post-32410322826844069052010-08-25T23:29:05.778+02:002010-08-25T23:29:05.778+02:00Aman,
thanks ;)
Regards,
MarkoAman,<br /><br />thanks ;)<br /><br />Regards,<br />MarkoMarko Sutichttps://www.blogger.com/profile/08926232581329666732noreply@blogger.comtag:blogger.com,1999:blog-2530682427657016426.post-77704221015993972252010-08-25T09:20:43.879+02:002010-08-25T09:20:43.879+02:00Lother,
flashback database is faster and easier i...Lother,<br /><br />flashback database is faster and easier in some cases because it doesn't require restoring the whole database.<br /><br />I've added this line at the beginning my blog post because there was written that flashback database is always much less time consuming which is not true.<br /><br />Thanks for noticing.<br /><br />Regards,<br />MarkoMarko Sutichttps://www.blogger.com/profile/08926232581329666732noreply@blogger.comtag:blogger.com,1999:blog-2530682427657016426.post-50526687991707420542010-08-25T09:11:25.494+02:002010-08-25T09:11:25.494+02:00Damir,
enabling flashback logging brings slight o...Damir,<br /><br />enabling flashback logging brings slight overhead on disk usage and storage but this is the price you have to pay if you want to have extended undo functionality. You are correct, it is not always convenient to enable this feature.<br /><br />Btw, I think that flashback logs are not essential for recovery and I've never noticed that database was unrecoverable because of missing flashback logs. Full backup and archived redo logs should be enough.<br /><br />I will check online - maybe someone reproduced error you are talking about...<br /><br />Best regards,<br />MarkoMarko Sutichttps://www.blogger.com/profile/08926232581329666732noreply@blogger.comtag:blogger.com,1999:blog-2530682427657016426.post-31346658365238916472010-08-25T01:48:12.466+02:002010-08-25T01:48:12.466+02:00Question:
Is db backup is done on the same disk (...Question: <br />Is db backup is done on the same disk (not tape) as flashback (let us suppose ASM), what is the benefit to have flashback recover instead of classic RMAN one?<br />LotherAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-2530682427657016426.post-2683382159681229322010-08-25T01:15:49.517+02:002010-08-25T01:15:49.517+02:00Hi!
db_flashback_retention_target and
db_recover...Hi!<br /><br />db_flashback_retention_target and <br />db_recovery_file_dest_size params are crucial to have proper flashback strategy according db size and change. This is very inconvenient in a case of OLTP database and smaller storage.<br /><br />And then, when all is setup properly, you need take care for flashback backup.... special kind of backup which must be a part of database backup strategy. I have seen a db with flashback as part of db backup that was unrecoverable because of lack of flashback part of backup.<br /><br />All other nice and this is where Oracle is going for sure...<br /><br />Damir Vadas<br />http://damir-vadas.blogspot.comDamir Vadashttps://www.blogger.com/profile/15963017378937428976noreply@blogger.comtag:blogger.com,1999:blog-2530682427657016426.post-21883066696864290102010-08-24T11:43:15.808+02:002010-08-24T11:43:15.808+02:00Very nice Marko :).
Aman....Very nice Marko :).<br /><br />Aman....Aman....http://blog.aristadba.comnoreply@blogger.com