Re: dbstart -- file 'xx' needs media recovery

>When the machine rebooted oracle did not start and
>it said that file 'xxx' needs media recovery.
>
>The media was fine. I did an
>alter database recover data file 'xxx';
>
>and database was mounted ok.
>
>the only odd thing that happened was that
>the data file that oracle was complaining about was
>being backed up and END BACKUP was not done on it
>when a kill -9 was done for the backup job; but
>Oracle should have been able to recover in that case ???

If a non-parallel server instance crashes while tablespaces are in backup mode media recovery will always be required at startup for the file(s) in backup mode at the time of the crash. That's the way it's supposed to work, since checkpoints are not being recorded in the file header while the tablespace is in backup mode. Oracle did recover, just as soon as you typed in "alter database recover datafile 'xyz';".

KM Received on Tue Sep 05 1995 - 00:00:00 CEST