knill
asked on
Instance ORCL has been terminated
We use Oracle Workroup 8.0.5.0.0
When we try restart database, it shutdown yourself. In event log are warnings 'All process in instance ORCL stopped' and 'Instance ORCL has been terminated'.
When I could find some desription of problem. Exists eny log file, where the database inicialization is described? The databse worked fine last 4 months and now there were not enougth disk space, but after disk clering there is 1.5 GB. Database size is 4 GB.
When we try restart database, it shutdown yourself. In event log are warnings 'All process in instance ORCL stopped' and 'Instance ORCL has been terminated'.
When I could find some desription of problem. Exists eny log file, where the database inicialization is described? The databse worked fine last 4 months and now there were not enougth disk space, but after disk clering there is 1.5 GB. Database size is 4 GB.
ASKER
There is ORA-1122.
When I tried to open databas throw Instance manager (at first I tried it just by services restart), there are these errors: (from Czech translation)
ORA-01122: check dabasase file 5 error
ORA-01110: databsase file 5 D:\...\dispecer.ora
ORA-01200: real file size 2062868 is less then real size 2063360 of block
When I tried to open databas throw Instance manager (at first I tried it just by services restart), there are these errors: (from Czech translation)
ORA-01122: check dabasase file 5 error
ORA-01110: databsase file 5 D:\...\dispecer.ora
ORA-01200: real file size 2062868 is less then real size 2063360 of block
did somebody try to restore these file or touch it by anyway ?
As it appears, somebody touch the file and changed it's size,
you can get the file offline and startup your database for start, then I suggest take a cold backup of this file by copy it to some other place and see how you can restore it.
As it appears, somebody touch the file and changed it's size,
you can get the file offline and startup your database for start, then I suggest take a cold backup of this file by copy it to some other place and see how you can restore it.
ASKER
And how can I get this file offline a how can I restore it, whne I don't have backup?
for putting the datafile offline
you need to startup the database in mount mode - run svrmgr30 from command prompt, connect internal, enter the command startup mount".
then you put the datafile offline by, alter database datafile offline '<file name with the path>' offline;
then you can alter your database open, by "alter database open".
What is this datafile has tables or indexes ?
you need to startup the database in mount mode - run svrmgr30 from command prompt, connect internal, enter the command startup mount".
then you put the datafile offline by, alter database datafile offline '<file name with the path>' offline;
then you can alter your database open, by "alter database open".
What is this datafile has tables or indexes ?
ASKER
I wrote:
alter database datafile offline '<d:\orant\database\dispec
and it wrote me ORA-02236: wrond file name.
This datafile has tables and indexes of cca 10 users.
alter database datafile offline '<d:\orant\database\dispec
and it wrote me ORA-02236: wrond file name.
This datafile has tables and indexes of cca 10 users.
ASKER
I already wrote it right but now it returns to me:
ORA-01145: it must by recovery from media
ORA-01145: it must by recovery from media
does the database has startup ?
ASKER
Yes, database is mouted. I tried get file offline by:
alter database datafile 'd:\orant\database\dispece
alter database datafile 'd:\orant\database\dispece
can you select from tables that in other datafiles ?
ASKER
I can't connect the database because it is just mounted (not opened). It wrotes to me ORA-01033: ORACLE inicialization or shudown in process and when I connect to INTERNAL user I can select just fixed tables (ORA-01219).
what happen if you write alter database open ?
ASKER
It wrotes:
ORA-01122: check dabasase file 5 error
ORA-01110: databsase file 5 D:\...\dispecer.ora
ORA-01200: real file size 2062868 is less then real size 2063360 of block
ORA-01122: check dabasase file 5 error
ORA-01110: databsase file 5 D:\...\dispecer.ora
ORA-01200: real file size 2062868 is less then real size 2063360 of block
did you change the datafile to be offline ?
when you write the offline command remove the "<" and ">"
it should be like this :
alter database datafile 'd:\orant\database\dispece
and then try to get the database open
when you write the offline command remove the "<" and ">"
it should be like this :
alter database datafile 'd:\orant\database\dispece
and then try to get the database open
ASKER
It is the problem. I can't change the datafile offline. When I try it it returns:
ORA-01145: immedite offline is forbidden, when recovery from media is not activated
ORA-01145: immedite offline is forbidden, when recovery from media is not activated
ASKER
Adjusted points to 300
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I already set datafile to recover status. Can I do something to set datafile inline and don't lost data?
What this means is that your file was somehow truncated.
Did you do a restore, or copy the file from elswhere? If yes restore again, or copy again.
If not then you have basically lost this file. You will have to drop it to bring the database up.
Did you do a restore, or copy the file from elswhere? If yes restore again, or copy again.
If not then you have basically lost this file. You will have to drop it to bring the database up.
If you can afford to lose this datafile then do the following:
1.. Make a backup of all the datafiles.
2.. From Server Manager, connect internal and do:
startup mount
ALTER DATABASE DATAFILE 'd:\orant\database\dispece
ALTER DATABASE;
DROP TABLESPACE tablespace_name_for _this_file INCLUDING CONTENTS;
This should bring the database up. Then recreate the tablespace with the datafile.
1.. Make a backup of all the datafiles.
2.. From Server Manager, connect internal and do:
startup mount
ALTER DATABASE DATAFILE 'd:\orant\database\dispece
ALTER DATABASE;
DROP TABLESPACE tablespace_name_for _this_file INCLUDING CONTENTS;
This should bring the database up. Then recreate the tablespace with the datafile.
The alert file you can find in the path you wrote in the parameter "ackground_dump_dest" in your init<sid>.ora file.
The init<sid>.ora file is in %ORACLE_HOME%/database
What are the changes you made ?