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

Saad Ahmad (sahmad_at_mfa.com) wrote:
: The machine ( HP 9000) running HP-UX and Oracle 7
 

: 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 ???

yes and no...Oracle doesn't know how to do instance recovery when a tablespace is in hotbackup mode because it's possible that it needs archive logs to do that recovery. So when the database crashed in the middle of a hotbackup, the DBA will need to issue the recover database command and (possibly) point the db to the place where the needed archive logs are.

Johnny Chan
Independent Oracle Specialist Received on Tue Sep 05 1995 - 00:00:00 CEST