Re: HP-UX block read error - database wont come up

You need to do a datafile recovery. Your recovery options will depend upon your backup strategy.

If you are using archive log mode, then restore this datafile from backup, restore redo archive logs from backups, and use recover datafile sqldba command.

If you can afford to start the database without this datafile, mount the database, take the datafile off-line, and start your database, and do recovery.

If you can afford to lose the contents of this datafile, and associated tablespace, as is the case for index tablespaces, you can drop this tablespace, and recreate indexes.

Before attempting any kind of recovery, consider all options, and choose the one that will do job most efficiently.

Jay Mehta Received on Mon Dec 18 1995 - 00:00:00 CET