| reinstall oracle server using existing d:\oracle\product,, [message #477084] |
Tue, 28 September 2010 06:58  |
sojus
Messages: 2
Registered: September 2010
|
Junior Member |
|
|
hi,
can anyone please give pointers howto to setup an oracle server and "import" my old databases just from the copied directory structure d:\oracle\product\... ("cold backup") to the new install.
i was trying to setup an new server by shutting down the db and just copying back my data/control/log/*.ora files which doesnt seem to work.
i could see the old tables structures in the local sqlplus console, but the databases are not reachable over the net.
also the enterprise manager is not able to startup the dbs, it show just an running listener.
any hints and pointers are highly appreciated.
thanks in advance.
best regards
|
|
|
|
|
|
| Re: reinstall oracle server using existing d:\oracle\product,, [message #477105 is a reply to message #477092] |
Tue, 28 September 2010 10:10  |
sojus
Messages: 2
Registered: September 2010
|
Junior Member |
|
|
just to explain my situation, i was asked by someone who accidently changed the partiton table on a db server to get back their data. after doing this the next question was to reinstall the db server...
regarding the install:
version/os: oracle 10.2.0.4 x64 on win2008
just to make sure what is the relevant data fir the task:
config files:
init.ora listener.ora tnsnames.ora sqlnet.ora
dbs:
D:\_backup\_recover_d\oracle\product\10.2.0\oradata\db1 with files:
control01-03.ctl
redo01-03.log
sysaux01.dbf
system01.dbf
temp01.dbf
undotbf01.dbf
users01.dbf
..
D:\_backup\_recover_d\oracle\product\10.2.0\oradata\dbx
------------
question about the procedure for reinstall / import old data:
-install a clean oracle hserver to D:\oracle\product\10.2.0
(with default options, no demo dbs or something?; is there a way to see what options where used when installing the old server)
-shutdown the db
-copy over the recovered dirs (see above) to D:\oracle\product\10.2.0\oradata
-copy over resp. edit config files (*.ora, see above)
-restart the db server
-connect the recovered/imported dbs local or remote
can i assume that this procedure should work normally?
best regards
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
