Re: Changing database server location

From: michael ngong <mngong_at_yahoo.com>
Date: 24 Jun 2003 05:50:39 -0700
Message-ID: <ecf365d5.0306240450.2e16e737_at_posting.google.com>


pramod_at_rtimes.com (Pramod Ramachandran) wrote in message news:<6616e304.0306240122.4dd3ecd5_at_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 Received on Tue Jun 24 2003 - 14:50:39 CEST

Original text of this message