Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » Error while starting database
Error while starting database [message #324558] Tue, 03 June 2008 02:23 Go to next message
jeer
Messages: 37
Registered: February 2008
Location: pakistan
Member
Hi

When I start application server database by using "startup open", I get following error:

SQL> startup open
ORACLE instance started.

Total System Global Area 281018368 bytes
Fixed Size 789000 bytes
Variable Size 229373432 bytes
Database Buffers 50331648 bytes
Redo Buffers 524288 bytes
Database mounted.
ORA-01115: IO error reading block from file 24 (block # 4013)
ORA-01110: data file 24: 'D:\ORACLEAS\ORADATA\ORCL\GCATS1_OID.DBF'
ORA-27070: async read/write failed
OSD-04016: Error queuing an asynchronous I/O request.
O/S-Error: (OS 23) Data error (cyclic redundancy check).

Please guide me to resolve it.

Best Regards

[MERGED by LF]

[Updated on: Wed, 04 June 2008 13:04] by Moderator

Report message to a moderator

Re: error while starting database [message #324651 is a reply to message #324558] Tue, 03 June 2008 08:54 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
restore datafile or database from backup.
Re: error while starting database [message #324746 is a reply to message #324651] Tue, 03 June 2008 21:50 Go to previous messageGo to next message
jeer
Messages: 37
Registered: February 2008
Location: pakistan
Member
I dont have a backup, I have the ghost. can i restore the corrupted datafile file from ghost and replace with the old one?
Re: error while starting database [message #324747 is a reply to message #324558] Tue, 03 June 2008 21:56 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>can i restore the corrupted datafile file from ghost and replace with the old one?
NO.

You can replace the whole database from the ghost image.
Re: error while starting database [message #324748 is a reply to message #324747] Tue, 03 June 2008 22:01 Go to previous messageGo to next message
jeer
Messages: 37
Registered: February 2008
Location: pakistan
Member
Hi

If I replace just one file GCATS1_OID.DBF, then what is problem in it?

Cheers
Re: error while starting database [message #324749 is a reply to message #324558] Tue, 03 June 2008 22:29 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
The database will refuse to open.
In each & every datafile the current SCN resides.
All the SCNs must match each other or the database won't open.
If you don't believe me, try it your self;
but 1st take a complete cold backup of what you have so you can at least get back from where you started.

[Updated on: Tue, 03 June 2008 22:29] by Moderator

Report message to a moderator

Re: error while starting database [message #324750 is a reply to message #324749] Tue, 03 June 2008 22:39 Go to previous messageGo to next message
jeer
Messages: 37
Registered: February 2008
Location: pakistan
Member
datafile GCATS1_OID.DBF is corrupted on my application server. I dont know exactly what are the contents of this file and how important are these contents. What do you suggest that if I delete GCATS1_OID.DBF datafile and create it again.

cheers
Re: error while starting database [message #324751 is a reply to message #324558] Tue, 03 June 2008 22:46 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>What do you suggest that if I delete GCATS1_OID.DBF datafile and create it again.
Then you will have an empty datafile.
Why don't you have complete & recent backups?
Re: error while starting database [message #324752 is a reply to message #324751] Tue, 03 June 2008 22:51 Go to previous messageGo to next message
jeer
Messages: 37
Registered: February 2008
Location: pakistan
Member
I am scared that if i restore the full D drive from ghost image then further probles can arise. Because my operating system is on c drive and ghost image is on d drive.
Re: error while starting database [message #324753 is a reply to message #324558] Tue, 03 June 2008 22:56 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>I am scared that if i restore the full D drive from ghost image then further probles can arise.

1st take a complete cold backup of what you have so you can at least get back from where you started.

When was the ghost image made?
In other words how many hours, days, weeks of data will be lost by restoring from ghost image?

How could it be worse than having a database that won't open?

Why don't you have complete & recent backups?
Re: error while starting database [message #324755 is a reply to message #324753] Tue, 03 June 2008 23:05 Go to previous messageGo to next message
jeer
Messages: 37
Registered: February 2008
Location: pakistan
Member
I regularly take the backup of database server that is on a different machine. While proble is on Application server that is on another machine.

I take the backup using rman. By cold back you mean simply copy the contents of whole D drive?

Ghost was created 7-8 days ago and this problem arise 2 days before.

And one more question: If I restor the GCATS1_OID.DBF datafile from ghost image and then use "startup ount" and "recover database" commanad?

[Updated on: Tue, 03 June 2008 23:14]

Report message to a moderator

Re: error while starting database [message #324756 is a reply to message #324558] Tue, 03 June 2008 23:14 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>I regularly take the backup of database server
>that is on a different machine.
>While problem is on Application server
>that is on another machine.
I have NO idea how many different/specific system by count exist.

>I take the backup using rman.
Good for you.

>By cold back you mean simply copy the contents of whole D drive?
I thought the ghost image is on D drive & corrupted database is on C drive.
Do I understand correctly?
If so, take backup of C before overwriting C drive with contents of D drive.

>Ghost was created 7-8 days ago and
>this problem arise 2 days before.
2 days before WHEN?
2 days before today?
2 days before ghost image?
Re: error while starting database [message #324757 is a reply to message #324756] Tue, 03 June 2008 23:27 Go to previous messageGo to next message
jeer
Messages: 37
Registered: February 2008
Location: pakistan
Member
I have restored the GCATS1_OID.DBF datafile. Now it is asking for media recovery:

SQL> alter database open
2 ;
alter database open
*
ERROR at line 1:
ORA-01113: file 24 needs media recovery
ORA-01110: data file 24: 'D:\ORACLEAS\ORADATA\ORCL\GCATS1_OID.DBF'

Please guide me more for further steps.


Best regards
Re: error while starting database [message #324759 is a reply to message #324558] Tue, 03 June 2008 23:29 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Please guide me more for further steps.
Apply the necessary archived redo logfiles.
Re: error while starting database [message #324767 is a reply to message #324759] Tue, 03 June 2008 23:54 Go to previous messageGo to next message
jeer
Messages: 37
Registered: February 2008
Location: pakistan
Member
One more question please: If I restore my full D drive from ghost image then same problem of media recovery will occur or not?

thanks a lot

[Updated on: Wed, 04 June 2008 00:00]

Report message to a moderator

Re: error while starting database [message #324769 is a reply to message #324767] Tue, 03 June 2008 23:58 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
jeer wrote on Tue, 03 June 2008 21:54
would you please write me the steps to apply archived redo log files for media recovery?

Thanks

Do you have all the archived redo logfiles from the time
'D:\ORACLEAS\ORADATA\ORCL\GCATS1_OID.DBF'
was backed up until now?
Re: error while starting database [message #324771 is a reply to message #324769] Wed, 04 June 2008 00:02 Go to previous messageGo to next message
jeer
Messages: 37
Registered: February 2008
Location: pakistan
Member
I am not sure about archived logfiles. If I dont have then is there any other way to solve this proble. If i restore full D-drive from ghost image then the same media recovery will be needed?


thanks
Re: error while starting database [message #324777 is a reply to message #324558] Wed, 04 June 2008 00:06 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
since you do not answer all my questions, I'll not answer all of yours.

You're On Your Own (YOYO)!
Re: error while starting database [message #324779 is a reply to message #324777] Wed, 04 June 2008 00:13 Go to previous messageGo to next message
jeer
Messages: 37
Registered: February 2008
Location: pakistan
Member
Sorry Mate.

I am just checking that my database is in ARCHIVELOG Mode or NOARCHIVELOG Mode. Then I am telling you.
Re: error while starting database [message #324782 is a reply to message #324779] Wed, 04 June 2008 00:16 Go to previous messageGo to next message
jeer
Messages: 37
Registered: February 2008
Location: pakistan
Member
My database is in NOARCHIVELOG Mode Sad
Re: error while starting database [message #324783 is a reply to message #324558] Wed, 04 June 2008 00:20 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Let us review.
No archive mode & no backups.
Obviously the data had NO value.
so create a new,empty database & start from empty/scratch database.
You're On Your Own (YOYO)!
Re: error while starting database [message #324785 is a reply to message #324783] Wed, 04 June 2008 00:23 Go to previous messageGo to next message
jeer
Messages: 37
Registered: February 2008
Location: pakistan
Member
Please help me brother.

If i restore full D-drive from ghost image then the same media recovery will be needed or not?

If I delete the corrupted datafile and create a new one then the same media recovery will be needed or not?

Please guide me
Re: error while starting database [message #324795 is a reply to message #324785] Wed, 04 June 2008 00:51 Go to previous messageGo to next message
jeer
Messages: 37
Registered: February 2008
Location: pakistan
Member
anbody there?
Re: error while starting database [message #324796 is a reply to message #324795] Wed, 04 June 2008 00:52 Go to previous messageGo to next message
jeer
Messages: 37
Registered: February 2008
Location: pakistan
Member
I got a ghost image of my d-drive where Oracle Application Server is installed. If I restore full d-drive then will I need media recovery or not.

cheers
Oracle® Database Administrator's Guide [message #324800 is a reply to message #324558] Wed, 04 June 2008 02:19 Go to previous messageGo to next message
jeer
Messages: 37
Registered: February 2008
Location: pakistan
Member
Hi

One of my datafile has bad blocks. Because of that, database can just mount; database cannot be openned. I want to add new datafile; delete the previous corrupted one and rename the new datafile. Database cannot be openned. Please guide me for it

Cheers
Re: Oracle® Database Administrator's Guide [message #324973 is a reply to message #324800] Wed, 04 June 2008 12:07 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Which datafile & which tablespace?
Re: Oracle® Database Administrator's Guide [message #324990 is a reply to message #324800] Wed, 04 June 2008 13:06 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Jeer, you won't get better answer if you open a new topic for the same problem; why wouldn't you continue discussion (if any) in the original one?
Re: Oracle® Database Administrator's Guide [message #325060 is a reply to message #324990] Wed, 04 June 2008 23:10 Go to previous messageGo to next message
jeer
Messages: 37
Registered: February 2008
Location: pakistan
Member
datafile = GCATS1_OID.DBF
tablespace = OLTS_CT_STORE
Re: Error while starting database [message #325061 is a reply to message #324558] Wed, 04 June 2008 23:17 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>datafile = GCATS1_OID.DBF
>tablespace = OLTS_CT_STORE
For tablespace OLTS_CT_STORE, is GCATS1_OID.DBF file only datafile for this tablespace?
Re: Error while starting database [message #325082 is a reply to message #325061] Thu, 05 June 2008 00:02 Go to previous messageGo to next message
jeer
Messages: 37
Registered: February 2008
Location: pakistan
Member
yes, this is the only datafile in this tablespace
Re: Error while starting database [message #325083 is a reply to message #324558] Thu, 05 June 2008 00:04 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
You & you alone are responsible for any actions you take.

http://www.jlcomp.demon.co.uk/faq/drop_datafile.html

Google is your friend but only when you use it!

[Updated on: Thu, 05 June 2008 00:05] by Moderator

Report message to a moderator

Re: Error while starting database [message #325103 is a reply to message #325083] Thu, 05 June 2008 00:44 Go to previous messageGo to next message
jeer
Messages: 37
Registered: February 2008
Location: pakistan
Member
But I dont want to lose my data in this datafile
Re: Error while starting database [message #325107 is a reply to message #324558] Thu, 05 June 2008 00:52 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
what data?
If you have it (the data) then you have not lost it.
If you don't have it, I hope you have backups.
Please decide what you have or not.
Previous Topic: AS to Cleint
Next Topic: Fonts Problem
Goto Forum:
  


Current Time: Fri Mar 29 07:17:32 CDT 2024