GeekInterview.com
Series: Subject: Topic:
Question: 63 of 89

what is the difference between database refresh and database cloning

Asked by: Interview Candidate | Asked on: Feb 1st, 2007
Showing Answers 1 - 6 of 6 Answers
topdba

Answered On : Jun 14th, 2007

Essentially both are same, however one may adopt different methods for doing it. Database refresh can be done using DB utilities like RMAN, backup/restore scripts or even exp/imp whereas database cloning may involve automated scripts for cloning a target DB from a source database.

  
Login to rate this answer.
prem

Answered On : Nov 13th, 2007

Generally a database refresh is done on the same server. A database refresh is just like defragmentation in windows so that the space can be utilized more efficiently and performance also improves since the data of a segment is brought into a single extent.Generally cloning is done on 2 servers, one will have the database and the other will be used for creatng the clone database. here we are creating a replica of the current database whereas in database refresh we're just refreshing the current database.Plz tell me if i'm wrong.Thanks & regardsPrem

  
Login to rate this answer.
gurpal.sahota

Answered On : Aug 6th, 2009

View all answers by gurpal.sahota

While cloning a database we also copy the oracle home to the target node whereas in case of refresh we don't need to copy the Oracle home.

Yes  1 User has rated as useful.
  
Login to rate this answer.
sharmme

Answered On : Feb 17th, 2010

View all answers by sharmme

Database refresh is normally done for Test/DEV databases during development and test phases of App Development, where latest production cut of database is taken and applied on these environments.Cloning is creating replica of already existing databases on the same/different target hosts. Cloning doesn't necessarily involve copying Oracle Home. Database can also be cloned on the same machine.Hope this makes sense.

Yes  1 User has rated as useful.
  
Login to rate this answer.
dsp

Answered On : Aug 18th, 2011

Hi,
There is little diff between them. First we clone the d.b totally(homepath,datafiles,data.....etc) from Prod to Test, where as in D.B Refresh we just refresh the additional data which is in prod to test

For ex: CLONE ----> from Prod (50gb) to Test(50gb)
REFRESH ---> after cloing some data is added in PROD to 5g.b(50gb+5gb) where as we refreshing that 5g.b data to test d.b

Regards,
DSP

  
Login to rate this answer.
Neo

Answered On : Oct 11th, 2011

Whats the process of refresh ? ( I mean steps). Do you export/import or we take a differential backup and restore on test DB ? Any links to an article will be of great help.

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.