OraFAQ Forum: Backup & Recovery » difference between cloning database and standby database

Home » RDBMS Server » Backup & Recovery » difference between cloning database and standby database

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

difference between cloning database and standby database [message #317942]

Mon, 05 May 2008 01:26

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 ...

Report message to a moderator

Re: difference between cloning database and standby database [message #317950 is a reply to message #317942]

Mon, 05 May 2008 01:43

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: difference between cloning database and standby database [message #336383 is a reply to message #317950]

Sat, 26 July 2008 03:50

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

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

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

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

Report message to a moderator

Re: difference between cloning database and standby database [message #336713 is a reply to message #336595]

Mon, 28 July 2008 14:36

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.

Report message to a moderator

Previous Topic:	Error Restore New Host
Next Topic:	How to disable OS interrupts during RMAN operations

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 02 17:03:06 CST 2025