OraFAQ Forum: Backup & Recovery » problem on starting database

Home » RDBMS Server » Backup & Recovery » problem on starting database

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

problem on starting database [message #165600]

Fri, 31 March 2006 01:00

rnemkul
Messages: 35
Registered: February 2006

Member

dear all

When I start database manually using svrmgrl
after database mount I have problem to open database
the problem is
ora-01113: file 2 needs media recovery
ORA-01110: data file 2: 'c:\oracle\oradate\orcl\rbs01.dbf'

Please suggest me what to do

Regards
Rajendra

Report message to a moderator

Re: problem on starting database [message #165605 is a reply to message #165600]

Fri, 31 March 2006 01:08

madhusunkara
Messages: 59
Registered: March 2006
Location: hyderabad,india

Member

are you running in archive log mode?

Thanks
Madhu

Report message to a moderator

Re: problem on starting database [message #165617 is a reply to message #165605]

Fri, 31 March 2006 01:30

rnemkul
Messages: 35
Registered: February 2006

Member

no i did not run archive log mode

Report message to a moderator

Re: problem on starting database [message #165652 is a reply to message #165600]

Fri, 31 March 2006 05:02

sach_sumit
Messages: 9
Registered: September 2005

Junior Member

Hi

what oracle version u r using?

Regards
Sumit Sachdeva

Report message to a moderator

Re: problem on starting database [message #165653 is a reply to message #165600]

Fri, 31 March 2006 05:02

kmsalih
Messages: 197
Registered: March 2006

Senior Member

Hi,

It is clear that you lost a datafile that belongs to rollback tablespace.

Whether your last shutdown is a normal one?

In the Mount State try the below Steps.

alter database datafile 'c:\oracle\oradate\orcl\rbs01.dbf' drop offline;

alter database open;

alter tablespace <rollback tablespace_name> add datafile 'Path of a new datafile' size <n>M;

Rgds
SALIH KM Cool

Report message to a moderator

Re: problem on starting database [message #165660 is a reply to message #165653]

Fri, 31 March 2006 05:25

sach_sumit
Messages: 9
Registered: September 2005

Junior Member

HI

In addition to what SALIM KM has suggested,

1. If in normal shutdown before error then ,

U can proceed as he has suggested as everything is in consistent state and you dont require rollback data.

2. If not normal shutdown (like abort)

In that case it will give errors whenever you will try to access data that had modified data present within the datafile rbs02.dbf at the time instance was aborted because oracle still needs that rollback to make it consistent.

So in that case whenever u will query an object that used rbs02.dbf at time of crash u will get this error message.

Select * from product;

ora - 00376: file 2 cannt be read at this time;

Also u cannt do even recovery as u r operating in NOARCHIVE LOG MODE.

Regards
Sumit Sachdeva

Report message to a moderator

Previous Topic:	export backup strategy
Next Topic:	export and import

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 10:26:08 CST 2024