469,348 Members | 1,303 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,348 developers. It's quick & easy.

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 1190

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Cherrish Vaidiyan | last post: by
2 posts views Thread by amnésia | last post: by
3 posts views Thread by Michelle Stone | last post: by
9 posts views Thread by gopi | last post: by
5 posts views Thread by Jonathan Wood | last post: by
7 posts views Thread by franc sutherland | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.