Last week I had to do some tests with dataguard. To make restores easier restore points were required.<\/p>\n
Given is following configuration: Two things to consider:<\/strong> First redo shipment has to be stopped: Now dataguard is running as before.<\/p>\n First switch off redo shipment:<\/p>\n Second start all three databases in mount mode:<\/p>\n Third flashback primary database:<\/p>\n Check whether flashbacked database looks fine.<\/p>\n If yes, open it read write:<\/p>\n Do the same on logical standby database:<\/p>\n Check whether flashbacked database looks fine.<\/p>\n If yes, open it:<\/p>\n Last do flashback on physical standby:<\/p>\n Last week I had to do some tests with dataguard. To make restores easier restore points were required. Given is following configuration: show configuration; Configuration – ila Protection Mode: MaxAvailability Databases: ila – Primary database ilal – Logical standby database ILAP – Physical standby database Fast-Start Failover: DISABLED Configuration Status: SUCCESS How to set restore […]<\/p>\n","protected":false},"author":27,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[],"type_dbi":[],"class_list":["post-11296","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring"],"acf":[],"yoast_head":"\n
\nshow configuration;
\nConfiguration - ila
\nProtection Mode: MaxAvailability
\n Databases:
\n ila - Primary database
\n ilal - Logical standby database
\n ILAP - Physical standby database
\nFast-Start Failover: DISABLED
\nConfiguration Status:
\n SUCCESS
\n<\/code>
\nHow to set restore points here ?<\/p>\n
\nRedo apply to a physical standby is incompatible with setting a restore point so it must me switched off for a while.
\nSCN of the restore points of the standby databases must be lower than on primary database, otherwise redo shipment does not continue after flashback.<\/p>\nSetting of restore points<\/h3>\n
\nedit database \"ilal\" set state=APPLY-OFF;
\nedit database \"ILAP\" set state=APPLY-OFF;
\n<\/code>
\nSecond, restore points on both standby databases are set:
\ncreate restore point RZ_C GUARANTEE FLASHBACK DATABASE;
\n<\/code>
\nThird, restore point on primary database is set:
\ncreate restore point RZ_C GUARANTEE FLASHBACK DATABASE;
\n<\/code>
\nLast, redo shipment is switched on again:<\/p>\nedit database \"ILAP\" set state=APPLY-ON;
\nedit database \"ilal\" set state=APPLY-ON;
\n<\/code><\/p>\nLet’s flashback the databases:<\/strong><\/h3>\n
edit database \"ILAP\" set state=APPLY-OFF;
\nedit database \"ilal\" set state=APPLY-OFF;
\n<\/code><\/p>\nshutdown immediate;
\nstartup mount;
\n<\/code><\/p>\nflashback database to restore point RZ_C;
\nalter database open read only;
\n<\/code><\/p>\nshutdown immediate;
\nstartup mount;
\nalter database open resetlogs;
\n<\/code><\/p>\nflashback database to restore point RZ_C;
\nalter database open read only;
\n<\/code><\/p>\nshutdown immediate;
\nstartup mount;
\nalter database open resetlogs;
\n<\/code><\/p>\nflashback database to restore point RZ_C;
\n<\/code>
\nNow start redo shipment again:<\/p>\nedit database \"ILAP\" set state=APPLY-ON;
\nedit database \"ilal\" set state=APPLY-ON;
\n<\/code>After a few minutes, dataguard will run as before:
\nshow configuration;
\nConfiguration - ila
\nProtection Mode: MaxAvailability
\n Databases:
\n ila - Primary database
\n ilal - Logical standby database
\n ILAP - Physical standby database
\nFast-Start Failover: DISABLED
\nConfiguration Status:
\n SUCCESS
\n<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"