Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Pradeep.

Asked: November 14, 2017 - 12:54 pm UTC

Last updated: November 16, 2017 - 1:21 pm UTC

Version: 11.2.0.4

Viewed 1000+ times

You Asked

Dear Team,

I have active data guard whose flash retention policy is 1 hour and undo retention is 900. want to convert standby database to snapshot database for few days, please let me know its possible or not.

is above mention parameter is dependent to each other for snapshot. kindly help me to understand this.

also let me know flashback logs are used anywhere for recovery?

Thanks
Pradeep

and Connor said...

Yes...........maybe :-)

Snapshot standby in essence does:

- take a guaranteed restore point
- open the database read/write

Reverting back does:

- flashback database to that restore point
- put database back in recovery mode

So things you need to be aware of:

1) undo_retention is not relevant here
2) the amount of activity you do whilst in read/write mode will dictate how much flashback logging you will do (and you should be able to cater for that).
3) there are certainly operations that limit your ability to do a flashback command (and hence revert). See the Backup/Recovery documentation for details.

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Thanks for info

Pradeep prajapati, November 15, 2017 - 3:34 pm UTC

Dear Sir,

Thanks for gr8 info.. but can you please elaborate some more 3rd point i.e. 3) there are certainly operations that limit your ability to do a flashback command (and hence revert).

Thanks
Pradeep
Connor McDonald
November 16, 2017 - 1:21 pm UTC

You could always..... read the documentation!

https://docs.oracle.com/cd/E11882_01/backup.112/e10642/flashdb.htm#BRADV286
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Backup/Recovery

Check out the complete guide to all of the Backup & Recovery techniques in the Oracle Database.