OraFAQ Forum: Weblogic & Application Server » Error while starting database

Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » Error while starting database

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Error while starting database [message #324558]

Tue, 03 June 2008 02:23

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

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

restore datafile or database from backup.

Report message to a moderator

Re: error while starting database [message #324746 is a reply to message #324651]

Tue, 03 June 2008 21:50

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?

Report message to a moderator

Re: error while starting database [message #324747 is a reply to message #324558]

Tue, 03 June 2008 21:56

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.

Report message to a moderator

Re: error while starting database [message #324748 is a reply to message #324747]

Tue, 03 June 2008 22:01

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

Report message to a moderator

Re: error while starting database [message #324749 is a reply to message #324558]

Tue, 03 June 2008 22:29

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

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

Report message to a moderator

Re: error while starting database [message #324751 is a reply to message #324558]

Tue, 03 June 2008 22:46

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?

Report message to a moderator

Re: error while starting database [message #324752 is a reply to message #324751]

Tue, 03 June 2008 22:51

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.

Report message to a moderator

Re: error while starting database [message #324753 is a reply to message #324558]

Tue, 03 June 2008 22:56

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?

Report message to a moderator

Re: error while starting database [message #324755 is a reply to message #324753]

Tue, 03 June 2008 23:05

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

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?

Report message to a moderator

Re: error while starting database [message #324757 is a reply to message #324756]

Tue, 03 June 2008 23:27

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

Report message to a moderator

Re: error while starting database [message #324759 is a reply to message #324558]

Tue, 03 June 2008 23:29

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Please guide me more for further steps.
Apply the necessary archived redo logfiles.

Report message to a moderator

Re: error while starting database [message #324767 is a reply to message #324759]

Tue, 03 June 2008 23:54

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

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?

Report message to a moderator

Re: error while starting database [message #324771 is a reply to message #324769]

Wed, 04 June 2008 00:02

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

Report message to a moderator

Re: error while starting database [message #324777 is a reply to message #324558]

Wed, 04 June 2008 00:06

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)!

Report message to a moderator

Re: error while starting database [message #324779 is a reply to message #324777]

Wed, 04 June 2008 00:13

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.

Report message to a moderator

Re: error while starting database [message #324782 is a reply to message #324779]

Wed, 04 June 2008 00:16

jeer
Messages: 37
Registered: February 2008
Location: pakistan

Member

My database is in NOARCHIVELOG Mode Sad

Sad

Report message to a moderator

Re: error while starting database [message #324783 is a reply to message #324558]

Wed, 04 June 2008 00:20

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)!

Report message to a moderator

Re: error while starting database [message #324785 is a reply to message #324783]

Wed, 04 June 2008 00:23

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

Report message to a moderator

Re: error while starting database [message #324795 is a reply to message #324785]

Wed, 04 June 2008 00:51

jeer
Messages: 37
Registered: February 2008
Location: pakistan

Member

anbody there?

Report message to a moderator

Re: error while starting database [message #324796 is a reply to message #324795]

Wed, 04 June 2008 00:52

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

Report message to a moderator

Oracle® Database Administrator's Guide [message #324800 is a reply to message #324558]

Wed, 04 June 2008 02:19

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

Report message to a moderator

Re: Oracle® Database Administrator's Guide [message #324973 is a reply to message #324800]

Wed, 04 June 2008 12:07

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Which datafile & which tablespace?

Report message to a moderator

Re: Oracle® Database Administrator's Guide [message #324990 is a reply to message #324800]

Wed, 04 June 2008 13:06

Littlefoot
Messages: 21823
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?

Report message to a moderator

Re: Oracle® Database Administrator's Guide [message #325060 is a reply to message #324990]

Wed, 04 June 2008 23:10

jeer
Messages: 37
Registered: February 2008
Location: pakistan

Member

datafile = GCATS1_OID.DBF
tablespace = OLTS_CT_STORE

Report message to a moderator

Re: Error while starting database [message #325061 is a reply to message #324558]

Wed, 04 June 2008 23:17

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?

Report message to a moderator

Re: Error while starting database [message #325082 is a reply to message #325061]

Thu, 05 June 2008 00:02

jeer
Messages: 37
Registered: February 2008
Location: pakistan

Member

yes, this is the only datafile in this tablespace

Report message to a moderator

Re: Error while starting database [message #325083 is a reply to message #324558]

Thu, 05 June 2008 00:04

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

jeer
Messages: 37
Registered: February 2008
Location: pakistan

Member

But I dont want to lose my data in this datafile

Report message to a moderator

Re: Error while starting database [message #325107 is a reply to message #324558]

Thu, 05 June 2008 00:52

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.

Report message to a moderator

Previous Topic:	AS to Cleint
Next Topic:	Fonts Problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 21 15:50:15 CST 2024