As a DBA, many time We need to make some tests on our databases(such as performance, load test etc… ) Many times its very hard to create same setup to get correct result for our tests.
For this purpose Oracle database can support Guaranteed Restore points feature . And now If you have dataguard system than you can use also snapshot standby database feature for your test purposes.
We can convert existing physical standby database to snapshot standby database which is as close as to the production database. Snapshot standby database can be open in write/open mode.
After related tests have been done,We can convert snapshot standby database to physical standby database easily in minutes.
Read the rest of this entry »