By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,491 Members | 1,209 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,491 IT Pros & Developers. It's quick & easy.

Re: Changing database server location

P: n/a
pr**** (Pramod Ramachandran) wrote in message news:<66************************** 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
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.