Friday, 2 November 2012

Can Oracle’s Data Guard be used on Standard Edition, and if so how? How can you test that the standby database is in sync? | Oracle 10g Interview Questions

 Oracle’s Data Guard technology is a layer of software and automation built on top of the standby database facility. In Oracle Standard Edition it is possible to be a standby database, and update it *manually*. Roughly, put your production database in archive log mode. Create a hot backup of the database and move it to the standby machine. Then create a standby control file on the production machine, and ship that file, along with all the archived redo log files to the standby server. Once you have all these files assembled, place them in their proper locations, recover the standby database, and you’re ready to roll. From this point on, you must manually ship, and manually apply those archived redo logs to stay in sync with production.
To test your standby database, make a change to a table on the production server, and commit the change. Then manually switch a log file so those changes are archived. Manually ship the newest archived redo log file, and manually apply it on the standby database. Then open your standby database in read-only mode, and select from your changed table to verify those changes are available. Once you’re done, shutdown your standby and start up again in standby mode.

No comments: