Step : Create Restore point and start Testing
-- In DR database
DGMGRL> show database crmdr;
DGMGRL> edit database crmdr set state = 'APPLY-OFF';
SQL> CREATE RESTORE POINT load_test GUARANTEE FLASHBACK DATABASE;
DGMGRL> edit database crmdr set state = 'APPLY-ON';
-- in Prod database
SQL> CREATE RESTORE POINT load_test GUARANTEE FLASHBACK DATABASE;
Step : Rollback after Testing done
-- Rollback -- In Prod database
$ srvctl stop database -d crmprd
$ srvctl start instance -d crmprd -i crmprd1 -o mount
SQL> flashback database to restore point load_test;
SQL> alter database open resetlogs;
$ srvctl stop database -d crmprd
$ srvctl start database -d crmprd
-- Rollback -- In DR database
DGMGRL> edit database crmdr set state = 'APPLY-OFF';
SQL> flashback database to restore point load_test;
DGMGRL> edit database crmdr set state = 'APPLY-ON';
-- In DR database
DGMGRL> show database crmdr;
DGMGRL> edit database crmdr set state = 'APPLY-OFF';
SQL> CREATE RESTORE POINT load_test GUARANTEE FLASHBACK DATABASE;
DGMGRL> edit database crmdr set state = 'APPLY-ON';
-- in Prod database
SQL> CREATE RESTORE POINT load_test GUARANTEE FLASHBACK DATABASE;
Step : Rollback after Testing done
-- Rollback -- In Prod database
$ srvctl stop database -d crmprd
$ srvctl start instance -d crmprd -i crmprd1 -o mount
SQL> flashback database to restore point load_test;
SQL> alter database open resetlogs;
$ srvctl stop database -d crmprd
$ srvctl start database -d crmprd
-- Rollback -- In DR database
DGMGRL> edit database crmdr set state = 'APPLY-OFF';
SQL> flashback database to restore point load_test;
DGMGRL> edit database crmdr set state = 'APPLY-ON';
Usually I never comment on blogs but your article is so convincing that I never stop myself to say something about it. You’re doing a great job Man, Keep it up.mobile phone repair in Auburn Hills
ReplyDeleteiphone repair in Auburn Hills
cell phone repair in Auburn Hills
tablet repair in Auburn Hills
ipad repair in Auburn Hills
mobile phone repair Auburn Hills
iphone repair Auburn Hills
cell phone repair Auburn Hills
phone repair Auburn Hills
tablet repair Auburn Hills
Iam so thrilled because of finding your alluring website here.Actually i was searching for Oracle RAC.Your blog is so astounding and informative too..Iam very happy to find such a creative blog. Iam also find another one by mistake while am searching the same topicOracle SQL.Thank you soo much..
ReplyDeleteI am a happy person today having to have recovered a large amount of money worth 10,000, which I had lost in the hands of Bitcoin fraudulent, It has been an unfortunate year for me trying to recover my money back for the last 2months but luckily a friend of mine who also went through the same scamming issue referred me to this recovery agent called Boleyn Magic Hackers It took 3days for them to recovery the full amount at first I was hesitant and scared to believe them since I have also lost some money trying to recover my money back, But my friend assured me that they are very reliably and I decided to try it a try I have never been happy in my life until today, I would advise anyone out here trying to recover your money back you all should trust Boleyn Magic Hackers If you are a victim of bitcoin scam and believe in recovering all your lost funds, Their insights, and dedication showed me a path to success I never knew existed. This is the Email address you can use to reach out to them: Email:support@boleynonline.com. I am aware that sometimes Bitcoin cannot be recovered. However, I think it's critical to provide this choice to those who have misplaced their Bitcoin. We appreciate you offering this helpful service, Boleyn Magic Hackers (BMH). My life was spared by Boleyn Experts, which is why I am sharing this Bitcoin recovery success story in their honor. I am also appreciative of how popular Bitcoin recovery is becoming. This implies that more users will be able to use Boleyn Magic Hackers' online recovery through email:support@boleynonline.com to recover their lost Bitcoin because more people will be aware of the scam.
ReplyDelete