-
Hi,
My Nt server has crashed .
It was having Oracle 8.0 server on it.
There is no chance of gettinh the NT Server reparied.
I have all the files which were used in creating the database.
I am also able to backup the physical files of data.
I want to recover the data from these physical files.
is it possible to create a new database using the files above and then recover the data fromn the datafiles..
pls help me out
rgds
Deepak Kapila
-
Don't worry you can create the database again if you have all the database files and archived files
use this command
use the same init.ora file if you have
in svrmgrl
STARTUP NOMOUNT
CREATE CONTROLFILE SET DATABASE "" RESETLOGS ARCHIVELOG
MAXLOGFILES 64
MAXLOGMEMBERS 5
MAXDATAFILES 1022
MAXINSTANCES 16
MAXLOGHISTORY 1600
LOGFILE
GROUP 1 'DISK$REDO1:database_THR1_GRO1_MEM1.RDO' SIZE 50M,
GROUP 2 'DISK$REDO1:database_THR1_GRO2_MEM1.RDO' SIZE 50M,
GROUP 3 'DISK$REDO1:database_THR1_GRO3_MEM1.RDO' SIZE 50M
DATAFILE
'datafile1',
'datafile2',
'datafile3';
resore database using backup controlfile until cancel;
then it will ask you for archived redo log file
provide all the archived redo log files you have and then in the end type
cancel
alter database open reset redologs;
this will open your database by creating new control files and new online redo log files.
and then you can play with it again.
Hope that this will solve your problem.
UKDBA
-
thanks UKDBA ....
U HAVE BOOSTED MY ENTHU
This command i have to run from the prompt..i'll try...
but can i create the database using the database assistant
shipped with the oracle enterpriise manager...
rgds
Deepak Kapila
dpkpl@rediffmail.com
-
well to be honest i am not found of gui thinggy provided by oracle . i prefered command line so that you can use it in every operating system. To be honest i don't know about configuration assistant.
but there is no harm running them on server manager.
ukdba
-
UKDBA,
WOULD U PLS. TELL ME THE SEQUENCE IN WHICH TO
EXCUTE THE COMMANDS
RGDS
KAPILA
-
Hi,
can any body explain me the steps one by one
to recover the data.
i have only operating system copies of the databse files
and the datafiles.
rgds
Deepak Kapila
-
In your other post you told that your database is not running in archived log mode. The recovery method UKDBA explained is for databases in archive log mode.
You can restore the database if you have a cold backup.
Sanjay
-
Sanjay would u pls tell me the steps to do that..
rgds
Deepak Kapila
dpkpl@rediffmail.com
-
C if your database was not running in archive log mode.
then u just need to install oracle as it was earlier.
then restore the cold backup. crete sid and you will be able to make your database up.
thatz it.
so steps are :
- Install oracle (use same conventions as it was earlier)
- Restore backup from your cold backup.
- Create new sid
start the services and bring the database up..
not very big deal.....
--------------------------
The Time has come ....
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|