Workaround for Oracle database Start-up report ora-01122,ora-01110,ora-01203 errors

ORACLE database space bare device is out of the problem, startOracle failure, workaround
Problem phenomenon:
StartOracle reported the following error:
Database mounted.
Ora-01122:database File 6 failed verification check
Ora-01110:data file 6: '/dev/raw/rlv_cbs_user_dat '
Ora-01203:wrong incarnation of this file-wrong creation SCN
Problem solving:
There is a problem with this database space, you need to delete the database space and then add it again
The correct step should be to remove the database space
The first step is to executeShutdown immediate command to stop the database first
Step Two, executeStart Mount command starts the database
The third step is to set the data file toOffline status
ALTER DATABASE datafile '/dev/raw/rlv_cbs_user_dat ' offline drop;
It is important to note that the parameters of the third step must beOffline drop;
I wrote it from the beginning, and it was an error.
ALTER DATABASE datafile '/dev/raw/rlv_cbs_user_dat ' offline; I execute this sentence
ERROR at line 1:
Ora-01145:offline immediate disallowed unless media recovery enabled
Fourth Step,ALTER DATABASE open;
Fifth Step,Drop Tablespace Cbs_user_dat;
The fifth step was executed with the following error.
ERROR at line 1:
Ora-00604:error occurred at recursive SQL level 1
Ora-02429:cannot DROP index used for enforcement of Unique/primary key
Typically, this is removed.Cbs_user_dat the user in this table space will be able to drop the success
Find out which users are in this database space first
Select Username,default_tablespace from dba_users where default_tablespace= 'cbs_user_dat ';

I deleted the user or reported the above error
Below, find out what indexes are in this table space.
Select Owner,tablespace_name,index_name from dba_indexes where tablespace_name= ' Cbs_user_dat ';
This time can delete the index, I deleted the index when the error
I will directly delete this database user, although the user is not in the Cbs_user_dat, this time to remove the table space
You can delete the success.

Table space Deletion is successful and you can add tablespaces

http://blog.csdn.net/cannoesword/article/details/6023636