Can you tell me the difference between clone database and standby database? Is it that clone db can't be used for disaster recovery?
In many cases, there is no difference. Oracle's idea of a clone db is a standby db. But the standby db has one more thing that does distinguish it from some clone db's. A standby db has the ability to replay transactions from the master, so as to always keep the standby up to date. Some other vendors' clone db implementations may only have the clone up to date with the master at the time of the cloning operation.
Dig Deeper on Oracle database administration
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs.
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command.
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming.