Home » RDBMS Server » Backup & Recovery » difference between cloning database and standby database
difference between cloning database and standby database [message #317942] Mon, 05 May 2008 01:26 Go to next message
rukmambara_babu
Messages: 15
Registered: April 2008
Junior Member
hi,

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 ...
Re: difference between cloning database and standby database [message #317950 is a reply to message #317942] Mon, 05 May 2008 01:43 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
A clone is a copy of database at one point in the time.
A standby database is a copy that updates itself to always be an uptodate copy.

From Database Concepts:
Quote:
A clone database is a specialized copy of a database that can be used for tablespace point-in-time recovery. When you perform tablespace point-in-time recovery, you mount the clone database and recover the tablespaces to the desired time, then export metadata from the clone to the primary database and copy the datafiles from the recovered tablespaces.

Quote:
standby database:
A copy of a production database that you can use for disaster protection. You can update the standby database with archived redo logs from the production database in order to keep it current. If a disaster destroys the production database, you can activate the standby database and make it the new production database.


Regards
Michel
Re: difference between cloning database and standby database [message #336383 is a reply to message #317950] Sat, 26 July 2008 03:50 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

Before synchronising primary database with standby database , we found some of the current datafiles missing ( to be synced with standby db)in primary database(may be deleted accidently).i want to synced the missing datafiles with standby database.Please provide me the steps to sync missing datafiles(primary db) with standby database.


Regards
Balaji

[Updated on: Sat, 26 July 2008 03:50]

Report message to a moderator

Re: difference between cloning database and standby database [message #336419 is a reply to message #336383] Sat, 26 July 2008 10:20 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Don't hijack others topic, this has no connection with the original question.

Also this is not the correct forum to post this question. Read the list.

Regards
Michel

[Updated on: Sat, 26 July 2008 10:21]

Report message to a moderator

Re: difference between cloning database and standby database [message #336595 is a reply to message #317942] Mon, 28 July 2008 05:51 Go to previous messageGo to next message
in.lukfai
Messages: 8
Registered: July 2008
Location: India
Junior Member
Hope this could help :

http://download-west.oracle.com/docs/cd/B10500_01/server.920/a96572/ostspitr.htm

http://download-uk.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmtspit001.htm

Regards,

Katie
Re: difference between cloning database and standby database [message #336713 is a reply to message #336595] Mon, 28 July 2008 14:36 Go to previous message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member
cloning cannot be logical or physical Very Happy

Standby can be logical or physical standby Wink

cloning of db done to create test db from production server while stand-by is there for high availability and disaster recovery purpose.

standby is always get updated with the help of online redolog but clone db once it is made have not relation with its parent DB, clone db can have its own data

stand-by always have same data as primary db.
Previous Topic: Error Restore New Host
Next Topic: How to disable OS interrupts during RMAN operations
Goto Forum:
  


Current Time: Sat Dec 03 14:14:08 CST 2016

Total time taken to generate the page: 0.07294 seconds