| Reuild a database from it's files [message #49934] |
Tue, 19 February 2002 06:52  |
bakhtvar
Messages: 1
Registered: February 2002
|
Junior Member |
|
|
I built an oracle personal on a win98 system. after completing installation and migrating access database into it,on the next day win98 crached and I lost all of data and my efforts. but I could copy all of datafiles,control files,redologs,init.ora. I installed another oracle database on a different system(win98).Now I want to rebuild the database from datafiles,...
I read other articles in this faq site and others but I couldn't do it.
Thanks.
--Mahmoud
|
|
|
|
| Re: Reuild a database from it's files [message #49942 is a reply to message #49934] |
Tue, 19 February 2002 17:23  |
seng
Messages: 191
Registered: February 2002
|
Senior Member |
|
|
If you still have all of database files - datafile,control file, redologs, init.ora and other file then you are able to clone another database. I have experienc in NT/Window2002 to clone the database, and i think that it is not much of difference(try reference to manual first)
Method 1.
In NT/Windows2000, Below is the step
1. Create Oracle service with same DB_NAME(similar as init.ora) and Oracle Sid and point to init.ora (parameter file).Below is the command -
ORADIMxx -NEW -SID -INTPWD -STARTMODE -PFILE
2. Copy the datafile,controlfiles and redologs into same direcory as old system.
Note:
a. if you have binary file of control file then you must have same directory as old system for datafile and redo log file. For you information, backup control file to trace and keep a copy of control trace file (text format), which is easy to clone other same database.
b. Please keep a copy of backup before try this method.
3. Makesure the setting of environment is correct. Especially, ORACLE_SID -
e.g
SET ORACLE_SID=
4. Start the Oracle Service
e.g
NET START
Note: Oracle service must start before logon into SVRMGRL
5. Logon in SVRMGRL.
SVRMGR>CONNECT / AS SYSDBA;
SVRMGR>STARTUP;
If you won't see any error in this step then you have cloned the database.
Method 2.
I think Oracle Assistance Tool should be able to help. I haven't try this method. Please check.
Hopefully, this will help you.
|
|
|
|
| hi [message #50948 is a reply to message #49934] |
Tue, 16 April 2002 02:10 |
y.balhtvar
Messages: 1
Registered: April 2002
|
Junior Member |
|
|
Hi
a am y.bakhtwar.
from iran.i am student in tehran.
if you have time send mail for me.
please send your complete name and information about your.
goodbye
bakhtvar
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
