 | |
Re: Changing database server location
comp.databases.oracle comp.databases.oracle
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Re: Changing database server location -
06-24-2003
, 07:50 AM
|
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
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.