| loading dbf files [message #142329] |
Fri, 14 October 2005 03:05  |
rajeev_jain2001
Messages: 12
Registered: October 2005
|
Junior Member |
|
|
hi
my oracle is corrupted. now i need to do fresh installation.
my.dbf files are intact. is there any way i can get my data back.
|
|
|
|
| Re: loading dbf files [message #142334 is a reply to message #142329] |
Fri, 14 October 2005 03:40  |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
Yes you can , just install Oracle software and use these .dbf files . look into copying database .
But if it is in continuation with your previous post then i dont think that Oracle S/W is corrupted because you are able to use the tools like sqlplus .
Can you please tell us , how you come to a conclusion that Oracle S/W needs a reinstallation .
regards,
tarun
|
|
|
|
| Re: loading dbf files [message #142336 is a reply to message #142334] |
Fri, 14 October 2005 04:07 |
rajeev_jain2001
Messages: 12
Registered: October 2005
|
Junior Member |
|
|
hi
thanks for ur reply
while launching Oracle 9i on win 2000.
actually when creating database in oracle my system gets restarted.
when i tried to logon to my oracle it says
ORA-01033:Oracle initilization or shut down in progress.
plz help me to over come this problem
|
|
|
|
| Re: loading dbf files [message #142337 is a reply to message #142334] |
Fri, 14 October 2005 04:09 |
rajeev_jain2001
Messages: 12
Registered: October 2005
|
Junior Member |
|
|
hi
thanks for ur reply
while launching Oracle 9i on win 2000.
actually when creating database in oracle my system gets restarted.
control file contains entry for that db but actullay db is not created and system gets restarted.
when i tried to logon to my oracle it says
ORA-01033:Oracle initilization or shut down in progress.
plz help me to over come this problem
|
|
|
|
| Re: loading dbf files [message #142338 is a reply to message #142334] |
Fri, 14 October 2005 04:09 |
rajeev_jain2001
Messages: 12
Registered: October 2005
|
Junior Member |
|
|
hi
thanks for ur reply
while launching Oracle 9i on win 2000.
actually when creating database in oracle my system gets restarted.
control file contains entry for that db but actullay db is not created and system gets restarted.
when i tried to logon to my oracle it says
ORA-01033:Oracle initilization or shut down in progress.
plz help me to over come this problem
|
|
|
|
| Re: loading dbf files [message #142339 is a reply to message #142337] |
Fri, 14 October 2005 04:12 |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
| rajeev_jain2001 wrote on Fri, 14 October 2005 14:39 |
actually when creating database in oracle my system gets restarted.
control file contains entry for that db but actullay db is not created and system gets restarted.
|
As you said above, it means that no database is created on your machine so how will you login to Oracle Database ?
You need to create a new database again . Use DBCA (Database configuration assistant) to create a new database . You can find this tool in Oracle menu.
|
|
|
|
|
|
| Re: loading dbf files [message #142345 is a reply to message #142340] |
Fri, 14 October 2005 04:28 |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
Oops , 5 databases but you didnt tell that in your first post.
Then i dont think there should be problem , follow these steps and i think you should be able to access any other database .
1. Turn off and disable even , the service running with the SID name of the database that you were trying to create and failed.
2. Start the service of any of the database ( as you told 5) , which was in working condition.
3. Set the environment variable ORACLE_SID pointing to that database.
4. Try to login to that database as 'sys' using sqlplus.
Note : Always come up with the complete information regarding the server at your very first post . In that case it will take less time to solve your problem .
|
|
|
|
| Re: loading dbf files [message #142360 is a reply to message #142345] |
Fri, 14 October 2005 06:11 |
rajeev_jain2001
Messages: 12
Registered: October 2005
|
Junior Member |
|
|
hi
Now i am able to logon to oracle enterprise mgr as a sysdba.
but it doesnt open any database.
in the datafile there is a file of thedatabase that is not at ora92/dbs folder.
when i tried it to take it offline it gives me error like databse not open.
i want that table space entry to be removed from control file. that i think will resolve my problem
|
|
|
|
| Re: loading dbf files [message #142362 is a reply to message #142360] |
Fri, 14 October 2005 06:15 |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
what command did you give to take that datafile offline ?
try this
Bringing Datafiles Online or Taking Offline in ARCHIVELOG Mode
To bring an individual datafile online, issue the ALTER DATABASE statement and include the DATAFILE clause.The following statement brings the specified datafile online:
ALTER DATABASE DATAFILE '/u02/oracle/rbdb1/stuff01.dbf' ONLINE;
To take the same file offline, issue the following statement:
ALTER DATABASE DATAFILE '/u02/oracle/rbdb1/stuff01.dbf' OFFLINE;
Taking Datafiles Offline in NOARCHIVELOG Mode
To take a datafile offline when the database is in NOARCHIVELOG mode, use the ALTER DATABASE statement with both the DATAFILE
and OFFLINE DROP clauses. This enables you to take the datafile offline and drop it immediately. It is useful, for example, if
the datafile contains only data from temporary segments and
has not been backed up and the database is in NOARCHIVELOG mode.
The following statement takes the specified datafile offline:
ALTER DATABASE DATAFILE '/u02/oracle/rbdb1/users03.dbf' OFFLINE DROP;
regards,
tarun
[Updated on: Fri, 14 October 2005 06:17] Report message to a moderator |
|
|
|
| Re: loading dbf files [message #142365 is a reply to message #142362] |
Fri, 14 October 2005 06:29 |
rajeev_jain2001
Messages: 12
Registered: October 2005
|
Junior Member |
|
|
hi
when i tried offline drop it says databse altered.
but when i tried opening enterprise mgr
it says oracle initilazition or shut down in progress.(same error) as before.
tell me what to do
|
|
|
|
| Re: loading dbf files [message #142367 is a reply to message #142365] |
Fri, 14 October 2005 06:33 |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
Are you trying to access the same database that was failed due to restart of server???????
Can you restart the server , if yes then do it and give a try again ?
|
|
|
|
|
|
| Re: loading dbf files [message #142373 is a reply to message #142371] |
Fri, 14 October 2005 07:06 |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
I wrote
| Quote: |
Are you trying to access the same database that was failed due to restart of server???????
|
you have 5 database which one you are trying to access ??
The one which failed during creation or already existing database .
If trying to access already existing database then this problem should not persist .
But if you are trying to access the failed database instance then it would be better to recreate it because as i know it doesnt contain anything important , is it ??
|
|
|
|
| Re: loading dbf files [message #142376 is a reply to message #142329] |
Fri, 14 October 2005 07:15 |
rajeev_jain2001
Messages: 12
Registered: October 2005
|
Junior Member |
|
|
i am unable to log on to any db whether working or failed from sqlplus.
and at enterprise mgr how to log on to any specific db i dont know bcuse it doesnt ask for any db
|
|
|
|
| Re: loading dbf files [message #142379 is a reply to message #142376] |
Fri, 14 October 2005 07:25 |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
Leave EM aside for the time being and try to login using SQLPLUS .
Now lets assume that one of your database SID is 'DB1' . So lets follow step by step process --
1. Set the ORACLE_SID environment variable to 'DB1' .
2. Close all other oracle database services and just start the service related to 'DB1' i.e. "OracleServiceDB1" . Now lets assume its up and running and all other services are closed .
3. Now open SQLPLUS and try to login with the 'sys/your_password' as sysdba .
4. If connected to idle instance then startup the database .
Now follow the above steps and then post the exact step where you encountered the error .
Dont forget to close other database SID services , i repeat close all other "OracleService" running on your machine.
And dont use EM , work from SQLPLUS first , because only then you would be able to know the exact cause of error.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
