Handy Bunawan
4th October 2006, 22:04
Dear all,
Anyone knows about how to use this session?
Actually, I have a problem in our development server. After stopping some session and restared the server, the database was not opened. When I tried to startup the Baan, this messages appeared :
ORA-01115:IO error reading block from file 19 (block # 437098)
ORA-01110:data file 19:'data\baan6.dbf
ORA-27070;skgfdisp:asynchronous I/O request.
and we can not logged into Baan.
After drop the datafile, we can startup the database and logged into Baan.
But in DBA Studio, the data file (data\baan6.dbf) was offline. TO bring it online, it needs recovery. Since we don't do any backup/recovery in oracle, we can not recover the datafile.
I intent to create a new database and set it as Baan database (the old database will no longer be used).
But how to do it? I mean, what are the steps?
FYI, I changed the parameters in ttaad4510m000 and convert it to runtime. Then I can not logged into Baan. I think I can not logged into Baan because I didnt create the tables needed in the new database before.
Pls advise.
Thanks and regards,
Handy
Anyone knows about how to use this session?
Actually, I have a problem in our development server. After stopping some session and restared the server, the database was not opened. When I tried to startup the Baan, this messages appeared :
ORA-01115:IO error reading block from file 19 (block # 437098)
ORA-01110:data file 19:'data\baan6.dbf
ORA-27070;skgfdisp:asynchronous I/O request.
and we can not logged into Baan.
After drop the datafile, we can startup the database and logged into Baan.
But in DBA Studio, the data file (data\baan6.dbf) was offline. TO bring it online, it needs recovery. Since we don't do any backup/recovery in oracle, we can not recover the datafile.
I intent to create a new database and set it as Baan database (the old database will no longer be used).
But how to do it? I mean, what are the steps?
FYI, I changed the parameters in ttaad4510m000 and convert it to runtime. Then I can not logged into Baan. I think I can not logged into Baan because I didnt create the tables needed in the new database before.
Pls advise.
Thanks and regards,
Handy