472,354 Members | 2,059 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,354 software developers and data experts.

Re: Changing database server location

pr****@rtimes.com (Pramod Ramachandran) wrote in message news:<66**************************@posting.google. com>...
Hi group,

I have been into database administration for quite some time, but have
not tried changing the database server location.

I have two questions for you

1. I have a requirement that the db has to be moved to a new Win 2000
server from an existing one. Can I do this without reconfiguring the
clients. The clients runs a Java program which uses a connection
string pointing to the db location. Is there a way to "route" the
connection requests to the new location from the original location or
is their any other mechanism ?

2. I have read that recovering from user using a clone database. Is
this the only way of recovery from user errors ? What about TSPITR and
what is the difference between these two types of recovery strategies


Pramod Ramachandran

Permit me start with the second question.
It would be easier to be more precise if it were pinned down to a
specific situation.Anyway .........
User errors vary widely ,It may not be feasible to pinpoint all the
different user errors.Depending on the rights a user has ,user errors
may span from deleting a the contents of a table to deleting
datafile(s).Solving user errors may range from typing rollback on
the command line to recreating the database or........
Oracle documentation may help .

TSPITR (Oracle 8 and above) Enables recovery of one or more non system
tablespaces to a point in time that is different than that of the
If all the tables you want to recover are located in a single
then a tablespace point in time recovery would be adequate.

1)Backup and restore to the new server(if it is configured the same as
the present one).
Install a database in the new server with all the existing schemas Do
a full database export/import
Edit the connection string of the java client to point to your new

reconfigure TNS files appropriately
Jun 27 '08 #1
0 1323

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: Cherrish Vaidiyan | last post by:
sir, The following are the steps that i followed in setting up standby database on Red hat Linux 9. i am using Oracle 9i. i have followed the steps in this site : ...
by: amnésia | last post by:
Hi there. I have to change the drive letter where SQL server have his datfiles (master included). If I do that, ob the SQL fail to start, becouse it's unable to find the master datfiles. Is it...
by: Michelle Stone | last post by:
Hi all I recently changed the schema of a dataset (added one field, and changed another field type from STRING to DATE). I want this reflected in my Crystal Reports Designer. Please don't...
by: gopi | last post by:
when installing db2, it only asks for installation directory and does not ask where it is going to store data files. how can i change the default directory after installation.
by: mplus_2000 | last post by:
I have recently inherited a database. The switchboard (and other forms) displays the name of the database on it (top, center). Currently the name that appears is Reviews. There are plans to roll...
by: astolpho | last post by:
I am using a slightly outdated reference book on J2EE programming. It gives 2 methods of creating a database used in its casestudies. The first is an ANT script that gives the following output: ...
by: Jonathan Wood | last post by:
I have a Web application. Initially, I created a database in the App_Data folder and then attached it to SQL Servero 2005 (not SQL Server Express). I realize now that this is now what I want. So...
by: franc sutherland | last post by:
Hi everyone, I am using Access 2003. I have a database with a table in it which is linked to an excel spreadsheet. When I install the database on someone else's system, the pathname to the...
by: hmznzr | last post by:
i am using b.net 2005. i am generating a crystal report. but when i work in a different computer i have to set the location of the database of the report before i generate. is their any dynamic way...
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and efficiency. While initially associated with cryptocurrencies...
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge required to effectively administer and manage Oracle...
by: jalbright99669 | last post by:
Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made but the http to https rule only works for...
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was proposed, which integrated multiple engines and...
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. header("Location:".$urlback); Is this the right layout the...
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it so the python app could use a http request to get...
by: AndyPSV | last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and...
by: Carina712 | last post by:
Setting background colors for Excel documents can help to improve the visual appeal of the document and make it easier to read and understand. Background colors can be used to highlight important...
by: Rahul1995seven | last post by:
Introduction: In the realm of programming languages, Python has emerged as a powerhouse. With its simplicity, versatility, and robustness, Python has gained popularity among beginners and experts...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.