Refreshing a database - help!!!

[roukie_dba]

Dear Moderators and Members

Can someone please explain to me what is meant by - a database refresh??? Does that mean dropping old data and then importing data from an up-to-date database?

Secondly, what are the proper steps to take during a database refresh???

Thanks in advance!

[padmam]

Hi, 22nd July 2001 19:27 hrs chennai

Does your Doubt pertains to Standby DB.Then the links tells the rest.

http://www.nyoug.org/busch_0920.pdf

http://www.elementkjournals.com/dbm/0101/dbm0111.htm

If not this please revert back to this thread.In search of this i learnt something more on Standby DB.

Thanks roukie_dba

Cheers

Padmam

[woldcl]

There's a really good paper at http://www.appsdba.com that tells how to refresh (clone) a database. It's under the "Papers and Presentations" section. The end of the paper is specific to Oracle Applications, but the database procedures work for any database. I've used this several times with great success using the online db backup method. Just make sure you have all of the necessary archive logs if you've taken an online backup.

Good luck!

[roukie_dba]

Thanks to both members who kindly replied to my question, I really appreciate it.