| 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
|
|
|
|
|
|
| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
