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
?

TIA

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
database.
If all the tables you want to recover are located in a single
tablespace
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
server.

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.