OraFAQ Forum: Server Administration » Rollback segment issue!

Home » RDBMS Server » Server Administration » Rollback segment issue!

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

Rollback segment issue! [message #158336]

Fri, 10 February 2006 00:59

puneetsachar
Messages: 97
Registered: March 2005
Location: New Delhi, India

Member

Hi,

I'm trying to brng up database from the cold back and while creating the control file i realised I don't have rollbacksegment file (rbs01) with me but I have rest of all files rbs02,rbs03,rbs04,rbs05,rbs06 with me...

and in inti<sid>.ora I have following entries..
rollback_segments = (rbs01,rbs02)

Please advice me

Puneet

Report message to a moderator

Re: Rollback segment issue! [message #158342 is a reply to message #158336]

Fri, 10 February 2006 01:31

puneetsachar
Messages: 97
Registered: March 2005
Location: New Delhi, India

Member

Hi...

I tried to copy rbs02 and rename as rbs01 and then tried to bring up DB.

Follwoing error message i got.
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01167: two files are the same file/group number or the same file
ORA-01110: data file 344: '/ora2/oradata/H003/data03/rbs02.dbf'
ORA-01110: data file 344: '/ora2/oradata/H003/data03/rbs01.dbf'

Puneet

Report message to a moderator

Re: Rollback segment issue! [message #158483 is a reply to message #158342]

Sat, 11 February 2006 18:48

SQLAREA
Messages: 21
Registered: January 2006
Location: Belgium

Junior Member

Hi,

You are proceeding in a unconvential way my friend.

Why didn' t you take a backup of the controlfile ?
Why don' t you have a backup of your rbs01 file ?

A cold backup involves a shutdown immediate or normal of the database, backup of all the datafiles and at least 1 controlfile backup.

The way you try to recreate your missing rbs01 file by copying and renaming rbs02-copy is wrong.

What you can try is
1. in your init.ora file do not reference anymore rollback segment rbs01
2. startup nomount
3. recreate your controlfile
4. alter database datafile <path>/rbs01.dbf offline drop
5. alter database open;

If you are receiving errors while opening the db you may want to take a look here http://www.fors.com/velpuri2/Backup%20and%20Recovery/LOSTROLLBACK

Take care and good luck

Regards
Guy Lambregts

Report message to a moderator

Previous Topic:	ORA-00604: error occurred at recursive SQL level 3...Please help
Next Topic:	No of Sessions in Oracle DB is exceeded

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 01 13:10:12 CDT 2025