| ramesh |
Posted: Sep 11, 2008 08:58:56 AM |
Total Post: 77
Joined: Dec, 2006
|
Hi.
My dbase is not configured in archive mode,
and i found data block corruption in a specific datafile while starting up the database.
so created new control file using "backup control file" cmd
and using no-restlogs option is started tried to start database,
but this did not worked and oracle was searching for some archive dbf files
following error occured
ORA-00279: change 41465640 generated at 09/11/2008 14:16:02 needed for thread 1
ORA-00289: suggestion : /oracle/oracle9i/dbs/arch1_3290.dbf
ORA-00280: change 41465640 for thread 1 is in sequence #3290
ORA-00308: cannot open archived log 'ALTER'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
and in case any input it throws out and says
media recovery incomplete .
can anybody tell me where i'm going wrong.
|
|
|
 vino |
| Posted: Sep 11, 2008 09:37:22 AM |  |
|
Total Post: 357
Joined: Aug, 2008
|
Hi Ramesh,
have you applied the cold backup for this work. If yes, then try
>recover database;
>alter database open noresetlogs;
|
|
|
|
|
| ramesh |
| Posted: Sep 11, 2008 09:57:14 AM | |
|
Total Post: 77
Joined: Dec, 2006
|
Vino
i did not get u, cold backup.?
i simply commented the corrupted datafile in the control file and tried to startup using the new control file.
|
|
|
|
|
| vino |
| Posted: Sep 11, 2008 10:17:09 AM | |
|
Total Post: 357
Joined: Aug, 2008
|
Oh, I took up dat in diff scenario.. Fine, you can offline that particular datafile and open the database if you want.. Also, you can check the datafile consistency using dbverify utility..
Regards.
|
|
|
|
|
| ramesh |
| Posted: Sep 12, 2008 02:01:09 AM | |
|
Total Post: 77
Joined: Dec, 2006
|
dear vino
now the dbase is down and how can i take the datafile offline.
i guess it cannot b done in mount stage
plz guide me..
|
|
|
|
|
| vino |
| Posted: Sep 12, 2008 05:11:05 AM | |
|
Total Post: 357
Joined: Aug, 2008
|
Hi Ramesh,
Since, you have recreated your controlfile then, startup your database in mount stage. s, You can start it to mount stage. then issue the sql stmt
>alter tablespace tablespace name offline;
>alter database open noresetlogs;
Since you donot have the cold backup of datafile, you will not be able to recover it. So, better drop dat tablespace or datafile and proceed with the database.
Regards.
|
|
|
|
|
| GOPU |
| Posted: Sep 12, 2008 04:03:10 PM | |
|
Total Post: 340
Joined: Apr, 2008
|
Offline....If he needed that datafile ??
Do you have backup?
which is your oracle version?
which tablespace datafile is corrupted ?
|
|
|
|
|
| GOPU |
| Posted: Sep 12, 2008 04:04:38 PM | |
|
Total Post: 340
Joined: Apr, 2008
|
if he fire the recover database command it will again ask for the archive file.....??
|
|
|
|
|
| ramesh |
| Posted: Sep 13, 2008 01:45:31 AM | |
|
Total Post: 77
Joined: Dec, 2006
|
Hi. Gopi
version is 9i
and i hav only logical backup.
anyways i hav succeded in starting up the database.
Thnks
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
